Skip to content

Registered aircraft · 40,395

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.

N2018PHauer Clifford Joseph Jr · Woodstock, GABuilt 1956 · S/N 23-590 N20190Parks William T · Jasper, TNBuilt 1973 · S/N 17261082 N20191Warbington Michael L · Enid, OKBuilt 1983 · S/N 15-578 N20192Registered aircraftBuilt 1977 · S/N 17702643 N20193Gibbs Wyatt Richmond · Lodi, CAS/N 17261085 N20195Vertol Systems Company Inc · Destin, FLBuilt 1972 · S/N 17261087 N20196Bergfalk Craig Steven · Anacortes, WAS/N 17261088 N201975 Degrees North Inc · East Stroudsburg, PABuilt 1972 · S/N 17261089 N20199Worms Jeffrey J · Bonita Springs, FLBuilt 1972 · S/N 17261090 N2019ECox Garry G · Coleman, TXS/N 17271120 N201HWRichards Troy L · Saint Jo, TXBuilt 2005 · S/N 2803 N201MNWeidner Jamie A · Perrysburg, OHBuilt 1966 · S/N 1242 N201SFOmara Michael N · Seymour, CTBuilt 1965 · S/N 28-2630 N201TMerten James F · Oshkosh, WIBuilt 1970 · S/N 186 N201ZBBrowne Michael T · Ada, OKBuilt 1978 · S/N 24-0415 N20201Castillo Frank E · San Jose, CABuilt 1972 · S/N 17261091 N20202Lolani Leasing LLC · Los Angeles, CABuilt 1972 · S/N 17261092 N20203Wannenburg Thomas · Atlantic Beach, FLBuilt 1972 · S/N 17261093 N20207Disheroon Donald · Houston, TXS/N 17261095 N20208American Patrols Inc · Midland, TXBuilt 1972 · S/N 17261096 N20211Lee Cas LLC · Macomb, ILBuilt 1972 · S/N 17261098 N20213Valiair Limited Company Trustee · Casper, WYBuilt 1972 · S/N 17261099 N20214Bingairman LLC · Newville, PABuilt 1977 · S/N 17702645 N20215Northeastern Financial LLC · New Gloucester, MEBuilt 1972 · S/N 17261101 N20216Manke Derek E · Canton, GABuilt 1972 · S/N 17261102 N20218Emporia Flying Club Inc · Emporia, KSBuilt 1972 · S/N 17261104 N20219Koenitzer Judson B · Chetek, WIS/N 17261105 N2021CPray Aviation Inc · Augusta, KSBuilt 1959 · S/N TD-212 N2021LNiehaus James O · Erie, COBuilt 1967 · S/N 354 N2021RYergers Garage LLC · Leesport, PABuilt 1969 · S/N 28-5429 N20223Roberts Stephen Wade · Friendswood, TXBuilt 1977 · S/N 17702648 N20225N20225 LLC · Pottsboro, TXBuilt 1972 · S/N 17261110 N20226Morris Aero Club · Towaco, NJBuilt 1972 · S/N 17261111 N2022CCarriere James M · Navarre, FLBuilt 1959 · S/N TD-189 N20230Cessna 20230 LLC · Windsor, CABuilt 1972 · S/N 17261115 N20232Lopez Tail Draggers LLC · Lopez Island, WABuilt 1972 · S/N 17261116 N20233Jenkins Robert W · Fredericktown, OHBuilt 1972 · S/N 17261117 N20236Safety In Motion Flight Center Inc · Puyallup, WAS/N 17261120 N20238Valenti Jeffery N · Eastport, NYBuilt 1973 · S/N 17261122 N2023RWhitehurst Brian P Trustee · Crossville, TNBuilt 1969 · S/N 28-5430 N20241Aviation 241 Inc · North Lima, OHBuilt 1972 · S/N 17261124 N20242Gent John F · Wellman, IABuilt 1972 · S/N 17261125 N20243Webb John W · Elkins, WVBuilt 1972 · S/N 17261126 N20246Olek Brad · New Richmond, WIBuilt 1972 · S/N 17261127 N20247Grace Ellen M · Bloomville, NYBuilt 1972 · S/N 17261128 N2024CD M S Leasing Co LLC · Las Vegas, NVBuilt 1959 · S/N TD-198 N2024PYounhorsh Sales LLC · Wilmington, DEBuilt 1956 · S/N 24-1 N2024RStorm David A · Lowell, ARBuilt 1969 · S/N 28-5432 N20251Granahan Eric J · Burlington, WIBuilt 1972 · S/N 17261132 N20259Mackin Robert Michael · Castro Valley, CABuilt 1972 · S/N 17261136

Back to AD 79-10-03 R2