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.
N66600Registered aircraftN6660HBarr Air Patrol LLC · Mesquite, TXN66611Yeager Jay J · Soldotna, AKN66614Mann Jeffrey W · Merom, INN66615Gardner Donald R · Woodbridge, VAN66616Lee Ryan · Soda Springs, CAN66618Trigg Eric R · Erie, CON6661FLeach Jonathon M · Alpena, MIN6661GMcleod Cecil · Mount Pleasant, SCN6661MDalmonte Giuseppe A · Burbank, CAN6661NSmith Joel L · Cedar Park, TXN6661SHayton James B · Sedro Woolley, WAN6661XOzer Cenk · Sequim, WAN66623Milnor Aviation Inc · Milnor, NDN66626Mulloy Erik W · Lakeway, TXN66628Wichmann Gregory Scott · Las Vegas, NVN66629Schelhorn Timothy · Nampa, IDN6662EMalsby Julius C IV · Bend, ORN66635Blue River Aviation LLC · Palmer, AKN66636November Sierra Aviation LLC · Oneill, NEN66637Drake Aerial Enterprises LLC DBA · Genoa, OHFirst renewal noticeN66639Central Ohio Soaring Assoc Inc · Marion, OHN6663FMaltby Michael D · Angier, NCN6663TKess Frederic R · Pembine, WIN66643Parrott Chad D · Paris, TXN66649Miller Tobin D · Palmer, AKN6664ASeifert Kerry A · Chugiak, AKN6664FRogan Thomas R · Munster, INN6664TFinnin John A Jr · West Chester, PAN66652Johnston Craig E · Beach Haven, NJN66654Integrated Workforce Solutions Inc · Sacramento, CAFirst renewal noticeN66659Devries Douglas · Sparks, NVN6665AHolmes James A · Apache Junction, AZN6665GPurdue Aviation LLC · West Lafayette, INN6666ERegistration Pending · Phoenix, AZRegistration pendingN6666FRibeiro Eugenio P · Fall River, MAN6667EGunter Wayne E · Talkeetna, AKN6667NSmith William F · Hindsville, ARN66683Gusler Gregory L · Halifax, PAN66687Ruhe Sales LLC · Leipsic, OHN6668ADay Patrick K · Ellensburg, WAN6668TKiley Melanie B · Loudon, NHN6668XHocus Holdings LLC · Carrollton, OHN66691Maroney Lorraine J · Anchorage, AKN66695Moore Jack L · Belfast, MEN6669BConstantia Group LLC · Green Cove Springs, FLN666BSSmith Bob · Grapevine, TXN666ESSharkey Kenneth J · Haverford, PAN666JBCopenhaver Tracy K · Anthony, KSN666JRUhl James Gustav · Ft Mckavett, TX
Back to AD 79-10-14 R1