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.
N9303GBenson Steve J · Keenesburg, CON9303NWings Over Texas Holdings LLC · Denton, TXN9303RCanoe Bay Outfitters LLC · Chugiak, AKN9303TBaxter Patrick L · Frisco, CON9303UWestover Scott A · Anchorage, AKN9303XHawaiian Airlift Company Llp · Kihei, HIN9304HWischmeyer Matthew R · Hopewell Junction, NYN9304RShah Zahid · Santa Paula, CAN93050Wilson Thomas Henry III · Anchorage, AKN93052Pfm 2025 LLC · Lake Forest, ILN93055Moore Joshua M · North Pole, AKN9305BStar Aero LLC · Santa Teresa, NMN9305CLinn Michael A · Nisswa, MNN9305NRancho Av Leasing LLC · Temecula, CAN9306CKoehrer Ernie · Palmer, AKN9306GPaiva Rafael R · College Station, TXN9306HAnycomm Corp · Gold River, CAN9307CJrs Buena Vida LLC · College Station, TXN9307DAviatzone LLC · Fort Lauderdale, FLN9307GSchwaderer Delbert L · Stevensville, MTN9307HMoss Jon · Gridley, CAN9307YRader Drew · Avon, CON9308BKorn Antony · Chehalis, WAN9308CCameron Thomas J · Stanchfield, MNN9308GBoilermaker-Warrior Express LLC · Grosse Pointe, MIN9308X5p&P LLC · Glenwood Springs, CON93098Faeo John D · Wasilla, AKN9309CVan Bortel Aircraft Inc · Arlington, TXN9309GHagle Terry A · Niceville, FLN9309XRigsby R W · Salisbury, NCN9309YYecny Alan K · San Luis Obispo, CAN930ASA2g International LLC · San Juan Capo, CAN930CPCivil Air Patrol · Maxwell Afb, ALN930GGelazin Paul J · Palm Harbor, FLN930JSDolphin Air LLC · Fairbanks, AKN930LFWanner Robin L · Lufkin, TXN9310BThrom Donald R · Parachute, CON9310DRegistered aircraftN9310GBaldwin James C · Fruita, CON9310HLilienthal Donald W · Cyrus, MNN93112Strack Air LLC · Yorba Linda, CAN9311GSooter Craig · Blue Ridge, TXN9311TCrouse John A · Sterling, AKN9311XLink Lance L · Concordia, KSN93128High Plains Aero Consulting Inc · Pampa, TXN93129Klca Inc · Warsaw, INN9312GYoung Robert S IV · Abilene, TXN9312XLewan William F · Naperville, ILN93135Shannon Frances W · Clarksdale, MSN9313BAirplanes And Helicopters Of Oregon LLC · Sisters, OR
Back to AD 79-10-14 R1