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.

N20365Atlas Aero Training LLC · Casper, WYBuilt 1972 · S/N 17261227 N20366Depouli Raymond M · Enumclaw, WABuilt 1972 · S/N 17261228 N20368Beaver Flying Club Inc · Xenia, OHS/N 17261230 N20376Kelley Aircraft LLC · Weyers Cave, VABuilt 1972 · S/N 17261237 N20377Moore James E · Arroyo Grande, CABuilt 1972 · S/N 17261238 N2037YArgos Retail LLC · Mcallen, TXBuilt 1962 · S/N 17249537 N20381Dsr-Cherokee 180 LLC · Dallas, TXBuilt 1972 · S/N 17261241 N20382Bass Philip D · Oviedo, FLS/N 17261242 N20384Rutherford Jeffrey L · Montgomery, ALBuilt 1972 · S/N 17261244 N20387Bybee Mark J · De Soto, ILBuilt 1972 · S/N 17261247 N20389Kcn Aero Club Inc · Overland Park, KSBuilt 1972 · S/N 17261249 N2038EStevens Michael J Jr · Humble, TXBuilt 1978 · S/N 17271127 N20390Mitiguy Aviation LLC · Stow, MABuilt 1972 · S/N 17261250 N20392Registration Pending · Miami, FLRegistration pending, pending cancellationBuilt 1972 · S/N 17261252 N20393Nextgen Flying LLC · Pigeon Forge, TNBuilt 1972 · S/N 17261253 N20398Laron W Hall · Hurricane, UTBuilt 1972 · S/N 17261258 N20399Total Flight Aircraft Leasing LLC · Apex, NCBuilt 1972 · S/N 17261259 N203CPCivil Air Patrol · Maxwell Afb, ALBuilt 2020 · S/N 172S12501 N203GTUniversity Of Michigan Flyers Inc · Ann Arbor, MIBuilt 1979 · S/N 17272403 N203KSMichael Lichtman Inc · Oceanside, CAFirst renewal noticeBuilt 2001 · S/N 172S8856 N20401Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12519 N20402Fosdick Kenneth E · Plymouth, MABuilt 1972 · S/N 17261261 N20404Air Data Solutions LLC · Natchitoches, LABuilt 1972 · S/N 17261263 N20405Buffalo Wings LLC · Overland Park, KSS/N 17261264 N20406Sp Airparts LLC · Moscow, IDS/N 17261265 N20412Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12520 N20413Colton Terence J · Point Roberts, WABuilt 1972 · S/N 17261270 N20417Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12522 N20418Pierce Scott W · Fredonia, NYBuilt 1972 · S/N 17261273 N20420N83993 LLC · Cherry Hill, NJBuilt 1972 · S/N 17261275 N20421West Michigan Flying Club Inc · Norton Shores, MIBuilt 1972 · S/N 17261276 N20422Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12523 N20423Lowcountry Flight LLC · Johns Island, SCBuilt 1972 · S/N 17261278 N20425Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12524 N20427Sleight Craig R · Prineville, ORBuilt 1972 · S/N 17261280 N2042QKachemak Bay Flying Service Inc · Temple, TXBuilt 1975 · S/N 17265453 N20431Organization Of Black Aerospace Professionals · Westchester, ILBuilt 1972 · S/N 17261283 N20437Wingsleasing LLC · Wichita, KSBuilt 1972 · S/N 17261287 N20439Wilken Virginia · Sequim, WABuilt 1972 · S/N 17261289 N2043YGrierson Robert A · Queen Creek, AZBuilt 1962 · S/N 17249543 N20443Walker Martha D · Auburndale, FLBuilt 1972 · S/N 17261291 N20445Norman Chuck DBA · Zanesville, OHBuilt 1972 · S/N 17261293 N20451Registration Pending · Swainsboro, GARegistration pendingBuilt 1972 · S/N 17261297 N20452Bay Flying Services LLC · Pinconning, MIBuilt 1972 · S/N 17261298 N20454Rl Aviation LLC · Miami, FLBuilt 1972 · S/N 17261300 N20455Kachemak Bay Flying Service Inc · Temple, TXBuilt 1972 · S/N 17261301 N20457Gulf Atlantic Airways Inc · Gainesville, FLBuilt 1972 · S/N 17261303 N2045YAir Dakota Flite Inc · Hettinger, NDBuilt 1962 · S/N 17249545 N204648231 Tango Enterprises LLC · Guthrie, OKBuilt 1972 · S/N 17261308 N20465C Flyers Inc · Dyersville, IABuilt 1972 · S/N 17261309

Back to AD 90-06-03 R1