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.
N6766FAviation Trust Company LLC Trustee · Oklahoma City, OKN6767GAspen Kelsen LLC · Rutledge, MON6768EHeifner Gary E · Conway, ARN6768RTaylor Bradley K · Muskego, WIN67695Lynch Robert F · Mount Vernon, OHN6769ELingo Grant W · Beaumont, TXN6769FGarvey Aviation Services · Erie, PAN6769RDomingues Silvio · Woodland, ALN676CBElizabeth City State University · Elizabeth City, NCN676CHTake Off Aviation Services LLC · Rockledge, FLN676CPCivil Air Patrol · Maxwell Afb, ALN676DCPrinc Aviation LLC · Beloit, KSN676DWSunrise Aviation Inc · Ormond Beach, FLN676EREmbry-Riddle Aeronautical University Inc · Prescott, AZN6770AHele David A · Birchwood, WIN6770EKoyle Bruce Ronald · Rancho Cucamonga, CAN6770FFaith Tabernacle Ministries Inc · Junction City, KSN6771EKlingman Matthew W · Chappell, NEN6772FIrlbeck Cyler M · Eden Prairie, MNN6773MLake Erie Aviation LLC · Lyndhurst, OHN6774ERegistration Pending · Crystal, MNRegistration pending, pending cancellationN6774SBennington Aaron G · Delaware, OHN6775AField Eaton Fredrick F · Tigard, ORN6775ECk Leasing Services LLC · Wilmington, DEN6775GBannock Anthony O · Anchorage, AKN6776GWalters John S · Durham, CAN6776MSchweitzer Laura L · Pullman, WAN6777AScheithauer Christopher P · Cement City, MIN6777EQunell Jamie R · Corcoran, MNN6777RMarsh John E · Washington, DCN6777SEhrhardt Paul R · Junction City, ORN6777TNeff Tj · Novato, CAN6778AQuadrani Anthony · Kingsford, MIN6778EFriendly Skies Aircraft Leasing LLC · Sacramento, CAN6778MNikodem Daniel E · Lakeland, TNN6779ASpanbauer Paul J · Oshkosh, WIN6779BRegistered aircraftN6779FBeulah Ranch LLC · Cheyenne, WYN677AARidgeline Assets LLC · Wilmington, DEN677DMAa-Aero Inc · Fairfield, NJN677JARaji LLC · Mclean, VAN677JFShorey Peter K · Newry, MEN677LSFry Justin T · Cincinnati, OHN677RDWise Timothy L · Quinton, OKN677YN677y Inc · Doylestown, PAN6780HMerrell Shane F · Shelby, ALN6780RC2 Aero LLC · Dallas, TXN6781MContinental Sky Eagles Inc · Kings Park, NYN6782EPeters John K · Bonner Springs, KSN6782GWilson Zachary R · Richland Center, WIFirst renewal notice
Back to AD 79-10-14 R1