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.
N4786QMcgregor Daniel A · Denali Park, AKN4787ESilverhawk Aviation Academy LLC · Caldwell, IDN4787UDreyer Jeffrey J · Payson, AZN4788DJb Aviation Flight School Inc · Wonder Lake, ILN4788ETiernan Jeffery P · Waddington, NYN4788VM Fujii Inc · Costa Mesa, CAN4789DStevens Dennis W · Mohave Valley, AZN4789EPhil Weber Investments LLC · San Diego, CAN4789FGrimes Aero LLC · Hobbs, NMN4789GCrossflot Aviation Inc · Shepherdstown, WVN4789NRegistered aircraftN4789XGrald Jonathan A · Goshen, NYFirst renewal noticeN478ACModern Mobility LLC · Kennedale, TXN478CAWingsleasing LLC · Wichita, KSN478CMUniversity Fo Central Missouri · Warrensburg, MON478GPGypsy Aviation LLC · Hattiesburg, MSN478KBoard Of Trustees Of Southern Illinois University · Carbondale, ILN478KJBw182t LLC · Ocean City, MDN478KNKunes Kimberly A · Westport, WAN478MCDouble Eagle Air LLC · Searcy, ARN478SPAbove And Beyond Aviation LLC · Austin, TXN478TCRotschafer Randall P · Omaha, NEN478TSTc Aero Services Inc · Wilmington, DEN478TWTumbleweed Leasing Company Inc · Salt Lake City, UTN4790BKringle Wendell K · Barron, WIN4790DGlobal Navigator LLC · Anacortes, WAN4790EMahon Enterprises LLC · Gray Court, SCN4790FKise Scott T · Circle Pines, MNN4790GWings Over Texas Holdings LLC · Denton, TXN4790JAmanzi LLC · Brasstown, NCFirst renewal noticeN4790ZBem Holdings LLC · Dover, DEN4791DBoan Randall P · Milton, IAN4791EMelbourne Flight Training LLC · Melbourne, FLN4791FPfp Aviators LLC · South Salt Lake, UTN4791UAerialtraders LLC · Fort Myers, FLN4791VAmerican Eagle Realestate & Financing Corp · Royal Palm Beach, FLN4791XBowden Wyatt D · Hamburg, ARN4792UWegman Atlas George · Ghent, NYN4793EKillpack Kevin R · Rio Rancho, NMN4793FCitizen Air LLC · Port Angeles, WAN4794FGet Out Aviation LLC · Palmer, AKN4795CPrecision Design Inc · Wilmington, DEN4795DStemprok Roman · Corsicana, TXN4795FClark Joseph D · Kilgore, TXN4795QHinkle Airspray Inc · Cavalier, NDN4795UParker Omalley Corp · Chatham, NYN4795XHopkins Eric J · Wasilla, AKN4796BHough Kenneth R · New Gloucester, MEN4796NCessna N4796n LLC · Shreveport, LAN4796VPittman Robert · Ocala, FL
Back to AD 79-10-14 R1