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.
N97508Sale Reported · Hurricane, WVSale reportedN9750GGee Richard L · Seattle, WAN9750LLouisiana Department Of Public Safety · Baton Rouge, LAN9750QPurdy Adrian · Missouri City, TXN97513Registration Pending · Colona, ILRegistration pendingN9751APerla Guido F · Vashon, WAN9751BDoyle Kevin M · Kenai, AKN9751GJanes John L Jr · Anchorage, AKN9751TAbles Marlan L · Carthage, ARN97523Rwp LLC · Bloomington, INN97528Sky Warrior Flight Training Inc · Pensacola, FLN9752BUniversity Of Alaska Anchorage · Anchorage, AKN9752XBirdman Aviation LLC · Indianapolis, INN9752ZRocky Pointe Logistics LLC · Hayden, IDN97533Associated Pilots Inc · Winchester, MAN9753AFowler Flyers Inc · Fowler, CON9753TCowan Ronnie C · Glasgow, KYN9753VBellamy Mark A · Freeville, NYN97540Popeye And Olives Adventures LLC · Helena, MTN97543Carter Michael E · Dallas, GAN97549Brandt Jeremy · Torrance, CAN9754FFirst Eclipse Ltd · Richmond, VAN9754GWings Aircraft Leasing And Services LLC · Wasilla, AKN97553Gregor Anthony J · Bethesda, OHN9755BRs Specialties LLC · Anchorage, AKN9755DSkyline Solutions Inc · Deland, FLN9755HQualitair LLC Trustee · MichelstadtN97563Fenell Jeffrey A · Stahlstown, PAN9756VLarson Lynn R · Casselton, NDN97578Utecht Thomas A · Friant, CAN97580Wardall Wesley David · Ione, CAN9758BSherwood Aviation LLC · Lewes, DEN9758HBlue Sky Aviation Association Inc · Readington, NJN9758XHernandez Luis Ignacio · Naples, FLN97596Aero-Sphere Inc · Longmont, CON9759ALove John W Jr · Los Lunas, NMN9759BHernandez Raymond · Burleson, TXN9759GMcneill Dudley · Happy, TXN9759XFlorida Alarm & Security Technologies LLC · Merritt Island, FLN975BWWeidendorf Investments LLC · Hinckley, MNN975CPCivil Air Patrol · Maxwell Afb, ALN975PCBeck Steven · San Clemente, CAN975SRBrown Tyrone · Fontana, CAN975TAMitchell David G · Cadiz, OHN975THAnson Air LLC · Sugar Land, TXN97601Zapata Michael III · Cary, NCN9760AK & S Aviation Adventures LLC · Toms River, NJN9760XGubler Joseph A · Fairhaven, MAN97611Bravo Aviation Co · San Antonio, TXN9761HBrentco Aerial Patrol Inc · Canton, OH
Back to AD 79-10-14 R1