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.

N364MSSkyhawk Aviation LLC · Omaha, NEBuilt 1997 · S/N 17280015 N364SAJackson Edwin W · Tampa, FLBuilt 1999 · S/N 17280757 N364SPVermont Flight Academy · South Burlington, VTBuilt 2001 · S/N 172S8782 N364SRSales Joe H DBA · Seminole, TXBuilt 1964 · S/N 17251558 N3650CTotty Michael N · Gainesville, MOBuilt 1954 · S/N 31148 N3650JPostle Jessica Grace · Newark, OHBuilt 1966 · S/N 15064950 N3650LTom Wrolstad Aircraft LLC · Molalla, ORBuilt 1965 · S/N 17253819 N3651UDeibel Adam · Flagstaff, AZS/N 18255051 N3652JJet Boy LLC · Carlsbad, CABuilt 1966 · S/N 15064952 N3652LJbm Aviation LLC · Mc Leansboro, ILBuilt 1965 · S/N 17253821 N3652SBennett Quinn S · Sterling, AKS/N 15062745 N3652YMokhtari Rasoul · Nashville, TNBuilt 1963 · S/N 21058152 N3653CDomingquez Clara · Anchorage, AKBuilt 1954 · S/N 31151 N3653JGrachev Timofey · Hammond, WIBuilt 1966 · S/N 15064953 N3653LRistau Kent T · Eagle Grove, IABuilt 1965 · S/N 17253822 N3653UMedeiros Germano Manuel · Caruthers, CABuilt 1963 · S/N 18255053 N3654CRose Hugh S · Fairbanks, AKBuilt 1954 · S/N 31152 N3654LHeritage In Flight Museum Inc · Lincoln, ILBuilt 1965 · S/N 17253823 N3655CViavant Toby S · Ester, AKBuilt 1954 · S/N 31153 N3655UBoggs Dennis E · Buffalo, WYBuilt 1963 · S/N 18255055 N3656JLofland Aviaiton LLC · Moscow Mills, MOBuilt 1966 · S/N 15064956 N3656SBell Michael L · Spokane, WAS/N 17250856 N3656UMccarty Troy Allen · New Plymouth, IDBuilt 1963 · S/N 18255056 N3657LHollabaugh David S · Fulton, MOBuilt 1965 · S/N 17253826 N3657SIsakson Dennis E · Van Tassell, WYBuilt 1963 · S/N 17250857 N3657YSims Daniel G · Martinez, CABuilt 1963 · S/N 21058157 N3658JBernbeck Alan R · Benton, KSBuilt 1966 · S/N 15064958 N3658LGraczyk Michael E · Lake Elmo, MNBuilt 1965 · S/N 17253827 N3658SOrlovich John A · Boise, IDS/N 17250858 N3658YJo Co Inc · Knoxville, TNFirst renewal noticeBuilt 1963 · S/N 21058158 N3659CWhite Paul S · Clarksville, TNBuilt 1954 · S/N 31158 N3659JHenderson Mark A · Duluth, GABuilt 1966 · S/N 15064959 N3659SWeed Thomas W · Limington, MEBuilt 1963 · S/N 17250859 N3659YPeterson Laurel R · Hart, MIBuilt 1963 · S/N 21058159 N365CACivil Air Patrol · Maxwell Afb, ALBuilt 2008 · S/N 18282117 N365CPBarr Air Patrol LLC · Mesquite, TXBuilt 2001 · S/N 172S8838 N365ESLakewood Investments LLC · Victorville, CABuilt 1997 · S/N 17280023 N365FCRegistration Pending · Kalispell, MTRegistration pendingBuilt 1973 · S/N 18502233 N365JBHentges Dave · Canby, MNBuilt 1952 · S/N 25419 N365MADip Aviation LLC · Fort Lauderdale, FLBuilt 1999 · S/N 18280582 N365MEEhnisz Craig T · Monterey, CABuilt 2000 · S/N 18280855 N365PCWings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 17271033 N365RARanger Airfield Foundation · Ranger, TXBuilt 1972 · S/N 15073416 N365SPClow International Airport LLC · Bolingbrook, ILBuilt 2001 · S/N 172S8783 N365WCCrane Douglas F · Ukiah, CABuilt 2002 · S/N 18281170 N3660LBersig James R · La Palma, CAS/N 17253829 N3661CAas LLC · Ovid, MIBuilt 1954 · S/N 31160 N3661SMiller Harvey L · Livonia, MIBuilt 1963 · S/N 17250861 N3661TOmega 1 Corp · Middletown, DEBuilt 1958 · S/N 51001 N3661UGlenney Christopher · Milan, NHBuilt 1963 · S/N 18255061

Back to AD 79-10-14 R1