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.

N56429Norman Ronald E · Lopez Island, WABuilt 1973 · S/N 287325628N5642HSlaughter Don W · Farmville, NCFirst renewal noticeBuilt 1949 · S/N 16-253N5642TMark C Petersen · Sturgeon Bay, WIBuilt 1998 · S/N 21049CN56432Ladig Aviation LLC · Mount Washington, KYS/N 287305591N5643LChaney Timothy W · Peoria, AZBuilt 1968 · S/N AA1-0043N5643QGray Eric W · Erie, COBuilt 1965 · S/N 3020N5643UExotic Sky LLC · Kalispell, MTBuilt 1969 · S/N 28-26439N5643ZMcduffie Rodney D · Cullman, ALBuilt 1981 · S/N 8019CN56440Registration Pending · Wilmington, NCRegistration pending, pending cancellationS/N 28R7335437N5644HPoliti Terris P · Lake Placid, NYBuilt 1949 · S/N 16-255N5644LMartinez Pedro M · BreeNon-citizen corporation, flight hours not reportedBuilt 1968 · S/N AA1-0044N5644QRichey Johnny · Shady Shores, TXBuilt 1965 · S/N 678N5644UDonaubauer Stefan · Charlotte, NCBuilt 1969 · S/N 28-26441N5644ZVon Drashek Bruce P · Prior Lake, MNBuilt 1962 · S/N 22-9461N564514gaviation LLC · Reading, PABuilt 1973 · S/N 287305595N56453Richard G Trudeau LLC · Alto, TXBuilt 1973 · S/N 28R-73-35439N5645FReddoch Mark W Jr · Vidor, TXBuilt 1976 · S/N 28-7790133N5645HYoder James J · Canby, ORS/N 16-256N5645LT2tc LLC · Enka, NCBuilt 1968 · S/N AA1-0045N5645URegistration Pending · Huntingdon, TNRegistration pendingBuilt 1969 · S/N 28-26440N56460Cessna 7870u LLC · Ottumwa, IABuilt 1973 · S/N 28-73-05596N56461Woody Aaron Michael · Cypress, TXBuilt 1973 · S/N 28R-73-35438N5646HRiley Matthew M · White Salmon, WABuilt 1949 · S/N 16-257N5646LHutcheson Bruce D · Anthem, AZBuilt 1968 · S/N AA1-0046N5646NTennison Gary D · Marion, TXS/N 9010CN5646UPn4 Aviation Holdings LLC · Bishop, CAS/N 28-26442N56473Registration Pending · Fort Worth, TXRegistration pendingBuilt 1973 · S/N 287325635N56474Sampson David M · Clancy, MTBuilt 1973 · S/N 28-7425003N5647UVargas Orlando O · San Bernardino, CABuilt 1969 · S/N 28-26443N5647WAuer David A · Springfield, ILBuilt 1962 · S/N 28-804N56487Burleson Jerry H · Grapevine, TXBuilt 1973 · S/N 28-73-25639N56488Pensacola Navy Flying Club Inc · Pensacola, FLBuilt 1973 · S/N 28R-73-35444N5648QMartin Phil S · Colorado Springs, COBuilt 1965 · S/N 680N5648WSpinetta Lawrence J · Austin, TXBuilt 1962 · S/N 28-807N5649GMaran Properties LLC · Lowell, ARBuilt 1979 · S/N 17273564N5649PTalarek Kai C · Far Hills, NJBuilt 1959 · S/N 24-720N5649QTaylor Clayton T · Stockton, KSBuilt 1965 · S/N 3023N5649UAzille Keran · Massapequa, NYBuilt 1969 · S/N 28-26445N5649WSmith James L Jr · Des Arc, ARBuilt 1962 · S/N 28-808N5649ZDyson Keith A · Port Townsend, WABuilt 1962 · S/N 22-9472N564BCBravo Charlie Aviation Inc · Middletown, DENon-citizen corporation, flight hours not reportedBuilt 1984 · S/N 299N564DFPreiss Michael C · Southaven, MSS/N 269N564FLFlyguys Cessna 182 LLC · Royal Palm Beach, FLBuilt 1971 · S/N 28-7125406N564GHughes Ramzi S · Alamo, NVBuilt 1968 · S/N 15068276N564KAtp Aircraft 3 LLC · Wilmington, DEBuilt 2017 · S/N 2843880N564MAIndia Charlie Alpha Aviation LLC · Missoula, MTBuilt 2005 · S/N 989-2005N564MCB Air Lc · Sikeston, MOBuilt 2000 · S/N 172S8512N564MML A M Capital Management LLC · Sheridan, WYBuilt 1982 · S/N 17275714N564MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2003 · S/N 40.300N564PUPurdue Aviation LLC · West Lafayette, INBuilt 2002 · S/N 2842169
Back to AD 90-04-06 R1