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.
N5346NMustang Manufacturing Inc · Carson City, NVN5346QCape Fear Aviation Maintenance LLC · Fayetteville, NCN5346TTiffany Shawn M · Herington, KSN5346VRegistered aircraftN53474Executive Air Taxi Corp · Bismarck, NDN53475Rw Aviation LLC · Fishers, INN5347HMonterey Bay Aviation Inc · Watsonville, CAN5348DSwaz Aviation LLC · Mesa, AZN5348EDexter Brady R · Chambers, NEN5348UC3 Shadow LLC · Columbus, OHN5348VKavon Clinreg LLC · Palm Beach Gardens, FLN5348YWheeler Robert T · Silt, CON53491Crossbrook LLC · Willoughby, OHN53494Gandarillas Andrew J · Toledo, WAN5349DFisher Randall A · Salem, OHN5349RTroya Aviation LLC · Utica, NYN534DDVan Gasse Randall M · Norway, MIN534DWValiair Ltd Co Trustee · Casper, WYN534EREmbry Riddle Aeronautical University Inc · Prescott, AZN534FLeiser Harry W · Rome, PAN534HFSun Aircraft Management LLC · Ormond Beach, FLN534KSKent State University · Stow, OHN534PCSutton Brad · Vallecito, CAN534RHAlf Ix LLC · Chicago, ILN53504Aviation Adventures LLC · Hansen, IDN53507Flight School Of Gwinnett · Lawrenceville, GAN5350CJones Terry M · Bells, TNN5350KCenterline Aviation LLC · Oklahoma City, OKN5350RNorth Fergus Flying Club · Winifred, MTN53510Joey Os LLC · Darlington, PAN53519Gic Inc · Oneill, NEN5351CLc Aviation Consulting LLC · Montauk, NYN5351DSplan David L · Mccall, IDN5351HHayes Jeffery M · Yatesville, GAN5351QBarrett Dannie P · Halfway, ORN5351VHarris Adam K · Shrewsbury, MAN53520Harben Grover S III · Gainesville, GAN53525Dewind Helicopter LLC · Zeeland, MIN5352CBohl Howard M · Temecula, CAN5352KPea-Wayman Flight LLC · Daytona Beach, FLN5352NAhrens Douglas T · Los Altos, CAN5352RProam Flyers Of Union County · Matthews, NCN5352SGustafson Steven R · Jamestown, NYN5352TFord Howard J · Salt Lake City, UTN5352ULittle Dog Aviation LLC · Anchorage, AKN53531Hayes Inc · Betsy Layne, KYN5353CStill Martin L · Upper Sandusky, OHN5353DMcmahan Charles B · Gakona, AKN5353KCentury Air Inc · Fairfield, NJN5353QRegistered aircraft
Back to AD 79-10-14 R1