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.
N5259ECole Charles · Las Vegas, NVN5259HTrifunovic Stefan · Grosse Pointe Park, MIN5259QFrantz David L · Murfreesboro, TNN5259RCarnathan Robert J · Newark, CAN5259WLauff Samuel J · Ocala, FLN525AGNoland Ronald E · Weston, ORN525JBWalton Jack R · Granbury, TXN525JGFlycarolina LLC · Concord, NCN525KWFuller Thomas R · Scottsdale, AZN525LRSkywalker Leasing LLC · Wilmington, DEN525NDAerosim Academy Inc · Sanford, FLN525SHMcn Systems LLC · Mount Airy, MDN525XHarvey Thomas H · Novi, MIN525ZMMaba Aircraft Services Co · Vero Beach, FLN52602Hutch Aviation Inc · Zavalla, TXN52604Harding Marc S · Des Moines, IAN52606Cirrus Aviation Inc · Sarasota, FLN52607Jse Holdings Inc · Wilmington, DEN52608Kaliebe Kyle D · Mount Pleasant, WIN5260AN5260a LLC · Los Angeles, CAN5260DMeyer Kevin · Hooper, NEN5260KPacific Fleet Aviation LLC · Rochester, NYN5260NBates Management Inc · Woodstock, GAN5260RSouthern Aero LLC · Homestead, FLN52612Daniels Willie L II · Castle Pines, CON52617Land And Sky LLC · Buffalo, MNN52619Lardin William A · Thomasville, GAN5261FTopken William F · Fallon, NVN5261NCrowe Bradley Allen · North Chelmsford, MAN5261UBackus Gary Carl · Chesapeake, VAN52620High Risk Ventures Inc · San Diego, CAN52621Bottieri David P · Mission Viejo, CAN52624Shrewsbury Roy E II · Daniels, WVN52629Mbr Air LLC · Kenosha, WIN5262HBun Air Corp · Bedford, PAN5262UL&W Aircraft Investment LLC · Homestead, FLN5262YLead Turn Aviation LLC · Ogden, UTN52634Beck Gary F · Cypress, TXN52635Allard Michael · Penrose, CON52636Macdonald Russell K · Richmond Hill, GAN5263QZahn Jason L · Towner, NDN5263VMccullough James M · Monte Vista, CON52640Crawford Bill E · Hayti, MON52643Cardinalrg LLC · Ballwin, MON52647Berling David · Litchfield Park, AZN5264CCullum Transportation LLC · North Charleston, SCN5264DPironti Bennett D · Long Valley, NJN5264KRmg Aviation LLC · Newark, DEN52654Jin Jin Aviation LLC · Anchorage, AKN5265DFly 172rg LLC · Peoria, AZ
Back to AD 79-10-14 R1