AD 90-04-06 R1

Registered aircraft · 68,377

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
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-04-06-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-04-06-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.

N526WDenney Christopher R · Vicksburg, MSBuilt 1998 · S/N 21967N526WPPickering Gordon D · La Pine, ORBuilt 2020 · S/N 441N526WRFlorida And Caribbean Flight Training LLC · Punta Gorda, FLS/N 17269371N526WTDumler Marlin · Russell, KSBuilt 2020 · S/N 73673N52700Air Transport Inc DBA · Las Vegas, NVS/N 17274583N52701Cannon Michael A DBA · Blythe, CABuilt 1981 · S/N 17274584N52702Christiansen Aviation LLC · Wilmington, DEBuilt 1981 · S/N 17274585N5270HR & D Aircraft Inc · Jamestown, NCBuilt 1975 · S/N 17265390N52713Austin-Walker Aviation LLC · Waukee, IAS/N 177RG1255N52716Brewer Wesley G · Irvine, CAS/N 177RG1256N52719Pynn David W · Gasport, NYBuilt 1977 · S/N 177RG1257N5271LBright Skies Sales And Leasing LLC · Hendersonville, TNBuilt 1967 · S/N 28-4569N5271RAyala-Moore Kristopher · Tucson, AZBuilt 1974 · S/N 17263485N5271TOracle Aviation LLC · Omaha, NEBuilt 1972 · S/N 28R-7235212N5271U71 Uniform Corp · The Villages, FLBuilt 1980 · S/N 172RG0316N5271WBrown Thrasher Aero LLC · Midland, GABuilt 1962 · S/N 28-317N5271XRussell Steven N · Anchorage, AKBuilt 1969 · S/N 196N5271ZElliot Kirk R · Tulsa, OKBuilt 1961 · S/N 22-8963N52720Rick Aviation Inc · Newport News, VABuilt 1981 · S/N 17274592N52723Southern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1977 · S/N 177RG1258N5272AWelch Kevin R · Hartland, WIBuilt 1961 · S/N 23-2019N5272RRichmond Pilots Corp · Linden, NJBuilt 1974 · S/N 17263486N5272ZScheda Mark R · Brockport, NYBuilt 1961 · S/N 22-8965N5273LMancuso Dale · Dallas, TXFirst renewal noticeBuilt 1967 · S/N 28-4571N5273RClear Prop Aviation LLC · Sterling, VABuilt 1974 · S/N 17263487N5273SCarnegie Nursing Home Inc · Carnegie, OKBuilt 1971 · S/N 28-7125209N5273XToledo Jorge A · Miami, FLBuilt 1969 · S/N 175N52747Unicorn Papa Air LLC · Longwood, FLBuilt 1981 · S/N 17274598N52749Middle Tennessee State University · Murfreesboro, TNS/N 17274599N5274HLincoln Skyways Inc · Lincoln, CABuilt 1975 · S/N 17265392N5274LRetzer Daniel R · Rockford, ILBuilt 1967 · S/N 28-4573N5274XStallings Aircraft Propeller LLC · Wynne, ARBuilt 1969 · S/N 176N5274ZKotek Steven G · Sparta, WIBuilt 1961 · S/N 22-8967N52750Wieneke Robert A · Rockwall, TXBuilt 1981 · S/N 17274600N52756Fowler Jon E · Cal Nev Ari, NVBuilt 1943 · S/N 245N5275XKirschner David R · Mckeesport, PABuilt 1969 · S/N 177N5275ZRobertson James W · Cashmere, WABuilt 1961 · S/N 22-8968N52765Benson Daniel P · Lake Placid, FLBuilt 1977 · S/N 177RG1267N5276HYagcioglu Deniz S · Eatonton, GABuilt 1949 · S/N 16-80N5276LHaynie Sidney S · Sedona, AZBuilt 1968 · S/N 28-4575N5276MBruehl Kenneth · Roseville, CABuilt 1980 · S/N 15284513N5276WThird Step 2 LLC · Wilmington, DEFirst renewal noticeBuilt 1962 · S/N 28-323N5276XSanders Curtis E · Morrison, MOBuilt 1969 · S/N 212N5277HTurner Edward J III · Mokena, ILBuilt 1949 · S/N 16-81N5277SFers Mitchell A · Stafford Springs, CTBuilt 1970 · S/N 28-26908N5277WPerkins Nathan Zachery · Bonanza, ORBuilt 1962 · S/N 28-325N52786Moore Roger · Jonesboro, ARBuilt 1977 · S/N 177RG1270N52789Alameda Aero Club · Alameda, CABuilt 1981 · S/N 17274607N5278DN5278d LLC · Dover, DEBuilt 1979 · S/N 17272488N5278RHussain Mahmoud Taimour Said · Miami, FLBuilt 1974 · S/N 17263492
Back to AD 90-04-06 R1