Registered aircraft · 25,370

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:80-25-07-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-25-07-R1') ORDER BY n_number

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:80-25-07-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-25-07-R1')
  ORDER BY n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:80-25-07-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-25-07-R1')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N2506ZKisser Karl J · Anchorage, AKBuilt 1977 · S/N 614-77 N2507AMann Robert M · Royal Oak, MIBuilt 1978 · S/N 38-78A0722 N2507DMurphy Robert Joseph · Galveston, TXS/N 38-79A0344 N2507FMorley Thomas O · Emmett, IDS/N 122 N2507JDarter Lloyd R · Mountain Grove, MOBuilt 1979 · S/N T18803469T N2507PSailor Dog Aviation LLC · Portland, ORS/N 38-79A1016 N2508FBailey Joseph H · Port Saint Lucie, FLBuilt 1965 · S/N 7ECA-123 N2508ZAmelia Reid Aviation LLC · San Jose, CABuilt 1978 · S/N 1249-78 N25091Piper Aircraft Inc · Vero Beach, FLBuilt 1979 · S/N 38-80A0029 N2509AEagle Aviation LLC · Benton, KYBuilt 1978 · S/N 38-78A0724 N2509ZKovach Kim A · Ocala, FLS/N 333-77 N250LMenefee Scott A · Los Banos, CABuilt 1979 · S/N R18200936 N250RAReynolds Darryl G · Wills Point, TXFirst renewal noticeBuilt 1975 · S/N 17266043 N2510GCollum Aviation LLC · Milton, FLBuilt 1967 · S/N 403 N2510ZCherry Hill Aviation Inc · Freetown, INBuilt 1977 · S/N 256-77 N2511798x LLC · Caddo Mills, TXBuilt 1970 · S/N 17259514 N2511FBradley Cole Mckee · Temple, TXBuilt 1965 · S/N 126 N2512LHartsock Jane R · Laurens, IABuilt 1979 · S/N 38-79A0741 N2512NArias Kevin · Cheverly, MDBuilt 1979 · S/N 38-79A0856 N2512ZPlane Old Fun LLC · Mckinney, TXBuilt 1977 · S/N 334-77 N25137Piper Aircraft Inc · Vero Beach, FLBuilt 1979 · S/N 38-80A0034 N2513AHarris Alden F · Shrewsbury, MABuilt 1978 · S/N 38-78A0727 N2513FKeller Jeffrey B · Mount Ulla, NCBuilt 1965 · S/N 129 N25140Piper Aircraft Inc · Vero Beach, FLBuilt 1979 · S/N 38-80A0036 N2514ZDarnoc LLC - Series 6 · Spicewood, TXBuilt 1977 · S/N 992-77 N2515ZMarker Richard A · Healdsburg, CABuilt 1977 · S/N 347-77 N2516BPearlsnap Solutions LLC · Georgetown, TXBuilt 1978 · S/N 38-79A0101 N2516CStrong Don E Jr · Mountain Home, ARBuilt 1978 · S/N 38-79A0211 N2516FBourne Cynthia A · Melbourne, FLBuilt 1965 · S/N 7ECA-133 N2516VGreat Adventure Sailing Vessell LLC · Greer, SCBuilt 1974 · S/N 177RG0601 N2517BJobe Dwaine B · Chilhowee, MOBuilt 1978 · S/N 38-79A0102 N2518FWill Larry P · Fort Collins, COBuilt 1966 · S/N 136 N2518GVintage Aviation Inc · Garden City, NYBuilt 1967 · S/N 166 N2518LKerber John · Decorah, IABuilt 1979 · S/N 38-79A0749 N2518ZAircraft & Aviation Professionals LLC · Coldwater, MIBuilt 1977 · S/N 616-77 N2519ZWatson Bobby M · Hoxie, ARBuilt 1977 · S/N 993-77 N251DMBandt Johnathan Paul · South Milwaukee, WIBuilt 2000 · S/N 1284-99 N251HPKoch & Koch Inc · Grass Valley, CABuilt 1982 · S/N 172RG1124 N251JBVan Horne Robert E · Centralia, ILBuilt 1965 · S/N 21 N251MANorris Suzanne W · Howe, IDBuilt 2003 · S/N 1346-2003 N251RAReynolds Darryl G · Wills Point, TXFirst renewal noticeBuilt 1975 · S/N 17266249 N251WCThyssen Patrick L · Conroe, TXBuilt 2000 · S/N 424-2000 N2520ARaptor Flight LLC · Fort Worth, TXS/N 38-78A0730 N2520BRegistration Pending · Cheshire, CTRegistration pendingBuilt 1978 · S/N 38-79A0105 N25216Mcfarlane Claude L III · Fitchburg, WIBuilt 1977 · S/N 15280534 N25221Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15280538 N25225Howard Jeff S · Anderson, SCBuilt 1977 · S/N 15280541 N25228Laguna Verde Leasing Inc · Wilmington, DES/N 15280543 N2522CKlamecki Alan P · Phoenix, AZBuilt 1978 · S/N 38-79A0216 N25233Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15280545

Back to AD 80-25-07 R1