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.
N385TDHomestead Helicopters Inc · Missoula, MTN3862PBrown Travis Trustee · Columbia, MON3862RToco Inc · Healdsburg, CAN3864UInterrail Power Inc · Jacksonville, FLN3869SPeterson Kurtley D · Gunnison, UTN3872W6 Chicks Aviation LLC · Santa Maria, CAN3875GBurnett Ross L · Riggins, IDN3885GRichland Aviation Inc · Sidney, MTN3886PUncanny Valley Films Inc · Arroyo Seco, NMN388BCAerospace Trust Management LLC · Wilmington, DEN388SPWeber Donald E · Saint David, AZN3891GTangent Aviation LLC · Oro Valley, AZN3895GMike Kilo Aviation LLC · Garden Ridge, TXN389CSSahi Carl R · Coventry, CTN38AZN731ny LLC · Phoenix, AZN38CJAirplane Seven LLC · Watkins, CON38CMSale Reported · Fay-Aux-LogesSale reportedN38GJMonahan Jeffrey L Trustee · Long Beach, CAN38LPN38lp LLC · Jacksonville, FLN38NTYorkavitz James B · Valley City, OHN38PFSycan Corp DBA · Paso Robles, CAN38PKDeininger Robert · Apopka, FLN390RSSchoene Edward C · Springfield Center, NYN3912PRegistered aircraftN391PT7640 Drilling LLC · Amarillo, TXN3920CN3920c Lc · Wichita, KSN3936GBaker George G · Junction City, ORN393DW3 Delta Whiskey LLC · Superior, WIN393MPDutch Indian Air LLC · Riverdale, CAN39501Jw & Jl Aviation LLC · Phoenix, AZN3959POmaha Aircraft LLC · Blair, NEN3968QTundra Wings Ministries · Wasilla, AKN396BSpring Creek Financial Inc · Lewistown, MTN397AWPapa Tango Aviation LLC · Kalispell, MTN397DJRickenbach Andreas N · Truckee, CAN3983GBank Of Utah Trustee · Salt Lake City, UTN398LJDakota Heavy Equipment · Fargo, NDN398PGeorge Monte C · Ashland, ORN3992GFlat Earth LLC · Kalispell, MTN3995GCutting Edge Design & Contracting-Sc Inc · Elgin, SCN399CAHoman Mark A · Wake Forest, NCN399KMCustodio Olga · San Antonio, TXN39BTMidwest Aerial Photography · Galloway, OHN39DDLarson Danny O · Palmer, AKN39HCTherapy Air LLC · Midland, TXN39TKCold Water Aviation LLC · Wabasso, MNN3CYSchultz Daniel A · Tipp City, OHN3DQCrescent Aviation LLC · Rllng Hls Est, CAFirst renewal noticeN3ELTwo If Buy LLC · Nashua, NHN3EM3em LLC · Karnack, TX
Back to AD 75-09-13