Skip to content

Registered aircraft · 56,578

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.

N2377EBeck Roger M Trustee · Goode, VABuilt 1978 · S/N 17271256 N2377FBuoni Frank · Bakersfield, CABuilt 1965 · S/N 21058577 N2377GLutz Matthew S · Lewistown, MTBuilt 1958 · S/N 51677 N2377PLammers William Scott · Deer Park, ILBuilt 1998 · S/N 18280434 N2377XBieker Tor M · Hood River, ORBuilt 1965 · S/N 18256277 N2377YTerral William C · Farmerville, LABuilt 1998 · S/N 18280436 N23782Zylstra Cycle Co Inc · Ames, IAFirst renewal noticeBuilt 1999 · S/N 18280448 N23788Bellendir Timothy J · Fort Morgan, COBuilt 1967 · S/N R172E-0092 N2378CHovda H O · Progreso, TXBuilt 1953 · S/N 30678 N2378GStramel Matthew J · Elko, NVBuilt 1958 · S/N 51678 N23798Jet Air Inc · Iowa City, IABuilt 1998 · S/N 17280603 N2379DMoore Orville G · Hays, KSBuilt 1952 · S/N 20531 N2379RLanzetta Kenneth · Oakland Park, FLBuilt 1979 · S/N 18266988 N2379UAlaska Aircraft Leasing LLC · Silverdale, WABuilt 1962 · S/N 17249979 N2379XK Fortner LLC · San Marcos, TXS/N 18256279 N2379YThelwell Llansley · Frisco, TXBuilt 1967 · S/N 17700179 N237AJSuo Anttila Ahti · Albuquerque, NMBuilt 2000 · S/N 18280794 N237CADepartment Of Homeland Security · Washington, DCBuilt 2005 · S/N 20608239 N237CPCivil Air Patrol · Maxwell Afb, ALBuilt 2012 · S/N 18282348 N237CTSkymax LLC · Stanford, KYBuilt 1968 · S/N 18258819 N237DTBurque Sean Michael · New Braunfels, TXBuilt 1962 · S/N 17249862 N237FBGomez Preston Andreas · Bismarck, NDBuilt 2007 · S/N 18281916 N237MEWestbank Fishing LLC · Kiln, MSBuilt 2000 · S/N 18280756 N237SKAlf Ix LLC · Chicago, ILBuilt 2026 · S/N 172S13469 N237THWingsleasing LLC · Wichita, KSBuilt 2018 · S/N 172S12136 N23802Gherst Richard H · Seattle, WABuilt 2000 · S/N 20608137 N23807Crone Patrick · Reston, VABuilt 1999 · S/N 18280468 N2380AAircraft Engineering Inc · Eagle Lake, FLBuilt 1998 · S/N 17280617 N2380CH & M Aviation LLC · Calhoun, GABuilt 1999 · S/N 18280462 N2380DKovalchik Janet N Trustee · Kernersville, NCBuilt 1952 · S/N 20532 N2380RReep Nicolas K · Yakima, WABuilt 1964 · S/N 18255480 N2380XGaller Mary D Trustee · Elysian, MNBuilt 1965 · S/N 18256280 N2380YAlbert Jeffrey Frederick · Biltmore Lake, NCBuilt 1999 · S/N 18280465 N23816Malloy Dennis John · Mesquite, NVBuilt 1999 · S/N 18280470 N2381CLee Kevin M · Rexburg, IDBuilt 1954 · S/N 30681 N2381DShryock Jennifer M · King Salmon, AKS/N 20533 N2381FOops LLC · Cheyenne, WYBuilt 1965 · S/N 21058581 N2381GKittelman Thomas L · Gilbert, AZS/N 51681 N2381XCooper Scott J · Fellows, CABuilt 1965 · S/N 18256281 N2381ZLeone Brighter Developments LLC · Carlsbad, CABuilt 2005 · S/N 17281276 N2382DPerry Donald A · Colleyville, TXBuilt 1999 · S/N 18280471 N2382EGore Group LLC · Eagle Pass, TXBuilt 1999 · S/N 18280472 N2382GGish Joseph B · Lewiston, IDFirst renewal noticeBuilt 1958 · S/N 51682 N2382HWestbank Fishing LLC · Kiln, MSBuilt 1999 · S/N 18280473 N2382RTampa Bay Aviation Inc · Clearwater, FLBuilt 1999 · S/N 17280700 N2382SMielczarek Joe I · Santa Paula, CABuilt 1967 · S/N 337-0682 N2382UMrnm LLC · Albia, IABuilt 1963 · S/N 17249982 N2382XRolleston Moreton M III · Canton, GABuilt 1965 · S/N 18256282 N2382YBarnwater Development Inc · Ardmore, OKBuilt 1998 · S/N 18280380 N2383GChristiansen Aviation LLC · Wilmington, DEBuilt 1999 · S/N 17280701

Back to AD 79-10-14 R1