Skip to content

Registered aircraft · 54,019

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:87-20-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:87-20-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:87-20-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:87-20-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:87-20-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:87-20-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.

N20141Bbrrjd Inc · Wilmington, DEBuilt 1972 · S/N 17261042 N20142Johnson Lindley N · Kingstowne, VAS/N 17702635 N20143Loomis Aviation LLC · Gahanna, OHBuilt 1972 · S/N 17261044 N20145Avco Patrol LLC · Lyndon, KSS/N 17702636 N2014EWanda Collins Professional Pilot Services LLC · Madisonville, TXBuilt 1978 · S/N 17271118 N2014QRegistration Pending · Glennville, GARegistration pendingBuilt 1973 · S/N 177RG0414 N2014RDaedalus Wings Inc · Malvern, OHBuilt 1964 · S/N 18255214 N2014XTashjian Kirk G · Stanwood, WABuilt 1965 · S/N 18256114 N20151Binder Andrew S · Santa Barbara, CAS/N 17702637 N20154Jones 170a LLC · Bridgman, MIBuilt 1972 · S/N 17261051 N20155Wild Wingdom LLC · Greenville, SCBuilt 1972 · S/N 17261052 N20157Kelley Aircraft LLC · Weyers Cave, VABuilt 1972 · S/N 17261053 N20158Vbp Services LLC · Wainscott, NYBuilt 1972 · S/N 17261054 N20159Western Edge Aviation LLC · Dickinson, NDBuilt 1972 · S/N 17261055 N2015QMeyer Gregory L · Lebanon, PABuilt 1973 · S/N 177RG0415 N2015RBennett Peter D · Birmingham, ALBuilt 1964 · S/N 18255215 N2015XAircraft Trade Group LLC · Scandia, MNS/N 18256115 N2015YHoing Randal H Jr · Mexia, TXBuilt 1962 · S/N 17249515 N20169R D T Aviation Inc · Williston, VTBuilt 1972 · S/N 17261062 N2016RCoburn William L · Snohomish, WAS/N 18255216 N2016XSmith James A · Lyle, WAS/N 18256116 N2016ZPederson William K Jr · Hillsboro, ORBuilt 1963 · S/N 15059816 N20170Cardinal Group · Linden, MIS/N 17702639 N20172Queen City Aero Club Inc · Chelmsford, MABuilt 1972 · S/N 17261065 N20174Feighny James P · Rockville, MDS/N 17702640 N20175Jet Air Solutions Inc · Fort Myers, FLS/N 17261068 N20176Greenwood David L · Garrettsville, OHBuilt 1972 · S/N 17261069 N20177Nashville Flight School LLC · Nashville, TNBuilt 1972 · S/N 17261070 N20178Christopher Sandra A · Mabel, MNBuilt 1972 · S/N 17261071 N2017EPlane Fun Flying Club · Vancouver, WABuilt 1982 · S/N 18268183 N2017GZolezzi Paul A · Cottage Grove, ORS/N 51317 N2017QGraves William D · Rock Hill, SCBuilt 1973 · S/N 177RG0417 N2017XJensen Timothy L · Hudson, WIBuilt 1965 · S/N 18256117 N20181Mile High Aviation · Saint Peter, MNBuilt 1972 · S/N 17261074 N20182Gillies David K · Raymond, MEBuilt 1972 · S/N 17261075 N20183Registered aircraftBuilt 1972 · S/N 17261076 N20185Woodhams Jonathon R · South Haven, MIBuilt 1972 · S/N 17261078 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 N2018GWalsh Linda L · Anchorage, AKBuilt 1958 · S/N 51318 N2018XMahan Multimedia LLC · Lexington, KYS/N 18256118 N2018ZBurkel Shawn W · Greenbush, MNBuilt 1963 · S/N 15059818 N20190Parks William T · Jasper, TNBuilt 1973 · S/N 17261082 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

Back to AD 87-20-03 R2