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.
N5614TBarnes Roger F · Oronoco, MNN5615EWeaver John M · Senoia, GAFirst renewal noticeN5615GShaw Miles · Wasilla, AKN5615RWittrock Thomas L · Wiota, IAN5616ABingham Boyce James · Juneau, AKN5616BCasey Joseph · Buffalo, WYN5616EDhl Skyhawk Inc · Martinez, CAN5617BTruck Plus · Nampa, IDN5617JSale Reported · Wilton, CASale reportedN56180Gosney Don L · Bayfield, CON5618CParis Doug A · Ventura, CAN5618RMiller Richard L · Tipp City, OHFirst renewal noticeN5618THildebrand Mark D · Manawa, WIN5619CDunaire LLC · Mechanicsburg, PAN5619ELiberty Flying Service LLC · Castroville, TXN561ATSheets Jeff M · Salmon, IDN561CK13622 Capital Holdings LLC · Jacksboro, TNN561DAb Prop Plane II LLC · Metairie, LAN561DEFlynn John M · Martinez, CAN561FEffenberger Anthony J · Mankato, MNN561FGRidgeline Assets LLC · Wilmington, DEN561GSSandberg David C · Auke Bay, AKN561MBVital Equipment LLC · Midland, TXN561NDSpartan Education LLC · Tulsa, OKN561SAWingsleasing LLC · Wichita, KSN561SPIllinois State Police · Springfield, ILN561ZDelgado-Ocasio Brunilda · Patillas, PRN5620ASmith Steven R · Nome, AKN5620BBend Aircraft Rentals LLC · Bend, ORN5620GWilliams Dean Nelson · San Antonio, TXN5620JPearce Gregory W · Eagle River, AKN5620RVandeven Avery D · Saint Joseph, LAN5621AMedic Choppers LLC · Springdale, ARN5621BArtz James R · White Bird, IDFirst renewal noticeN5621CDawkins Terry · Defuniak Springs, FLN5621RSale Reported · Genoa, WVSale reported, canceledN5621XDiorio Joseph · Murrieta, CAN5622Nichols Stephen S · Hartland, WIN5622ANissley Stanley · Cottage Grove, TNN5622CBoyett Aviation LLC · Cumby, TXN5622ECivil Air Patrol Inc · Maxwell Afb, ALN5622RKv Enterprises LLC · Kalispell, MTN5623ABeskar Shawn P · Eagan, MNN5623EKd3262 LLC · Downers Grove, ILN5623GMorris Hancock Flying Club · Morris, MNN5624ERound Engine Aero · Nashville, MIN5624GFoothill Aircraft Sales & Service · Upland, CAN5626AAero Gravity Media Inc · Delray Beach, FLN5626GGreer Management LLC · Salem, ORN5626TWerkman James R · Scottdale, PA
Back to AD 79-10-14 R1