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.
N71675Sea To Summit Aero LLC · Mertzon, TXN71678Mitchell Flying Service LLC · Cushing, OKN7167ATucker Tim · Hopkinsville, KYN7167FSteinhoff Daniel P · Santa Rosa, CAN7167XMckissack Douglas R · Pooler, GAN71685Hamilton Thomas S DBA · Priest River, IDN7168ERampton Curtis D · Reno, NVN7168GDurbin John W · Lovington, ILN7168MWindh Steven R · Reedley, CAN7168SInternational Air Services Inc Trustee · Carson City, NVN71699Grit Ventures LLC · Throckmorton, TXN7169TBrent Ephron D · Arriba, CON716CPCivil Air Patrol · Maxwell Afb, ALN716EPEpic Flight Academy Inc · New Smyrna Beach, FLN716HPState Of Ohio · Columbus, OHN716LULiberty University · Lynchburg, VAN716MCWing & A Prayer LLC · Wilmington, DEN716MTColvin Mariann · Round Rock, TXN716MWDirty Side Down Aviaton LLC · Georgetown, TXN716PCPcfo Air LLC · Plymouth, MNN716SCJuliet Charlie Aviation LLC · Oregon City, ORN716SPExec 1 Aviation II LLC · Ankeny, IAN716THFairmont State University · Fairmont, WVN71705Wilson Alfred C · Salisbury, NCN7170EMcknight Thomas N · Fredericksburg, TXN7170GSs Skyways LLC · Becker, MNN7170XMccardle Guy D · Burnham, PAN71710Warp Six Aviation LLC · Manitowoc, WIN7171EPhillips John · Vernal, UTN7171QMcnamara Bradley W · Seattle, WAN7171SGuerra Carrie E · Lompoc, CAN71726Mayes John · Carson City, NVN7172EGibson James T · Brookhaven, MSN7172QRounds Agronomy LLC · Pierre, SDN7172SLovaas Darryl G Trustee · Crescent City, CAN71731Brisson Michael Paul · Enterprise, ALN71735Dinota Dominick · Wallkill, NYN71736Nixon Leland Bryan · Stapleton, ALN7173ADuke Billy L · Ormond Beach, FLN7173EMcpherson David R · Sturgis, SDN7173GSale Reported · Haiku, HISale reportedN7173MCronin Larry D · Mountain Home, IDN7173QWesterly Av Group LLC · Westerly, RIN7173TDidier Thomas · Port Washington, WIN71748Altom Marvin L · Reno, NVN7174ESuazo Tito L · Glendale, AZN7174GMaloney John T · Deer Park, NYN7174SBelasco Thomas D II · Bridgeport, WVN7174TPaddock Spencer · Palmer, AKN7174XMcdaniel John P III · Marianna, FL
Back to AD 79-10-14 R1