Registered aircraft · 56,580

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

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

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.

N3122AJohns William D · Lodi, CABuilt 1953 · S/N 25766 N3122JMulvihill Murphy A · Northbrook, ILBuilt 1966 · S/N 15065822 N3122STecumseh Skydiving School LLC · Tecumseh, MIBuilt 1964 · S/N 18255622 N3122YJti Management LLC · Colfax, WAS/N 18254122 N3123CRmc Aviators LLC · Wilmington, DEFirst renewal noticeBuilt 1954 · S/N 30922 N3123EKanase Padmaneel B · Amarillo, TXS/N 17271444 N3123QDarkhorse Six Inc · Boerne, TXBuilt 1967 · S/N 18258123 N3123RHs Aviation Holdings LLC · Eagle, IDBuilt 1967 · S/N 18258523 N3123SGabin LLC · Tulsa, OKBuilt 1964 · S/N 18255623 N3123VColemaker Aero & Marine LLC · Saint Augustine, FLBuilt 1974 · S/N 15076392 N3123XRegistered aircraftBuilt 1966 · S/N 15064523 N3123YAbecca Corporation · Jackson, MIBuilt 1962 · S/N 18254123 N3124AWolstenholme Robert · Line Lexington, PABuilt 1953 · S/N 25768 N3124DBurch David C · Flushing, MIBuilt 1955 · S/N 31922 N3124FTrue Aviators LLC · Kiowa, KSBuilt 1966 · S/N 18257224 N3124RMidland Liberty LLC · Midland, MIBuilt 1967 · S/N 18258524 N3125DDavis Ronald L Jr · Soldotna, AKBuilt 1955 · S/N 31923 N3125FHall Aircraft LLC · Kenai, AKS/N 18257225 N3125QSunrise Aviation Llp · Gig Harbor, WABuilt 1967 · S/N 18258125 N3125THamilton Brian H · Currie, MNBuilt 1967 · S/N 17700425 N3125WRowe Benjamin Stratton · Nome, AKBuilt 1959 · S/N 50584 N3125YOberdoerster Timothy L · Concord Township, OHS/N 18254125 N3126ALutz Adam R · Kodiak, AKBuilt 1953 · S/N 25770 N3126CWest Leland Dan · Elverta, CAS/N 30925 N3126DMyers Martin John Trustee · Juneau, AKBuilt 1955 · S/N 31924 N3126EN3126e LLC · Columbus, OHBuilt 1978 · S/N 17271446 N3126TNicholson Homer L · Ponca City, OKBuilt 1967 · S/N 17700426 N3126YOutdoor Freedom Inc · Camdenton, MOBuilt 1962 · S/N 18254126 N3127CChaar LLC · Lock Haven, PAS/N 30926 N3127DE & S Group LLC DBA · Columbia, CABuilt 1955 · S/N 31925 N3127EAllison John W Jr · Brighton, COBuilt 1953 · S/N 30087 N3127FN3127f Aviation LLC · Charlotte, NCBuilt 1966 · S/N 18257227 N3127JHendry Joshua R · Carthage, TNBuilt 1966 · S/N 15065827 N3128DCopsey Harvey J · Tucson, AZBuilt 1955 · S/N 31926 N3128FSwartzendruber Rodney S · Bay Port, MIBuilt 1966 · S/N 18257228 N3128QK Bell Enterprises Inc · Columbia Falls, MTBuilt 1967 · S/N 18258128 N3128RHuelsmann Gayle M · Albuquerque, NMBuilt 1967 · S/N 18258528 N3129DHawgs Landing LLC · Warrensburg, MOBuilt 1955 · S/N 31927 N3129JEagles Flying Club · Menominee, MIBuilt 1966 · S/N 15065829 N3129QUrbanowski Edward F · Paxton, MAS/N 18258129 N3129TMcdaniel Timothy A · Hutchinson, MNBuilt 1967 · S/N 17700429 N312AMDueck Arthur Peter · Lakewood, OHBuilt 1974 · S/N 177RG0562 N312CLBroadseam Aviation LLC · Kodak E, TNS/N 17263599 N312KMBaer Ryan D · Missoula, MTBuilt 1957 · S/N 32846 N312MMeehan Jeff B · Blue Springs, MOBuilt 1960 · S/N 56672 N312PDValdosta Flying Service Inc · Valdosta, GABuilt 2000 · S/N 172S8408 N312RMSunny Days Prop Jox LLC · Niceville, FLBuilt 2000 · S/N 18280872 N312SCBarker Family Investments Management Co LLC · Tyler, TXBuilt 1981 · S/N 21064474 N312SMShelbyville Flight Academy LLC · Smyrna, TNBuilt 1977 · S/N 17270091 N312TATaylor Charles E · Glen Ellyn, ILBuilt 1979 · S/N 17273565

Back to AD 79-10-14 R1