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.

N4686ESieh Colton David · Kotzebue, AKS/N 7EC-34N4686LGlenn Roger H · Pacifica, CABuilt 1980 · S/N 15284216N4686VRegistration Pending · Patterson, LARegistration pendingS/N 172RG0365N4686ZMacmoyle Scott · Blairstown, NJBuilt 1961 · S/N 22-8222N4687JPletcher Enterprises Inc · Muscatine, IABuilt 1968 · S/N 28R-30589N4687MHock Rocky · Culbertson, NEBuilt 1947 · S/N 11-196N4687RMontz Steven Andrew · Mandeville, LABuilt 1966 · S/N 28-21448N4687VSharp Cutlass LLC · Iowa City, IABuilt 1980 · S/N 172RG0366N4687WAmerican Dream Aviation LLC · Woodhaven, NYBuilt 1978 · S/N 13263N46889Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1979 · S/N 15283133N4688RGerdes T Michael · Brownsburg, INBuilt 1966 · S/N 28-21449N4688WCurtis Stephen L · Parker, COBuilt 1978 · S/N 13264N4688ZBurlew Richard · Richlands, NCBuilt 1961 · S/N 22-8225N4689JFlynn Charles F · Helena, MTBuilt 1968 · S/N 28R-30591N4689RRegistered aircraftAssigned, pending cancellationS/N 28-21450N4689XGerard Aircraft Inc · Johnson, KSBuilt 1966 · S/N 15064739N4689ZDavis James J · Leonardtown, MDBuilt 1961 · S/N 22-8227N468AKAkima Logistics Services LLC · Colorado Springs, COBuilt 2018 · S/N CC18-0087N468BCHot Wings Flying Club LLC · Portland, ORBuilt 1975 · S/N AA5B0195N468CBorn John · Jupiter, FLBuilt 1980 · S/N 213N468CMUniversity Of Central Missouri · Warrensburg, MOBuilt 2000 · S/N 17280860N468DMSkinner John Jay · Gainesville, FLBuilt 1998 · S/N M-II-1750N468FAMain Line Flight School LLC · Haverford, PABuilt 2022 · S/N 28020068N468HASkotz Helicopter Services LLC · Bertram, TXBuilt 1967 · S/N 7870N468JLCarothers Alexander F · Anthony, NMFirst renewal noticeBuilt 1999 · S/N 80286N468PMEarspasm LLC · Brooklyn, NYBuilt 1972 · S/N 28R-7335041N468SLd Funding LLC · Piscataway, NJBuilt 1994 · S/N 243324N468TCMcnorton Dan B · Seguin, TXS/N 23208N468WPerson Matt · Denton, NEBuilt 1978 · S/N 24-0404N46907Bagamaspad Alan Antonio · Los Angeles, CABuilt 1979 · S/N 15283137N4690RCannon Kyle J · Salt Lake City, UTBuilt 1966 · S/N 28-21452N4690ZFialcowitz Thomas L · Hotchkiss, COBuilt 1961 · S/N 22-8228N4691RBest Equipment Leasing LLC · Bakersfield, CABuilt 1966 · S/N 28-21453N4691SRobertson Sterling P · Abilene, TXBuilt 1965 · S/N 1N4691THirsch Michael V · Cambridge, MABuilt 1959 · S/N 22-6713N4691WHerndon Kenny L · Canton, GAS/N 13267N4692JDingbat Ltd · Wilmington, DEBuilt 1968 · S/N 28R-30595N4692QZulu Aircraft Leasing LLC · Grants Pass, ORBuilt 1973 · S/N 17261745N4692RKaresh Eli · Orlando, FLBuilt 1966 · S/N 28-21454N4692WMiss Renee LLC · Wilmington, DEBuilt 1978 · S/N 13268N4692YBillingsley Robin Trustee · Chugiak, AKBuilt 1971 · S/N 18-8952N4693JThibodeaux Gerald J · Duson, LABuilt 1979 · S/N 17273663N4693QSievert David M · Santa Cruz, CABuilt 1973 · S/N 17261746N4694GRegistered aircraftBuilt 1979 · S/N 17273320N4694RKent Adam · Rogersville, MOBuilt 1966 · S/N 28-21457N46953Pea-Wayman Flight LLC · Daytona Beach, FLBuilt 1979 · S/N 15283149N4695JGrimm Jason Eddison · Sacramento, CAS/N 28R-30598N4695RDestination Flyer LLC · Memphis, TNBuilt 1966 · S/N 28-21459N4695SDavis Lawrence E · Melbourne, KYBuilt 1973 · S/N 003N4695WRalstin Gregory J · El Dorado Hills, CABuilt 1978 · S/N 13271
Back to AD 90-04-06 R1