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.
N4442UBas Part Sales LLC · Greeley, CON4443LHenderson Michael Trustee · Whitman, NEN4443RCold Region Air LLC · Fairbanks, AKN4443UFratangelo Robert A · Sodus, NYN44441Breeden William N · Gaithersburg, MDN4444TKinzie Industries LLC · Alva, OKN4444VWolfe Randy K · Middle Grove, NYN4444WKoehler Robert E · West Lafayette, INN4445BFassett Barry J · Blaine, MNN4446BOz Aviation Inc · Wilmington, DEN4446LC And T Aviation Inc · Madera, CAN4446RSiler Jerry L · Eau Claire, WIN4447QWolter Dennis R · Cincinnati, OHN4447UTrenter Ray J · Waynesboro, GAN4448BLadegard Ryan P · Wasilla, AKN4448LPuertolas Pascual G · Cobb, CAN4448RBell F Robert · Anchorage, AKN4449BPatkotak Hugh Gareth Sr · Anchorage, AKN4449GHuntley John · Bellingham, WAN4449XBurns William R · Greensboro, GAN444AASipola Don H · Virginia, MNN444APSmith Robert S · Orlando, FLN444BSSiemens Christopher L · Seminole, TXN444CLK G L Aviation Inc · Villisca, IAN444EEVaughn Stewart C · West Jordan, UTN444FRegistration Pending · Auburn, CARegistration pendingN444FLAeroflyin Corp · Miramar, FLN444FRRainier Flight Service LLC · Renton, WAN444GENeverland LLC · Emerson, IAN444GMTwo W Aviation LLC · Casper, WYN444GSWhitten Andrew J · Astoria, ORN444JGGrimmonpre Mark D · Fort Walton Beach, FLN444LLWolfson Alan B · Loveland, OHN444PJWagner Aviation LLC · Laura, OHN444PPCoyne Greg · Hondo, TXN444REJenson Greg Ray · Pueblo, CON444RWBackus Gary Carl · Chesapeake, VAN444TF4tf LLC · Missoula, MTN444THAtlas Aviation Tampa Inc · Tampa, FLN444TJWerner Michael H · Edmond, OKN444TR444 Tr Inc · Van Alstyne, TXN444VBYoung Reginald S · Buffalo Junction, VAN444VCGa Flying LLC · Jupiter, FLN444VWN444vw LLC · Union Gap, WAN444XPEiron Nadav · Portola Valley, CAN444YZBlue Aero Group LLC · Blairstown, NJN4450BRiverview Farm · Starbuck, MNN4450CC & C Auto Sales LLC · Atlanta, MON4450LSouth Side Corp · Cody, NEN4450UGrove Keven W · Ankeny, IA
Back to AD 79-10-14 R1