Skip to content

Registered aircraft · 40,396

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-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:79-10-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:79-10-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:79-10-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:79-10-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:79-10-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.

N6174DOtoole Makena · Cordova, AKBuilt 1957 · S/N 22-4821 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

Back to AD 79-10-03 R2