AD 73-17-01
Registered aircraft · 38,125
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:73-17-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:73-17-01')
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:73-17-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:73-17-01') 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.
N1000YBarkhimer James C · Iraan, TXN1001MRocky Mountain Ventures Inc · Cheyenne, WYN1002MSchuler Mark E · Columbia, ILN10033Thunderfighter LLC · Englewood, CON1004EUnison Air LLC · Palo Alto, CAN1004MReid Brian · Boise, IDN1006VLanier Equipment Leasing LLC · Gainesville, GAN1007THollar Larry · Winston Salem, NCN1008MHottenstein William R · Kingston, PAN1009PFerrier William T · Woodland, CAN100AWDe La Torre Alfonso Jr · Brownsville, TXN100CAFass Flyers LLC · Garden Ridge, TXN100CGGreene Carol W · Mahwah, NJN100FPFlying Particles Inc · Livermore, CAN100HX14 Aero Spaces LLC · Wilmington, DEN100KN18t Ltd · Wilmington, DEN100KFAlbrecht Douglas D · Hobart, INN100KHLefevers Adam · Pineville, KYN100LED&J Training Planes LLC · Logan, UTN100LFLunken Flight Training Center LLC · Cincinnati, OHN100LULynn University Inc · Boca Raton, FLN100MSky Odyssey Aviation LLC · Gulf Breeze, FLN100MMFarmer Aviation LLC · Milan, MIN100PMPegasus Air LLC · Louisville, KYN100RKEllingson Leslie B · Harwood, NDN100SDDivan Jeremy E · Castle Rock, CON100SLOlson Gordon N · Racine, WIN100SUOhio State University · Columbus, OHN100TYFlyin M LLC · Middletown, DEN100WAAlcorn Stanley R · Sonora, CAN100WYMcatee Mark D · Casper, WYN100YSLally Lawrence L · Mooresville, NCN101Bene Mary D · Ketchum, OKN1011NBlue Skies Aircraft LLC · Zephyrhills, FLN1012YNelson Susan P · Kirkland, WAN1014FPeppard Kenneth W · Dumfries, VAN1016FFly Cadillac LLC · Tustin, MIN1016NDrln Aviation LLC · Charlotte, NCN10176Abm Flights LLC · Pawleys Island, SCN1019FFly By Aviation LLC · Sun Valley, CAN101APatterson Mark T · Kodiak, AKN101AFState Of Louisiana · Baton Rouge, LAN101GHSan Diego Community College District · San Diego, CAN101GVWindward West Inc · Boise, IDN101KSWright Kenneth D · Benton, ARN101KTBryan Jerry E · Kathleen, GAN101LAJaguar Aviation LLC · Hillsboro, ORN101LJGrenier Garret P · Anchorage, AKN101LULynn University Inc · Boca Raton, FLN101MBGearin Chad T · Portland, OR
Back to AD 73-17-01