Skip to content

Registered aircraft · 20,683

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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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.

N20187Dewitt Troy C · Lake Elmo, MNS/N 17261080 N20188Creamer Rodger R · Venice, CABuilt 1961 · S/N 17248948 N20189Detroit Public Schools Community District · Detroit, MIS/N 17261081 N20190Parks William T · Jasper, TNBuilt 1973 · S/N 17261082 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 N2019YThuet Robert C · Spartanburg, SCBuilt 1962 · S/N 17249519 N201ELAa-Aero LLC · Lewes, DEBuilt 2026 · S/N 172S13545 N201FSRegistration Pending · Peoria, AZRegistration pendingBuilt 2000 · S/N 172S8453 N201KSKing Aircraft LLC · San Diego, CABuilt 2019 · S/N 172S12251 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 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 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 N20225N20225 LLC · Pottsboro, TXBuilt 1972 · S/N 17261110 N20226Morris Aero Club · Towaco, NJBuilt 1972 · S/N 17261111 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 N2023YCassero Ronald V · Santa Rosa, CABuilt 1962 · S/N 17249523 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 N20250Kooistra Samuel R · Honobia, OKBuilt 1972 · S/N 17261131 N20251Granahan Eric J · Burlington, WIBuilt 1972 · S/N 17261132 N20259Mackin Robert Michael · Castro Valley, CABuilt 1972 · S/N 17261136 N2025YMarine Resources Inc · Gilbert, AZS/N 17249525 N20262Sherman Aviation Inc · Redmond, ORBuilt 1972 · S/N 17261138 N20264Moltz Larry D · Seguin, TXBuilt 1972 · S/N 17261140 N20267Knot Grounded Aviation LLC · Napanoch, NYBuilt 1972 · S/N 17261143 N20268Fox Two LLC · Camino, CABuilt 1972 · S/N 17261144 N20270River Town Aviation LLC · Williamstown, WVBuilt 1972 · S/N 17261146

Back to AD 90-06-03 R1