Skip to content

Registered aircraft · 81,728

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:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') 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:81-18-04-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
  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:81-18-04-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
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.

N27PCRegistration Pending · Houston, TXRegistration pending, pending cancellationBuilt 1962 · S/N 24-3022 N27PJHines Thomas J · Amsterdam, NYBuilt 1998 · S/N 1401 N27PMMagnuson Peter C · Ocala, FLBuilt 1984 · S/N 1309 N27PPNichols Scott · Vacaville, CABuilt 2015 · S/N 91072 N27PSBoyd Ranch LLC · Elko, NVBuilt 2005 · S/N 11/12-566 N27PWRampersad Paul R · Port Charlotte, FLBuilt 1995 · S/N 14641 N27RBBassett Ronald E · Monticello, INBuilt 1984 · S/N 1097 N27RDWengerd Lavern W · Heron, MTBuilt 1946 · S/N 3969 N27RVWhite John M · Lanett, ALBuilt 2000 · S/N 80548 N27STStefenelli Aviation N-Tr Inc Trustee · AtterseeBuilt 1958 · S/N 1201 N27SVWilliams Val · Victor, IDBuilt 2023 · S/N 3422 N27SWDavis James R · Tulsa, OKBuilt 2000 · S/N 21985 N27TGHarrison Mark A · Corpus Christi, TXS/N R18201065 N27TJTj Aero LLC · Winchester, MABuilt 2021 · S/N 172S12656 N27TPTandem Skydive Saipan Inc · Saipan, MPBuilt 2016 · S/N 172S11690 N27TUConard John C · Minnetonka, MNBuilt 1997 · S/N 266 N27TXDavis David A · Weatherford, TXBuilt 1969 · S/N 195 N27VBBross Von R · King Hill, IDS/N 7-0345 N27VVEaa Aviation Foundation Inc · Oshkosh, WIBuilt 1972 · S/N 001 N27WHAviators Unlimited Aviation Holdings LLC · Garner, NCBuilt 2007 · S/N 1045-2007 N27WKWillkris Aviation Services LLC · Smithfield, VABuilt 1972 · S/N 250-72 N27WYRachor John V · Central Point, ORBuilt 2012 · S/N 3157 N27YPDurbin Travis · Nathrop, COS/N 531 N27ZARegistered aircraftS/N 200027 N28Registration Pending · Palos Park, ILRegistration pendingBuilt 1962 · S/N 1 N28003Jensen Larry R · Palo Alto, CABuilt 1978 · S/N AA5B0935 N28006Hellwig Frederic C · Nevada City, CABuilt 1978 · S/N AA5B0938 N2800DHamann Russell M · Clear Lake, SDBuilt 1947 · S/N 12-1637 N2800WAzul Aviation Inc · Fort Worth, TXS/N 1029 N2800XAffordable Aircraft & Components LLC · Manorville, NYS/N 1104 N2800ZRitchie John A Jr · Gold Hill, NCBuilt 1959 · S/N 22-6793 N28011Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881346 N28015Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881347 N28017Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881348 N28018Hoeschen Derek R · West Fargo, NDS/N 78-31141 N2801EJ4 Aero LLC · Gulf Breeze, FLBuilt 1978 · S/N 17271327 N2801PVistad Bruce W · Fergus Falls, MNS/N 008 N2801RSummers Clinton D · Maysville, NCBuilt 1969 · S/N 28R-35288 N2801XJones Daniel L · Newton, ALBuilt 1967 · S/N 17700201 N2801ZValiair Limited Company Trustee · Casper, WYBuilt 1959 · S/N 22-6794 N28020Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881349 N28027Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881350 N28029Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881351 N2802MSkyone Aero Services LLC · Castro Valley, CABuilt 1977 · S/N 28-7816312 N2802TRandolph Clint · Bullhead City, AZBuilt 1972 · S/N 28R-7235134 N2802ZPeavler Christopher · Modoc, SCS/N 22-6795 N28030Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881352 N28034Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881357 N2803AOmeara Dennis · Wheat Ridge, COS/N 1036 N2803PLewis Stephen R · Chillicothe, ILBuilt 1955 · S/N 22-3095

Back to AD 81-18-04 R2