AD 75-20-03
Registered aircraft · 735
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-20-03')
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-20-03')
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-20-03') 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-20-03') 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.
N1390TAccessible Aviation Inc · Tupelo, MSN1397HIngold Terry L · Albemarle, NCN13AGWeather Modification LLC · Fargo, NDN13LMTupelo Limited Lc · Lake Charles, LAFirst renewal noticeN1407TAndrews University · Berrien Springs, MIN1411XMaarouf Dan H · Seabrook, TXN1416XTop Tier Truck And Trailer LLC · Dimmitt, TXN1421TBurr Charles R Jr · Palm Bay, FLN14258Bayshore Aviation LLC · Saint Petersburg, FLN142GDDeaero LLC · Darwin, MNN1436TDeland Aviation LLC · Deland, FLN1451XTrb Aviation Inc · Washington, DCN1467XWilson David K · Mckinney, TXN147BZSpace Coast Aircraft Co · Merritt Island, FLN148PFMacallen Chemical Inc · Monroe, LAN14FPBakowicz John R · Sunbury, PAN14FZWurzer Frank · Tallmadge, OHN14JNNational Test Pilot School · Mojave, CAN14SSBas Part Sales LLC · Greeley, CON15008Wings Over Texas Holdings LLC · Denton, TXN15018N15018 LLC · Sanger, TXN15024Whytes Inc · Coconut Creek, FLN15035Wings Over Texas Holdings LLC · Denton, TXN15064Kropp Christian Owner Trustee · Azle, TXN15089Tusla Technology Center School District #18 · Tulsa, OKN15145Tri-Star Aviation Inc · La Porte, TXN1519THigh Flyers Aviation Services LLC · Gaithersburg, MDN15215Curtis David W · Watertown, NYN1532XRaymond Darwin V · Glenwood Springs, CON1533EPhoenix East Aviation LLC · Daytona Beach, FLN1536XClark Christopher · Ormond Beach, FLN1551XLeverson Christopher · Austin, TXFirst renewal noticeN15529Pattie Donald D · Zephyrhills, FLN1555XShelton Brad · Wildwood, MON15589Neal Alan B · Cherry Valley, CAN15647Flynn Daniel C · Malvern, PAN15709Avioelectronica Inc · Sunrise, FLN1570XTmstarservices LLC · Lewes, DEN15789Sidc2 LLC · North East, MDN157BJHolm Brian · Buckley, WAN15839Phoenix East Aviation LLC · Daytona Beach, FLN15925Everglades Aviation Academy LLC · Weston, FLN16292Morcom Aviation Services Inc DBA · Everett, WAN162BWSimply Living LLC · Fort Myers, FLN170TBIal Corp · Lewes, DEN181FMLuse Otis · Lago Vista, TXN1839HFly 172n LLC · Peoria, AZN1863HSouthern Aircraft Consultancy Inc Trustee · Casper, WYN189MLStrobe Aviation LLC · Columbia, SCN18RKJacksonville Twin Comanche LLC · Kalispell, MTFirst renewal notice
Back to AD 75-20-03