Skip to content

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.

N5284XJay Heather R · Chico, CABuilt 1969 · S/N 218 N52851Mcnamee Brian E · Pompano Beach, FLBuilt 1977 · S/N 177RG1287 N5285HChild Cris · Mapleton, UTBuilt 1975 · S/N 17265395 N5285KBoland Mark J · Anchorage, AKBuilt 1980 · S/N 17274045 N5285VMiddletown Regional Flight Training Institute LLC · Middletown, OHBuilt 1980 · S/N 172RG0495 N52862Klosterman Sean M · Seattle, WABuilt 1977 · S/N 177RG1290 N5286EButler Bill · Juntura, ORBuilt 1978 · S/N 17271815 N5286HNieves Irvyn T · Vega Baja, PRBuilt 1975 · S/N 17265396 N5286PSzabo Arthur J · Hurley, NYBuilt 1981 · S/N 15284907 N5286TWilson Aviation LLC · Robinson, ILBuilt 1984 · S/N R18201849 N52871North Cardinal LLC · Crookston, MNBuilt 1977 · S/N 177RG1294 N52877Weight Malcom E · Spanish Fork, UTBuilt 1981 · S/N 17274626 N52878Martin Carver Jessica · Bowling Green, KYS/N 177RG1297 N5287ATax Busters Inc · El Paso, TXBuilt 1979 · S/N 21063349 N5287ELin LLC · Dunn, NCBuilt 1978 · S/N 17271816 N5287YMorrow Aviation LLC · Midland, TXS/N 21064152 N52881Cardinal Air · Gold Hill, NCBuilt 1977 · S/N 177RG1298 N52882Qdp Inc · Cincinnati, OHBuilt 1977 · S/N 177RG1299 N52885Foster David F · Potomac, MDBuilt 1977 · S/N 177RG1300 N52889Waters Steven D · Kingwood, TXBuilt 1981 · S/N 17274628 N5288GC&B Air Services LLC · Wilmington, DES/N 24-1641 N52890Schlafly Sheila B · Miami, FLBuilt 1977 · S/N 177RG1301 N52891Registered aircraftBuilt 1981 · S/N 17274629 N52894Craren Michael J · Holliston, MABuilt 1977 · S/N 177RG1302 N5289EFlightco Inc · Swainsboro, GABuilt 1978 · S/N 17271818 N5289TEaves Jeffrey L · Wichita Falls, TXBuilt 1982 · S/N R18201850 N528CSCarlton David C · Carlsbad, CABuilt 1967 · S/N 670429 N528STStanlake Lowell P · Grand Forks, NDBuilt 1972 · S/N 17260868 N528WAirplane Services Inc · Jay, FLBuilt 1978 · S/N 38-78A0693 N528WARiley David P · South Barrington, ILBuilt 1979 · S/N P21000315 N528WFSchwan Steven R · Parker, COS/N 670433 N52908Ichinose Ryan · Fort Worth, TXBuilt 1977 · S/N 177RG1306 N5291EBreslin Denis M · El Cajon, CABuilt 1978 · S/N 17271820 N52922Northwest Flyers Inc · Marianna, FLBuilt 1981 · S/N 17274635 N5292DAftcloud Inc · Ontario, CAS/N 17272497 N5292EJam Three LLC · Saint George, UTBuilt 1978 · S/N 17271821 N5292KBates Field Aero Club Inc · Mobile, ALBuilt 1980 · S/N 17274048 N5292REss Adventures LLC · Damascus, ARBuilt 1974 · S/N 17263506 N52930Sir Grantham Of Kloofbear Inc · Wilmington, DEBuilt 1977 · S/N 177RG1312 N52936Reimer Dean R · Yuma, AZBuilt 1978 · S/N 177RG1313 N52939Warwas Steven M · Yorktown, TXBuilt 1981 · S/N 17274641 N5293KBrooks Jimmy · O Fallon, ILS/N 17274049 N52944Masiero Christophe D · Winter Garden, FLBuilt 1978 · S/N 177RG1315 N52946Pluntze Stephen C · El Segundo, CABuilt 1977 · S/N 177RG1317 N5294RRemus Stephen J · Warren, MIBuilt 1974 · S/N 17263508 N52950Jin Jin Aviation LLC · Anchorage, AKBuilt 1981 · S/N 17274642 N52953Pacific Fleet Aviation LLC · Rochester, NYBuilt 1981 · S/N 17274644 N5295ETimbers Flying Club · West Branch, MIFirst renewal noticeBuilt 1978 · S/N 17271824 N5295GJohnston Robert · Hico, TXBuilt 1979 · S/N 17273559 N5296KTorres Ruben E · Toa Alta, PRBuilt 1980 · S/N 17274050

Back to AD 80-25-07 R1