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.
N248LTOconnell Christopher · Tucson, AZN249WKz805 LLC · Wilmington, DEN251ASMil2atp Inc · Pikeville, NCN2523VExpress Flight LLC · Bloomingdale, GAN2526QRegistration Pending · Lithonia, GARegistration pendingN252WABettendorf Nicholas L · Mchenry, ILN2578UBond Air Cargo LLC · Doral, FLN25FAFly Rite Aviation LLC · Fort Myers, FLN2610Avionicos Corp · Nokomis, FLN2618MSoltis Stephen T · Kingsport, TNN267JSDelaware Aircraft Trust LLC Trustee · New Castle, DEN26RDPacific North Air LLC · Portland, ORN2751MWktr Inc · Cocoa Beach, FLN276DBN276db LLC · Mesa, AZN277AMParis Air Inc · Vero Beach, FLN2824TEscudier Henry · Houston, TXN2827NN714dd LLC · Pembroke Pines, FLN2828LInverted LLC · Las Vegas, NVN2845ASchwartzkopf Gregory · Saint Johns, FLN28482Cecchi Jeanne · Oroville, CAN2849PN91934 LLC · Evergreen, CON2849SWestex Towers Inc · Abilene, TXN2855UTexas Southern University · Houston, TXN286BWCalifornia Falcon Aviation Inc · Anaheim, CAN2871LN2871l LLC · New Orleans, LAN2871TCloud Dancer Aviation Inc · Deland, FLN2872THenley Brett · Manchester, TNN2882TParis Air Inc · Vero Beach, FLN2883NPeters Mark E · Newport News, VAFirst renewal noticeN2883YNimmo Philip · Bishop, CAN28BMUS Flight Academy Intl Inc DBA · Post, TXN2900HStevens Cloyce B Jr · Tillar, ARN2907DSandhu Tejpal · Southlake, TXN2907QTweto Matthew E · Montgomery, TXN2908XArtsplane LLC · Parker, TXN2912VSoaring Twins LLC · Pikeville, NCN2922ULowcountry Aviation Company Brokerage LLC · Walterboro, SCN2922WHiwassee Aviation LLC · Calhoun, TNN2924CFour Star Aero Services Inc · Palm Coast, FLN2924LSeidel Robert P · Belle Mead, NJN29257Blackwell Aviation LLC · Tacoma, WAN2930VDale Aviation Inc · Rapid City, SDN2931LPlanesmen LLC · Liberal, KSN2933QThomas Mark E · Corpus Christi, TXN29435Cazares James · Barrington, ILN29466Lake Area Technical College · Watertown, SDN2949EReve Air Inc · La Place, LAN295BPQualitair LLC Trustee · MichelstadtN2965RSouthwinds Export Inc · Kissimmee, FLNon-citizen corporation, flight hours not reportedN2968THarrison Mark A · Corpus Christi, TX
Back to AD 75-20-03