AD 79-10-14 R1
Registered aircraft · 56,582
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:79-10-14-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1')
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:79-10-14-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-14-R1') 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.
N9499AGourdin Gordon O · Sheridan, ORN9499GT F T LLC · Hayden, IDN9499UFreer Paul Jr · Mount Airy, NCN9499XCovalt Justin D · Arcadia, OKN9499YMilhouse Richard J · Aguila, AZN9499ZDark Sky Enterprises LLC · Flagstaff, AZN949CDDupont Samuel F C · Mount Solon, VAN949CPCivil Air Patrol · Maxwell Afb, ALN949LHappy Mangos LLC · Anchorage, AKN949MDUnruh Leasing LLC · Blossom, TXN949SFRasmussen Agribusiness Inc · Antelope, MTN949SMAviation Trust Co LLC Trustee · Oklahoma City, OKN949SPN949sp LLC · California, MDN949VWCates Byron S · Ronan, MTN94AZGulf Coast Helicopters Inc · Pearland, TXN94BCChapman Air LLC · Plain City, OHN94CAYoung James W · Seattle, WAN94CPAhlhorn Travis Wayne · New Braunfels, TXN94DMLad Salvage LLC · Morgan City, LAN94EJCamp Gerald M · Murrieta, CAN94ELCehula James Douglas · Anchorage, AKN94ERHill Andrew T · Smithville, TXN94GVSky West Aviation Inc Trustee · Albuquerque, NMN94HDFreed Philip B · Parkland, FLN94HJGable Taylor Lee · Nicholson, GAN94JABeaver Aviation South Inc · Fort Myers, FLN94LSPalms Property Management Inc · Heber City, UTN94MNVista Aviation Inc · Pacoima, CAN94MPMissouri State Highway Patrol · Jefferson City, MON94NMSykes Gregory P · Arlington, WAN94TSPetersen Andrew John · Saint Paul, MNN94VWCamp Harper LLC · Houston, TXN9500GEphbaugm Equipment LLC · Hartline, WAN9500XSky Med LLC · Vinton, LAN9501FPacific States Aviation Inc · Concord, CAN9501TNeverland Air Co LLC · Myerstown, PAN9501WAwwad Mamdouh A · Walnut Creek, CAN9501XFlowers Bobby J · Parksley, VAN9502BGraceffa Salvatore · Atascadero, CAN9502HYoung Roger A II · Wasilla, AKFirst renewal noticeN9502TSilveria Michael J · Soledad, CAN9502YBci Aviation LLC · Arroyo Grande, CAN9503QGulf Coast Helicopters Inc · Pearland, TXN9503YRoss Carl D · Arbuckle, CAN9504BVan Winkle Randy M · Van Buren, MON9504HPatterson Clifford Wayne · Murphy, TXN9504LTaylor William C · Portsmouth, NHN9505HFinal Approach Aviation LLC · Danville, CAN9506WAttitude Aviation Inc · Livermore, CAN9506XBradshaw Aviation Systems LLC · Bridgeton, MO
Back to AD 79-10-14 R1