AD 75-09-13
Registered aircraft · 4,787
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:75-09-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-09-13')
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:75-09-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-09-13') 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.
N456STMcbride Ken · San Martin, CAN456WPMatagorda Production Co · Westhoff, TXN4570KHead East Aviation LLC · Geneseo, ILN4572LFiegel Donald H · Ward, ARN4576KPope James Dean · Lewiston, IDN4577LLucas John · Norco, CAN4578NAviation International LLC · El Paso, TXN4579NSeven Eight Juliet LLC · Edmond, OKN457DMMajor Development LLC · Cedaredge, CON4580KHarrah Daniel R · Juneau, AKN4589NGeneric Implant Solutions LLC · Pratt, KSN458CTAratow Michael · Mountain View, CAN458VCWing And A Prayer LLC · Sarasota, FLN4592SMays Robert · Centerville, TNN4594CSt Johns Aviation LLC · Saint Johns, MIN4599FCcs Flight Services LLC · Benton Harbor, MIN459DMStafford Wings LLC · Fredericksburg, VAN45BBSpeer Aircraft LLC · Evansville, INN45KPColvin Clu D DBA · Big Cabin, OKN45TFWave Transportation LLC · Middletown, DEN45XDSubstation Air LLC · Midvale, UTN4600UDlw Aviation LLC · Missoula, MTN4601WMike Papa LLC · Newton, KSN4604NS O W Aviation LLC · Crystal River, FLN4604QBas Part Sales LLC · Greeley, CON4607F7 Fox LLC · Eugene, ORN4607QSerrano Lynn A · Casa Grande, AZN4609UJerden Corp · Overland Park, KSN460CBScott Ts Ag-Flyin Inc · Colquitt, GAN460WWMalibu Ww LLC · Fayetteville, GAN4610KAvag Inc · Richvale, CAN4612KChitiea Andrew D · Centennial, CON4617WSavoldelli Steven · Los Angeles, CAN4618MBedrock Siteworks LLC · Coatesville, PAN461DKMark Andregg Dds Pc · Tulsa, OKN4620YCenturion Travel LLC · Fort Worth, TXN4623FHatfield William G · Nunica, MIN4624KHoyt Matthew P · Newport Beach, CAN4626KWyeth Patrick B Trustee · Chino Valley, AZN4627KIsbell Brian · Rosenberg, TXN4627QMassey Larry A · New Braunfels, TXN4629KAuburn Farms LLC · Auburn, KSN4630NHyannis Air Service Inc · Hyannis, MAN4631CGraves Martin · Odessa, TXN4635GN535j LLC · Bismarck, NDN4636KAdvanced Database Designs LLC · San Ramon, CAN4640GHonea Richard S · Canton, GAN4644UWineglass Holdings LLC · Fort Davis, TXN4645FScruggs Ken R · Galloway, OHN4648ATimms Chet D · Central City, IA
Back to AD 75-09-13