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.

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 N2019SMoore Bobby E · Perry, OKBuilt 1975 · S/N 21060987 N2019XZarracina Robert · Stillwater, MNS/N 18256119 N2019YThuet Robert C · Spartanburg, SCBuilt 1962 · S/N 17249519 N201AAAdventures In The Sky Aviation LLC · Fresno, CABuilt 1959 · S/N 17352 N201CLWings Aero Club LLC · Union Hall, VABuilt 1967 · S/N 18258712 N201ELAa-Aero LLC · Lewes, DEBuilt 2026 · S/N 172S13545 N201EXPennington Sonja · Tutwiler, MSBuilt 1966 · S/N 18257642 N201FSRegistration Pending · Peoria, AZRegistration pendingBuilt 2000 · S/N 172S8453 N201KSKing Aircraft LLC · San Diego, CABuilt 2019 · S/N 172S12251 N201SHRyan L Phillips Inc · Campobello, SCBuilt 1973 · S/N 18262073 N201THG & M Aircraft Inc · Wheat Ridge, COBuilt 1997 · S/N 17280201 N201TWTom Wood Aviation Inc · Fishers, INBuilt 2025 · S/N 172S13294 N201WLRegistration Pending · Wichita, KSRegistration pendingBuilt 2026 · S/N 172S13570 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 N20204Bellingham James G · Baltimore, MDBuilt 1977 · S/N 17702644 N20207Disheroon Donald · Houston, TXS/N 17261095 N20208American Patrols Inc · Midland, TXBuilt 1972 · S/N 17261096 N2020CN2020c LLC · Abilene, TXBuilt 2005 · S/N 18281700 N2020GLyon John · Santa Barbara, CABuilt 1958 · S/N 51320 N2020XCullman Aviation Inc · Cullman, ALBuilt 1965 · S/N 18256120 N2020ZAbrahamson Nicholas P II · Grosse Ile, MIBuilt 1963 · S/N 15059820 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 N20217La Valle Jacque D · Lexington Park, MDBuilt 1977 · S/N 17702646 N20218Emporia Flying Club Inc · Emporia, KSBuilt 1972 · S/N 17261104 N20219Koenitzer Judson B · Chetek, WIS/N 17261105 N2021QHamilton Gregory J · Avon Lake, OHBuilt 1973 · S/N 177RG0421 N2021ZMclean Jr Rufus C · Rockingham, NCBuilt 1963 · S/N 15059821 N20221Ohair Mark O · Lampasas, TXFirst renewal noticeBuilt 1972 · S/N 177RG0273 N20222Coe Douglas R · Roswell, GAS/N 17702647 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 N20229Sale Reported · Wilmington, DESale reportedS/N 17702649 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 N20237Shortway Pilots Inc · Clearfield, PABuilt 1977 · S/N 17702650 N20238Valenti Jeffery N · Eastport, NYBuilt 1973 · S/N 17261122

Back to AD 79-10-14 R1