AD 87-10-06 R1
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
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.
N9205PDt Pralle Enterprise Inc · Hampton, IAN9205UWhitford John T · South Weber, UTN9205VBlaylock James · Las Vegas, NVN9205XOrmond Aircraft Leasing & Management Inc · Ormond Beach, FLN9205YNorman Edward M · Palmer, AKN9206DCarpenter Richard F · Big Lake, AKN9206JBolles Aviation LLC · Johns Creek, GAN9206MCrews William J · Jacksonville, FLN9206NSkylink Xpress Inc · San Bernardino, CAN9206SJohnson W Norman · Stayton, ORN9206VRegistered aircraftN9206WHalley Dan R · Avery, TXN9206YFejes Samuel T Jr · Anchorage, AKN92078Goat Mountain Air LLC · Girdwood, AKN9207EEast Brian D · Tucson, AZN9207NPalmer Richard A · Marysville, WAN9207PWissler John H · Tenino, WAN9207SMr Woodchuck LLC · Naples, FLN9207WAinakea Aviation LLC · Washoe Valley, NVN9208LBrookway Investments LLC · Brookhaven, MSN9208MWright Matthew K · Hollister, CAN9208SFrush Charles A · Burlington, NJN9209FAerospace Trust Management LLC Trustee · Wilmington, DEN9209MFloyd Thomas H · Reno, NVN9209QMckeeman Trevor T · Manhattan, KSN9209WCornell Guy Q III · Newburgh, INN920ACNaples Air Center Inc · Naples, FLN920AJAmerican Patrols Inc · Midland, TXN920BTThorpe Brian J · Saint Augustine, FLN920BWWilliams Rebecca J · Alto, NMN920CJJones Alva L · Craig, CON920CPCivil Air Patrol Inc · Maxwell Afb, ALN920ERSunrise Aviation · Ormond Beach, FLN920GBales Don · Oakhurst, CAN920GDAir Charter Inc DBA · Culebra, PRN920GPGyene Ors · Ashland, ORN920GTBeauchesne Harold J · Enterprise, ALN920HGGreco Robert J · Overgaard, AZN920HWWikstad Herulf L · Nevada City, CAN920JCTrabold Jeffrey G · Kingsport, TNN920JLBaxley Aviation LLC · Baxley, GAN920KBarker Andrew Robert · Portland, ORN920LHHatley Byron J · Sparks, NVN920MAPerry Castonguay Farms Inc · Omega, OKN920MSWaco Safe Flyers LLC · Robinson, TXN920NCState Of North Carolina · Raleigh, NCN920PHYetiskin Kenan · Huntsville, ALN920SBDream Cloud Aviation LLC · Saint Marys, PAN92103Pgd Flyers Inc · Cape Coral, FLN9210BOrmond Aircraft Leasing & Management Inc · Ormond Beach, FL
Back to AD 87-10-06 R1