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.
N936MBBergstrom Aircraft Inc · Pasco, WAN936PRD & D Air Inc · Dover, DEN936RGrandinetti Robert L · Fayetteville, NYN936RJBullion Richard G · Louisville, CON936RVTaylor Thomas D · Harper, TXN936SCSprang Robert · Smithville, OHN936TELevine Gary H · Davie, FLN9370SSheehan Robert K · Edmond, OKN93710Obrian Brandon · Travelers Rest, SCN9371JBosker John A · South Bend, INN9371KEverglades Aviation Academy LLC · Weston, FLN9371NTial Aviation Inc · Wilmington, DEN9371SRiley Loy D · Charlton, MAN9371VFly Me To The Mooney LLC · Owings Mills, MDN9371WRegistered aircraftN9372HN9372h LLC · Wilmington, DEN9372JReed Theodore W III · Trinidad, CON9372NAndys Auto Sales LLC · Caroline, WIN9372PBeery Milo A · Clarinda, IAN9372WVogler Michael John · Huntington Beach, CAN9373DWhite Matison R · Chugiak, AKN9373FDirty Side Down Aviation LLC · Georgetown, TXN9373MKelly Andrew J · Shirley, ARN9373PLeff Benjamin Franklin · Cedar Park, TXN9373SCentral Vermont Flying Club Inc · Williston, VTN9373VEl-Cheikh Taimour · Waldorf, MDN9373WBar Aviation LLC · Cochranville, PAN9374FPierson Robert N · Nora, MNN9374MRoberts Terry L · Bolt, WVN9374WMatthew John Stewart · Delaware, OHN9375BVinland Aerodrome Inc · Baldwin City, KSN9375CFucik John J · Reno, NVN9375JPanjab Aviation Inc · Las Vegas, NVN9375MSweeney David J · Portland, ORN9375NProffitt Albert E III · Warwick, RIN9375VDavis Wesley · Dayton, OHN9376JMorales Michael · Pembroke Pines, FLN9376MBeans James B IV · Camas Valley, ORN9377CLiggett Services Inc · Fort Washington, PAN9377HAir Advantage Inc · Mount Pleasant, IAN9377JDruetzler Thomas · Lynwood, ILN9377MFlying Cookies LLC · Lyman, SCN9377PBoehmer Richard P · Machias, NYN9377WDonley Brian J · Lafayette, INN9378DAndden Aviation LLC · Santa Monica, CAN9378JBentley Aero LLC · La Farge, WIN9378MStratus Investment Corp · Lino Lakes, MNN9378VN83993 LLC · Cherry Hill, NJN9379Daghita Adam R · Colonial Heights, VAN9379HCitizen Air LLC · Port Angeles, WA
Back to AD 87-10-06 R1