Registered aircraft · 20,687

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.

N8394XBates Dale R · Cincinnatus, NYBuilt 1961 · S/N 17248894 N8395BHughston Chris · Nashville, TNBuilt 1957 · S/N 36195 N8395XAccurate Aviation LLC · Spring City, UTBuilt 1961 · S/N 172-48895 N8396XKnierim Erik E · Puyallup, WABuilt 1961 · S/N 17248896 N8397BDiaz George D · Tucson, AZBuilt 1957 · S/N 36197 N8397XGeist Jeffrey A · Avondale, PABuilt 1961 · S/N 17248897 N8398BThal James C · Fredericktown, MOBuilt 1957 · S/N 36198 N8398LWingsleasing LLC · Wichita, KSBuilt 1968 · S/N 17256598 N8398UAdrenaline Junkies LLC · Richfield, UTBuilt 1964 · S/N 17252298 N8398XCummings Thomas H · Lewistown, MTS/N 17248898 N8399BHumphrey William J · Whiteville, NCBuilt 1957 · S/N 36199 N8399LSanders George W Jr · Cloverdale, INBuilt 1968 · S/N 17256599 N8399XWard Bruce · Fowlerville, MIBuilt 1961 · S/N 17248899 N839CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 172S11587 N839EREmbry-Riddle Aeronautical University · Daytona Beach, FLBuilt 2021 · S/N 172S12670 N839KSKansas State University · Salina, KSBuilt 2019 · S/N 172S12309 N839SPHillsboro Aero Academy LLC · Hillsboro, ORBuilt 2001 · S/N 172S8728 N83AFN83af LLC · Stuart, FLBuilt 2001 · S/N 17281052 N83EWTremarco Philip J · Anchorage, AKS/N 17261231 N83FPPhillips Tom Scott · Beach City, TXBuilt 1978 · S/N 17271377 N83JHVolar Viii LLC · Edmond, OKBuilt 2026 · S/N 172S13516 N83JXTextron Aviation Inc · Wichita, KSS/N 172S13604 N83SFChristiansen Aviation LLC · Wilmington, DEBuilt 2003 · S/N 172S9403 N84009Swenson Catherine A Trustee · Meadow Vista, CABuilt 1969 · S/N 17258299 N8400LInstant Print Signs & Designs LLC · Kalispell, MTBuilt 1968 · S/N 17256600 N8400XBurlingame Craig D · Catlett, VABuilt 1961 · S/N 17248900 N84019Snodgrass William D · Moberly, MOFirst renewal noticeBuilt 1969 · S/N 17258303 N8401LBlack Baron Air LLC · Kalispell, MTS/N 17256601 N8401UMorales Jerardo S · Belleville, ILBuilt 1964 · S/N 17252301 N8401XWilkinson Bert D · Sandpoint, IDBuilt 1961 · S/N 17248901 N84024Maurano Michael R · Long Island, VABuilt 1969 · S/N 17258304 N84026Smith William A Jr · Tulsa, OKBuilt 1969 · S/N 17258305 N8402LVan Bortel Inc · Victor, NYBuilt 1968 · S/N 17256602 N8402UWj Rothwell Ranch Co · Hyannis, NEBuilt 1964 · S/N 17252302 N8402XDominy Geary B · Flint, TXS/N 17248902 N84036Wings Over Texas Holdings LLC · Denton, TXBuilt 1969 · S/N 17258308 N8403UAnderson Larry L · Silver City, NMBuilt 1964 · S/N 17252303 N84048Kyzer Aviation Holdings LLC · Fort Mill, SCBuilt 1969 · S/N 17258314 N8404UAviation Career Enrichment Inc · Atlanta, GABuilt 1964 · S/N 17252304 N8404XHousel LLC DBA · Palm Harbor, FLS/N 17248904 N84050Alpenglow Air 2 LLC · Anchorage, AKBuilt 1969 · S/N 17258315 N8406244 Flyers · Harlowton, MTBuilt 1969 · S/N 17258319 N84063Rothermel Donald M · Mokena, ILBuilt 1969 · S/N 17258320 N8406LVee Neal Aviation · Latrobe, PABuilt 1968 · S/N 17256606 N8406UGrzincich Michael J · Coon Rapids, MNBuilt 1964 · S/N 17252306 N84071Roadrunner Flight School LLC · Farmington, NMBuilt 1969 · S/N 17258322 N84072Ferre Taylor · Kirkland, WABuilt 1969 · S/N 17258323 N84076Third Step 3 LLC · Gilbert, AZBuilt 1969 · S/N 17258325 N8407LPlainwell Aviation And Stem Academy · Kalamazoo, MIBuilt 1968 · S/N 17256607 N8407XDouthett Fontaine · Deland, FLBuilt 1961 · S/N 17248907

Back to AD 90-06-03 R1