AD 2012-11-05
Registered aircraft · 305
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:2012-11-05')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-11-05')
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:2012-11-05') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-11-05') 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.
N280LASeipp Stephen C · Laurel, DEN280MMrr Spraying LLC · Shelby, MTFirst renewal noticeN280MGM&M Charter LLC · Mountville, PAN280MHGulf Coast Helicopters Inc · Pearland, TXN280MLLundy Michael · Stephenville, TXN280MWLrh Equipment LLC · Pendleton, ORN280NARohner Harlan G · Willmar, MNN280SGHorizon Flying Club LLC · Westminster, CON280SHRottor Aviation LLC · Jasper, INN280SMAirpark Aviation LLC · Manchester, NHN280WRBeacon Aviation Flight Services LLC · Rogers, ARN282MHCowboy Up Aviation LLC · Frenchglen, ORN282SHBubs Leasing LLC · West Des Moines, IAN285TRRhoads Timothy C · Logan, NMN286RTN286rt LLC · Wilmington, DEN286SHChambers Barbara A · Olympia, WAN288SHJ&J Shop Heliair LLC · Laurel, DEN289SHRegistration Pending · Anchorage, AKRegistration pendingN28EHChapin Ray DBA · Geneva, NYN28ENEnstrom Helicopter Corp · Menominee, MIN28NEnstrom Helicopter Corp · Menominee, MIN28SHRenaud Michael · Vernon, VTN2992HSale Reported · Manchester, NHSale reported, canceledN2992ZEuroaviation Inc Trustee · KematenN307RLWellevaluations LLC · Wichita, KSN307RTNorthwest Aircraft LLC · Anaconda, MTN3143CAuron Chris · Naples, FLN32ENEnstrom Helicopter Corp · Menominee, MIN3398MMott William R · Beach Lake, PAN353XMackechnie Martin J · Palm Harbor, FLN35DHZebcon Inc · Russellville, ARN35ZEFerree Thomas L · Wampum, PAN377JDStyer David · Milton Freewater, ORN383MAVandenberg Herbert F · Ruston, LAN3842DBeacon Aviation Flight Services LLC · Rogers, ARN391MSBr Transit LLC · Hockessin, DEN3GFRhoads Timothy C · Logan, NMN403TAJ & J Shop Heliair LLC · Laurel, DEN409HTHelidon Inc · Willmington, DEN410SCAlfheim II LLC · Menomonee Falls, WIN420LECox Robert D · Girdwood, AKN4210Lrh Equipment LLC · Pendleton, ORN432RDAirdine LLC · San Francisco, CAN43LABurkholder Leon Ray · Ephrata, PAN43MHKorb Thomas M · Owasso, OKN44SZEnstrom Helicopter Corp · Menominee, MIN44XAMackechnie Martin J · Palm Harbor, FLN451LEEnstrom Helicopter Corp · Menominee, MIN451NEEnstrom Helicopter Corp · Menominee, MIN451REEnstrom Helicopter Corp · Menominee, MI
Back to AD 2012-11-05