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.
N6550XButterfield Rory A · Milan, NMN65512Wiebe Van Michael · Filer, IDN65514Vogt Gregory A · Broken Arrow, OKN65516J-Airco LLC · Nashville, TNN65518Tk Equipment LLC · Brownsburg, INN6551AGlynn Kathy G · Queenstown, MDN6551EMoore Henry J · Deer Park, WAN6551HBas Part Sales LLC · Greeley, CON65525Sinha Nanda K · Benicia, CAN65528Jacks Charles D · Crowley, LAN6552FAir Planes LLC · Soddy Daisy, TNN6552MLanman Inc · Litchfield, ILN6552TSchuebel Douglas R · Cameron, WIN65537Aces High Aviation LLC · Long Beach, CAN6553DLlv Aviation LLC · Wilmington, DEN6553EZa Airport Rental LLC · Zanesville, OHN6553KSchaffner Christopher · Dunmore, WVN6553SRegistration Pending · Coeur D Alene, IDRegistration pendingN6553YCenturion Aero LLC · Coos Bay, ORN6554DHancock Jeffrey D · Delta, CON6554FMendonca Jimmy · Caddo Mills, TXN6554GAll Bid Inc · Opelousas, LAN6554TDunaisky Joseph P · Randall, MNN65557Classic Aircraft LLC · South Bend, INN6555ADensmore James E Jr · Colorado Springs, CON6555FThompson Jeffrey L · Scandia, KSN6555JTeton Leasing LLC · Pocatello, IDN6555XViera Fernando Jr · Asbury, MON6555YMild Charles F · Harlingen, TXN65567Skylane Sky LLC · North Palm Beach, FLN6556GBurnett Gregory D · Union, KYN6556HRyco LLC · Lusk, WYN6556SPflederer Raymond F · Sturgeon Bay, WIN6556TLandgaard James R · Peachtree City, GAN65575Flight Training Aircraft LLC · Wilmington, DEN6557BFangio Mark · Mckinney, TXN6557EClor Rosalee G · Saint Clair, MIN6557HRiverside Flight Academy LLC · Riverside, CAN6557MHenderson Douglas A · Cape Coral, FLN6557THelena Vocational Technical Center · Helena, MTN6557XYarnell Bruce W · Stockton, MON65587Wings Over Texas Holdings LLC · Denton, TXN6558EZata Group LLC · North Little Rock, ARN6558FMolek Jon · Warren, OHN6558SVan Bavel Ethan G · Soldotna, AKN6558TSmith Gregory C · Geneva, ILN6559ECarlson Garrett R · Ramsey, MNN6559SReichelt Harvey R · Ossian, INN655CFCarter James W · Dyersburg, TNN655CPCivil Air Patrol · Maxwell Afb, AL
Back to AD 79-10-14 R1