Skip to content

Registered aircraft · 81,733

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.

N40806Sky Dream Flight School LLC · Dallas, GABuilt 1973 · S/N 28-7425169 N4080HEarle Brian S · Two Rivers, AKBuilt 1947 · S/N 12-3508 N4080ZVan Dyke Brian S · Rio Oso, CABuilt 1964 · S/N 18-8094 N40810Qualitair LLC Trustee · MichelstadtBuilt 1973 · S/N 28-7415088 N40812Dae Aviation Enterprises Corp · Gilford, NHBuilt 1973 · S/N 28-7405068 N4081EOrlando Aircraft Sales LLC · Orlando, FLBuilt 1991 · S/N 1916 N4081SScheerer Martin · Edina, MNBuilt 1974 · S/N 28R-7435130 N40823Ashley Aviatrix LLC · Atlanta, GABuilt 1973 · S/N 28-7425173 N40829Shively Ray F · Turtlepoint, PABuilt 1973 · S/N 28-7415090 N4082JEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1991 · S/N 1794 N4082MOdegaard Aviation LLC · Kindred, NDS/N 12-2964 N4082RMid-Life Crisis Aviation LLC · Renton, WABuilt 1968 · S/N 32-40398 N4082XLeach Joey D · Flat Rock, INBuilt 1971 · S/N 5182 N40830Spirit Of Rocky Mount LLC · Nashville, NCFirst renewal noticeBuilt 1973 · S/N 28-7415091 N40836Hawkins Joshua L · Colbert, GABuilt 1973 · S/N 28-7425176 N40838Andrews Mark F · Jacksonville, FLBuilt 1973 · S/N 28-7415093 N4083BRoss Andrew P · Sparks, NVS/N 24 N4083EHulsey Steven M · Chugiak, AKBuilt 1977 · S/N 18-7809056 N4083XKnutson Wayne R · Thompson, NDBuilt 1971 · S/N 5183 N4083ZRaymond Raphael T · Helix, ORBuilt 1964 · S/N 18-8098 N40842Avz Aviation Inc · Knoxville, TNBuilt 1973 · S/N 28-7415094 N40845Rich Lucas Aircraft Sales LLC · Lincoln Park, NJBuilt 1973 · S/N 28-7405070 N4084EIngham Ben B · Sonora, TXS/N 18-7809058 N4084MStempky John A · Anchorage, AKS/N 12-2967 N4084TEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1991 · S/N 1863 N4084WGraham Jessami T · Walsh, COBuilt 1966 · S/N 32-40133 N4084ZHull Keath C · Wasilla, AKFirst renewal noticeBuilt 1964 · S/N 18-8099 N40850Mitchell Timothy · Enterprise, ALBuilt 1973 · S/N 28-7425178 N40852Air Performance LLC · Kalispell, MTBuilt 1973 · S/N 28R-7435134 N40856Griggs Gerald A · Blairsville, GABuilt 1973 · S/N 28-7425180 N40857Muller-Levan Christina J · Kempton, PABuilt 1973 · S/N 28-7415099 N40858Dicey Aviation LLC · Somerset, KYBuilt 1973 · S/N 28-7415102 N4085EGrass Roots Flying Inc Trustee · Wilmington, DEBuilt 1978 · S/N 18-7809059 N4085PTango Bravo Aviation LLC · Taylorsville, MSBuilt 1959 · S/N 23-1563 N4085WIrvin Gary Z · Parrish, FLFirst renewal noticeBuilt 2001 · S/N 25190 N40862Ratliff William Thomas III · Knoxville, TNBuilt 1973 · S/N 28-7405072 N4086KRobinson Mark V · Vacaville, CABuilt 1966 · S/N 1 N4086MBudak Mark · Melba, IDBuilt 1947 · S/N 12-2969 N40872Ole South Aviators LLC · Athens, GAS/N 31-8152134 N40874Jones Sherman Farrell · Buena Park, CABuilt 1973 · S/N 28-7425184 N40876Gray John W · Rohnert Park, CABuilt 1973 · S/N 28-7415100 N4087PPankratz Laura M · Stroudsburg, PABuilt 1959 · S/N 23-1565 N4087ZNcsb LLC · Anchorage, AKBuilt 1964 · S/N 18-8102 N40881Hsu Feng · Albuquerque, NMS/N 28-7425185 N40882Flight Factory LLC · Danville, CABuilt 1973 · S/N 28-7415105 N4088FCole Warren G · Watkinsville, GABuilt 1976 · S/N 28-7725002 N4088MRam Aviation LLC · Palmer, AKBuilt 1947 · S/N 12-3003S N4088PBas Part Sales LLC · Greeley, COS/N 23-1561 N4089Indrebo Rick J · Livermore, CABuilt 1989 · S/N 173 N4089FKorb Orry P · Santa Cruz, CABuilt 2002 · S/N 81452

Back to AD 81-18-04 R2