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.
N5253UKronauge Frank A · Dayton, OHN5253XMaranatha Insurance Service Inc · Rancho Cucamonga, CAN52543Berry Curtis L · Williamsport, MDN52544H & H Planting Company · Duncan, MSN52546Eaton Rosemary D · Vernon, NYN5254ABuffy Aero LLC · Suwanee, GAN5254DR&R Aero Services LLC · Eden Prairie, MNN5254JWorcester Naa Flying Club · Worcester, MAN5254KStone To Glass LLC · Lake Worth, FLN5254QRocky Mountain Flight Consultants LLC · Boulder, CON5254WGlacier Peak Aviation LLC · Carnation, WAN52554Hermiston Aviation Inc · Hermiston, ORN52557Ruby James Edwin Trustee · Hereford, AZN5255ABishop Michael J · Lima, OHN5255FHirsch Jeffrey D · Lutherville, MDN5255KReighley Robert G · Xenia, OHN5255NLucas David · Lodi, OHN5255RZin Services LLC · Dover, DEN5255UFlight Gear Aviation LLC · Pickerington, OHN52562Sioux Sky Aviation LLC · Grand Forks, NDN52563Concord Flying Club Inc · Lafayette, CAN52564Electrical Systems Professionals Inc · Trinidad, CON52569Kf Air Holdings LLC · Indianapolis, INN5256DTall Timber Flying Service LLC · Kalispell, MTN5256HHenley Robert J · Jeffersonville, INN5256NGospel Ministries International · Collegedale, TNN5256SFargo Jet Center LLC · Fargo, NDN52572Corrosion Savants LLC · Wilmington, DEN52575Crawford George T · Ocala, FLN52577Hartman Edward L · N Canton, OHN52578Wall Leslie A Trustee · Stevensville, MDN52579Urquhart David L · Winchendon, MAN5257ASouthern Aircraft Consultancy Inc Trustee · Casper, WYN5257EWings 4 Paws LLC · Yulee, FLN5257HWellman David H · Eugene, ORN5257JVra Leasing LLC · Beavercreek, OHN5257NAmanda Air Inc · Talladega, ALN5257RTheodossiou Chris · Mandeville, LAN52582Wheeler Kevin K · Thornville, OHN52585Colley Reid W · Pauls Valley, OKN52587Mcconal Danny · Seminole, TXN52589Audritsh John E DBA · Indianapolis, INN5258CRopkey Armor Museum · Indianapolis, INN5258NOffcourt Ltd · Del Mar, CAN5258RZwiesler Thomas F · Ellington, CTN5258YChristiansen Aviation LLC · Wilmington, DEN5258ZSt Pete Aviation Services LLC · Saint Petersburg, FLN52590Aereo Flyers Inc · Camino, CAN52593Mccarthy Justin P · Western Springs, ILN52595Cotton Christopher S · Dallas, TX
Back to AD 79-10-14 R1