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.

N2803TBarron David L · Sun City, AZBuilt 1972 · S/N 28-7225241 N2803XStamper Douglas H · Norfolk, VABuilt 1967 · S/N 17700203 N28043Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881358 N28045Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881359 N2804CCampbell Mark · Burleson, TXBuilt 1978 · S/N R18200229 N2804MEhrenborg Robert J · Fisherville, KYBuilt 1977 · S/N 28-7890269 N2804ZWatson Jennifer R · San Jose, CABuilt 1978 · S/N 371-78 N28051Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881360 N28053Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881379 N2805QA L Hollandsworth LLC · Columbia, MOBuilt 1971 · S/N 17259805 N28065Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881380 N28069Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881381 N2806EBexar Aviation LLC · San Antonio, TXBuilt 1978 · S/N 17271328 N2806MCondor Aero Club Inc · Zelienople, PABuilt 1977 · S/N 28-7890270 N2806QLawson Lance J · Sikeston, MOBuilt 1971 · S/N 17259806 N2806TN2806t Leasing Company LLC · Mason, MIBuilt 1972 · S/N 28-7205223 N2806WOllmann Paul W · Poplar Grove, ILBuilt 1995 · S/N 1 N28079Abadir Peter · South River, NJS/N 1140 N2807EMission One LLC · Excelsior, MNBuilt 1978 · S/N 17271329 N2807QReynolds David F · Port Orange, FLBuilt 1971 · S/N 17259807 N2807RHayzan Aviation LLC · Wilmington, DEBuilt 1969 · S/N 28R-35294 N2807TSale Reported · Broxton, GASale reported, canceledBuilt 1972 · S/N 28-7205224 N28086Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881392 N28088Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881393 N2808MJensen John C · Mccleary, WAS/N 12-1261 N2808PValiair Limited Co Trustee · Casper, WYBuilt 1955 · S/N 22-3101 N2808UCoastal Flight Inc · Half Moon Bay, CAS/N 1056 N2808WParker David G · Sedona, AZS/N 1083 N2809Piper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010051 N28090Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881394 N28095Cae Oxford Aviation Academy Phoenix Inc · Mesa, AZBuilt 2020 · S/N 2881395 N28096Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881405 N28098Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2020 · S/N 2881406 N2809CNixon Ross M · Hillsboro, ORBuilt 1954 · S/N 26352 N2809ENorth Marin Air LLC · Petaluma, CAS/N 1141 N2809MCarlos Sean N · Togiak, AKBuilt 1946 · S/N 12-1265 N2809PDavis Gerald R · Hernando Beach, FLS/N 22-3102 N2809XGuckian Jim J · Riverdale, GABuilt 1967 · S/N 17700209 N280AL2e2 Corporation · Menlo Park, CABuilt 1980 · S/N 1210 N280AGWings Over Texas Holdings LLC · Denton, TXBuilt 2020 · S/N 4496511 N280AMSabol John · Smithville, TXBuilt 2004 · S/N 20-1041 N280ASBravo Aviation Club LLC · Cary, NCBuilt 1977 · S/N 32R7780155 N280BGD&J Aviation LLC · Gotha, FLBuilt 2002 · S/N 2842167 N280BRRegistration Pending · Denver, CORegistration pendingBuilt 2006 · S/N 2124 N280CABlue Skies Flight Club LLC · Cameron Park, CABuilt 2002 · S/N 24826 N280CSYolo Farms LLC · Raleigh, MSBuilt 1999 · S/N 18280511 N280DABouffard Marcel · Flowery Branch, GABuilt 1977 · S/N 28R-7737154 N280DCCopp David G · Westminster, COBuilt 2009 · S/N 2358 N280EHEnstrom Helicopter Corp · Menominee, MIBuilt 2026 · S/N 2179 N280ERNew Course Aviation Co · Golden, COBuilt 2005 · S/N 2110

Back to AD 81-18-04 R2