Skip to content

Registered aircraft · 40,472

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-04-03-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:80-04-03-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:80-04-03-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:80-04-03-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:80-04-03-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:80-04-03-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.

N4084TEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1991 · S/N 1863 N4084ZHull Keath C · Wasilla, AKFirst renewal noticeBuilt 1964 · S/N 18-8099 N40850Mitchell Timothy · Enterprise, ALBuilt 1973 · S/N 28-7425178 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 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 N408FHStevens William C · Ashland, MTBuilt 2012 · S/N 2012131 N408FLSmith Benson H · Herington, KSBuilt 1971 · S/N 28-7125184 N40903Boyer Aviation LLC · Kiel, WIBuilt 1973 · S/N 28-7415108 N40904Allred Klein Enterprise LLC · San Diego, CABuilt 1973 · S/N 28-7415109 N4090EAerodrome LLC · Louisville, KYBuilt 1977 · S/N 18-7809062 N4091PPaulay Sandor F · Kenmore, WABuilt 1959 · S/N 23-1570 N4091ZA G Sholton Co · Wasilla, AKBuilt 1964 · S/N 18-8109 N40925High Flight Academy LLC · Allison Park, PABuilt 1973 · S/N 28-7415112 N40935International Air Services Inc Trustee · Carson City, NVBuilt 1941 · S/N 7603 N40936Aerial Sign North Inc · Lakewood, NJBuilt 1941 · S/N 7592 N40939Grog Holdings LLC · Dallas, TXBuilt 1973 · S/N 28-7425191 N4093PLumley John J · Delray Beach, FLBuilt 1959 · S/N 23-1572 N4093XBartholomeo Daryl A · Cleveland, OKBuilt 1971 · S/N 5193 N40945Mount Eagle Inc · Alexander, ARBuilt 1974 · S/N 28-7405077 N4094PShelley Isaac R · Scottsville, VABuilt 1959 · S/N 23-1573 N40951Grant Constance R Trustee · Eaton, INBuilt 1973 · S/N 28-7425193 N40953Cws Capital Holdings LLC · Saint Petersburg, FLBuilt 1973 · S/N 28-7415118 N4095PTorell Pamela O · Port Saint Lucie, FLBuilt 1959 · S/N 23-1574 N4095ZBreidenbach Bros Inc · Iliff, COBuilt 1964 · S/N 18-8108 N40963Grant Matthew D · Alvord, TXBuilt 1974 · S/N 28-7415120 N40965Portsmouth Flying Club LLC · Epsom, NHBuilt 1973 · S/N 28-7415121 N40966Skytech Hc Ltd · Fredericksburg, OHBuilt 1973 · S/N 28-7415122 N4096ESwiss John T · Anchorage, AKBuilt 1978 · S/N 18-7809064 N4096XFoster Robert L Jr · Chandler, OKBuilt 1970 · S/N 5196 N4096ZTurner Hal Eugene Jr · Tiburon, CAS/N 18-8110 N40972Terry Aaron D · Glendale, AZS/N 28-7425196 N4097XWilson Dane A · Church Point, LABuilt 1971 · S/N 5197 N4097ZSullivan Daniel J · Long Lake, MNBuilt 1964 · S/N 18-8111 N40984Four Zero Niner LLC · Granger, IABuilt 1973 · S/N 28-7425199

Back to AD 80-04-03 R2