Skip to content

Registered aircraft · 40,473

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:80-04-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2') 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:80-04-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2')
  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:80-04-03-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2')
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.

N6174RLaurel Highlands Aeronautical Academy · Latrobe, PAS/N 172RG0103 N61752Lee Robert Eric · Charleston, WVBuilt 1975 · S/N 17264774 N61755K E F Enterprises · Plymouth, MABuilt 1975 · S/N 17264777 N61759Watkins Joe C · Albany, GABuilt 1975 · S/N 17264780 N6175GKimber 123 Holdings LLC · Morgantown, WVBuilt 1979 · S/N 17273574 N6175TNewell John D · Cleveland, TXBuilt 1994 · S/N RV-4-2722 N6175ZSpot-Air LLC · Burlington, TXBuilt 1959 · S/N 25-208 N61760Little Duane V · Puyallup, WABuilt 1975 · S/N 17264781 N61761Hawk Aviation Inc · Rush City, MNBuilt 1975 · S/N 17264782 N61763Bortoto Da Silva Alexandre · Fort Lauderdale, FLBuilt 1975 · S/N 17264784 N61764Wohlgemuth Terry D · Squaw Valley, CABuilt 1994 · S/N 1 N61765Dean Mark T · Van Alstyne, TXBuilt 1975 · S/N 17264785 N61769Jackson Lynn B · Cocoa Beach, FLBuilt 1975 · S/N 17264787 N6176DSawyer Stephen W · Brigham City, UTBuilt 1957 · S/N 22-4823 N6176GGaruda Flight Training LLC · Miami, FLBuilt 1979 · S/N 17273575 N6176JWertz Joseph S Jr · Shoemakersville, PABuilt 1976 · S/N 28-76-15321 N61770Mwbw LLC · Shawano, WIBuilt 1975 · S/N 17264788 N61772Henry Donald R · Lake Stevens, WABuilt 1975 · S/N 17264789 N61778Cambridge Valley Flying Club Inc · Shushan, NYBuilt 1975 · S/N 17264793 N6177NDesmarais Dan · Soldotna, AKBuilt 1993 · S/N 839 N61780Delaney Kevin P · Germantown, TNBuilt 1975 · S/N 17264794 N61783Copper River Airmotive LLC · Copper Center, AKBuilt 1975 · S/N 17264797 N61785Fort Sam Houston Flying Club · San Antonio, TXBuilt 1975 · S/N 17264799 N61786Northwest Wings LLC · Hillsboro, ORBuilt 1975 · S/N 17264800 N61789Padilla Frank J · Vacaville, CAS/N 17264802 N61794Dm Asset Management LLC · Plain City, OHBuilt 1975 · S/N 17264807 N61799Flf Aviation LLC · West Columbia, SCBuilt 1975 · S/N 17264810 N6179RMcclinton Charles R · Cape Coral, FLBuilt 1979 · S/N 172RG0104 N617DGFournier Jean Paul R · Ocala, FLBuilt 2003 · S/N 60185 N617EMarsh Michael B · Freeland, MIBuilt 2013 · S/N 75-8234 N617FLHarris Nancy B · Christiansburg, VABuilt 1971 · S/N 28-7125502 N617FMBurruss Lawrence R Jr · Charlottesville, VABuilt 1998 · S/N 22557 N617JBDoll Joseph L · Patterson, NCBuilt 2023 · S/N 69 N617MAAs The Crow Flies LLC · Belmont, WIBuilt 2003 · S/N 444-2003 N617TCCamp Thomas H · Melbourne, FLBuilt 1974 · S/N 18-7409120 N617WWood Jim · Seminole, TXBuilt 1973 · S/N 579-73 N61801Tampa Aviation Club Inc · Tampa, FLBuilt 1975 · S/N 17264811 N61803N61803 LLC · Manassas, VABuilt 1975 · S/N 17264812 N61812Craft Robert L · Cynthiana, KYBuilt 1975 · S/N 17264818 N61813Nationwide Aviation LLC · Hudson Oak, TXBuilt 1975 · S/N 17264819 N61814On Glideslope LLC · Middletown, DEBuilt 1975 · S/N 17264820 N61817Rb Aviation LLC · Vassar, MIBuilt 1975 · S/N 17264821 N6181DNolta Christopher D · Corcoran, CABuilt 1957 · S/N 18-5468 N6181FTarchinski James E · Rochester Hills, MIBuilt 1979 · S/N 17273161 N6181PLowe David M · Sacramento, KYBuilt 1959 · S/N 24-1283 N6181RTrahan Gregory M · Rayne, LABuilt 1979 · S/N 172RG0106 N61822Wings Over Texas Holdings LLC · Denton, TXBuilt 1975 · S/N 17264822 N61825Prestage Michael J · Hondo, TXBuilt 1975 · S/N 17264824 N6182DGr8daynevada LLC · Carson City, NVBuilt 1957 · S/N 18-5469 N6182WBarrette Jason W · Mandeville, LAS/N 28-20205

Back to AD 80-04-03 R2