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.
N863PUTrustees Of Purdue University · West Lafayette, INN863SCPeregrine Howard Partners II Lp · New Orleans, LAN863VLVieques Air Link · Vieques, PRN863WLStadjuhar Eric J · Omaha, NEN8640VFlannery John J · Atkinson, NEN8641PN8641p LLC · Gainesville, GAN8641VRusyniak Anthony J · Syracuse, NYN8642DAmerican Aviation Inc · Tracy, CAN8642LTexas Soaring Assn · Midlothian, TXN8642WKruckeberg Lloyd E · Amarillo, TXN8643Gillespie Warren H · Hamilton, MTN8643DBurns Roni R · Bolivar, MON8643PCheatwood Owen Larry · Granbury, TXN8643VLuvara Christopher J · Santa Clara, CAN8643WJull Pamela · Bellingham, WAN8644FBemer Aviation Inc · Glastonbury, CTN8644PFord Bernard C · Sidney, NYN8644VSale Reported · Humboldt, IASale reportedN8644WMatos Noel · Newport Beach, CAN8645ECichocki Matthew R · Oviedo, FLN8646DAdams James F · Flagstaff, AZN8647Ober John A · Candor, NYN86472Leopold Seth S · Bellevue, WAN8647ESkywest Leasing Inc · St George, UTN8647NVossberg Carl A · Umatilla, FLN8647VSpratling Boyd M · Deeth, NVN8647WChase Dan · Reno, NVN86483Eaa Aviation Foundation Inc · Oshkosh, WIN8648PSelinger Richard · Seal Beach, CAN8648VBeachy Phil R · Bonners Ferry, IDN8648YChuss Edward · Metamora, MIN8649Dudley Benjamin H · Wasilla, AKN8649DGho Michael M · Fairbanks, AKN8649NManchester Thomas P · Wilmington, DEN8649PMelodia Sean M · Cranberry Township, PAN8649WHigh Desert Flyers LLC · New London, NCN864AFLufthansa Aviation Training USA Inc · Goodyear, AZN864EBudner Jeffrey B · Rio Vista, CAN864GBenson Brad · Mamou, LAN864JBouchard Cary T · Washburn, WIN864MSwingle Howard D · Blacksburg, VAN864PAs6 Aero LLC · Kalispell, MTN864PUTrustees Of Purdue University · West Lafayette, INN864TWTailwinds Academy Of Aviation · Philadelphia, PAN864VLVieques Air Link Inc · San Juan, PRN865Birge Stuart M · Charlotte, NCN8650EGotta Fly LLC · Manitou Springs, CON8650NAllen Flight Service LLC · Laredo, TXN8651CDoby Julian · Graham, NCN8651ESchoen Michael · Lakeville, MN
Back to AD 87-10-06 R1