Registered aircraft · 72,010

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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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.

N4084EIngham Ben B · Sonora, TXS/N 18-7809058 N4084RLand Aerial Services LLC · Conway, ARBuilt 1967 · S/N 32-40401 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 N4085RWojdac David E · Mosinee, WIS/N 32-40402 N4085WIrvin Gary Z · Parrish, FLFirst renewal noticeBuilt 2001 · S/N 25190 N40862Ratliff William Thomas III · Knoxville, TNBuilt 1973 · S/N 28-7405072 N40865Fischer William T · Ventura, CABuilt 1973 · S/N 32-7440066 N4086EJj Aviation LLC · Allentown, PABuilt 1981 · S/N 31-8152114 N4086WMorgan Gabriel A Sr · Newport News, VABuilt 1967 · S/N 32-40137 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 N4087KAggie Air Inc · Clifton, TXBuilt 1981 · S/N 31-8152129 N4087PPankratz Laura M · Stroudsburg, PABuilt 1959 · S/N 23-1565 N4087RWatt Nathan A · Walnut Creek, CABuilt 1967 · S/N 32-40405 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 N4088BClinic Air Aviation Inc · Chapmansboro, TNBuilt 1975 · S/N 75-31120 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 N4088RKako Retreat Center Inc · Russian Mission, AKS/N 32-40407 N4089Indrebo Rick J · Livermore, CABuilt 1989 · S/N 173 N4089FKorb Orry P · Santa Cruz, CABuilt 2002 · S/N 81452 N408BWKough David M · Nashville, TNBuilt 2002 · S/N 60116 N408CACoast Flight Training And Management Inc · Dallas, TXBuilt 2019 · S/N 2881119 N408FHStevens William C · Ashland, MTBuilt 2012 · S/N 2012131 N408FLSmith Benson H · Herington, KSBuilt 1971 · S/N 28-7125184 N408JMRobinson Wayne D · Highlands Ranch, COBuilt 2000 · S/N 80380 N408LTDecathlon LLC · Lincoln, NEBuilt 2025 · S/N 012 N408PBBaich Michael V · Bovey, MNBuilt 1979 · S/N 28-7911143 N408PTRegistered aircraftBuilt 1981 · S/N 1 N408TWWayne Terry · Belews Creek, NCBuilt 2024 · S/N JA699-7-23 N408WBNew England Airlines · Westerly, RIBuilt 1972 · S/N 32-7240092 N408ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881669 N408ZWLinett Michael J · Elsmere, DEBuilt 2019 · S/N 41724 N40903Boyer Aviation LLC · Kiel, WIBuilt 1973 · S/N 28-7415108 N40904Allred Klein Enterprise LLC · San Diego, CABuilt 1973 · S/N 28-7415109 N40905Martin James Christopher · South Jordan, UTBuilt 1973 · S/N 28R-7435140 N4090BHaun Trevor · Placerville, CABuilt 1975 · S/N 75-31112

Back to AD 87-10-06 R1