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.
N457EPRainier Flight Service LLC · Renton, WAN457GGBohl Howard M · Temecula, CAN457SKWorld Marketing Syndicate I · Wilmington, DEN457SPSouth Dakota State University · Brookings, SDN4580EDe Baca Land & Cattle LLC · Jacksboro, TXN4580JBlakeslee Mark C · Kodiak, AKN4580UDean Nolan W · Harrisonburg, VAN4581CGerardy Harlan D · Gruver, TXN4582CBontrager Brian S · Wasilla, AKN4582ERelis Enterprises LLC · Ravenel, SCN45835Yoakam John A · North Ridgeville, OHN4583CWood L Paul · Bridgeport, TXN4584BNadon Peter M · Aztec, NMN4584CEco Resources Inc · Millersport, OHN4584UDavis Jubal L · Waverly, OHN4585BWalchshauser Scott A · Double Oak, TXN4585CTempero Clair R · Worden, MTN4586BGochenaur Dwight W · York Springs, PAN4586UCate Randall L · Knoxville, TNFirst renewal noticeN4587CJackson Marshall L II · Rock Hill, SCN4589CNelson David W · Marengo, ILN458CACivil Air Patrol · Maxwell Afb, ALN458CDDiacont Charles R · Nazareth, PAN458CMUniversity Of Central Missouri · Warrensburg, MON458CSHarriss Robert Mallory · Mcallen, TXN458DJSurvey America Inc · Rancho Cordova, CAN458ESB R S Leasing Inc · Wilmington, DEN458SPChristiansen Aviation LLC · Wilmington, DEN458SRDr2 Aviation LLC · Valdosta, GAN458WCSee Forever Holdings LLC · Wilmington, DEN4591UJacobsen Ian M · Lincoln City, ORN4592CKelley Stephen Mark · Kamiah, IDN4593BSale Reported · Anchorage, AKSale reportedN4593VFranklin Eric J · Anchorage, AKN4594CSt Johns Aviation LLC · Saint Johns, MIN4594ELingo Joshua B · Lake Village, ARN4594UMclendon Michael L · Whitesboro, TXN4595BBartusek Donald L Trustee · Columbia, MDN4595CYoussefzadeh Salim · Pls Vrds Est, CAN4596BLow & Slow LLC · Columbus, OHN4596FJaysix LLC · Greeley, CON4596URustair Inc · Anchorage, AKN4597BPost William S · Custer, WAN4597CSutton Aircraft Salvage LLC · Palmer, AKN4597FWarden Richard L · Canby, ORN4597RSanta Cruz Airplane LLC · Santa Cruz, CAN4599BAgua Viva Ministries · Mebane, NCN4599CNovne Aviation Inc · Harrisburg, SDN459CACivil Air Patrol · Maxwell Afb, ALN459CCLemon James M · Billings, MT
Back to AD 79-10-14 R1