OpenAirDocs.org
AD 90-04-06 R1

Registered aircraft · 68,369

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.

N1586JLuczak Thomas W · Agoura Hills, CABuilt 1976 · S/N 13016N15871Atlaspar Aviation Group LLC · Lenoir City, TNBuilt 1972 · S/N 28-7305168N15873Miller Robert B · Davenport, FLBuilt 1972 · S/N 28-7305169N15875Cjb Investments22 LLC · Holly Hill, FLBuilt 1972 · S/N 28-7305171N1587HFowler James C · San Angelo, TXBuilt 1975 · S/N 177RG0761N15881Ruhnke James · Houston, TXBuilt 1972 · S/N 28-7305173N15882Ellwood David A · Cambridge, OHBuilt 1972 · S/N 28-7305174N15888Quimbayo Ligia I · Homestead, FLBuilt 1972 · S/N 28-7325189N1588EGeaux Giddum 1 LLC · Brandon, MSBuilt 1978 · S/N 17271054N1588JLampe Mark E · Minnetonka, MNBuilt 1967 · S/N 28-23997N1588PWar Eagles Air Museum · Santa Teresa, NMBuilt 1954 · S/N 18-3751N1588RRed Earth Trips Inc · Wilmington, DEBuilt 1975 · S/N AA5B-0088N1588VC-140 Company LLC · Milton, FLBuilt 1974 · S/N 17263683N15892Registered aircraftBuilt 1972 · S/N 28-7305177N15893Gammage Coy W · Delanco, NJS/N 28R-7335101N15894Dunlap Dalton · Port Neches, TXBuilt 1972 · S/N 28R-7335102N1589BWomack Thomas G · Lonoke, ARBuilt 1948 · S/N 6216N1589HAg Scouting Solutions LLC · Huntingdon, TNBuilt 1975 · S/N 177RG0763N158AGTwo Tails LLC · Las Vegas, NVBuilt 2018 · S/N CC19-0043N158CCRegistration Pending · Visalia, CARegistration pendingBuilt 1977 · S/N 28R-7737081N158FJN3955b Corp Trustee · Wilmington, DEBuilt 1965 · S/N 18-8312N158GATizard Aviation LLC · Phoenix, AZBuilt 1993 · S/N 2104N158GCWebster Scott A · Plant City, FLBuilt 1976 · S/N AA5A-0158N158NDSkyborne Airline Academy Inc · Vero Beach, FLBuilt 1998 · S/N 2842030N158PBBarnett Paul S · Brookhaven, MSBuilt 1961 · S/N TD-485N158PMLowrey Jonathan S · Jasper, INBuilt 1971 · S/N 17260064N158PTPilot Training Center LLC · Miami, FLBuilt 1989 · S/N 2841150N158RAJohneco Inc · Beachwood, OHBuilt 1999 · S/N 17280805N158RVVans Aircraft Inc · Aurora, ORBuilt 2001 · S/N 81541N158SBTargosz Andrew H · Orland Park, ILBuilt 1998 · S/N 1248-98N158SQGriffith Aviation Inc · Griffith, INBuilt 1978 · S/N ME-86N158SRDe Souza Ferdinand E · El Prado, NMS/N 630N158WUYale Companies LLC DBA · Indianapolis, INBuilt 2002 · S/N 4496158N15909Downes Pamela M · Chino Hills, CABuilt 1972 · S/N 28R-7335104N1590AChapman Dan W · Soldotna, AKBuilt 1951 · S/N 20-826N1590HWieting Roger L · Longview, TXBuilt 1975 · S/N 177RG0764N1590JTidwell Kevin C · Kennesaw, GABuilt 1967 · S/N 28-23999N1590PForgey Carl · Petersburg, AKBuilt 1954 · S/N 18-3755N1590VWingsleasing LLC · Wichita, KSBuilt 1974 · S/N 17263684N1590XLanders Stephen F · Riverview, FLBuilt 1975 · S/N 28R-7535344N15914Studt Joseph Floyd · Rockvale, COBuilt 1972 · S/N 28-7325197N15916Marianas Air Transfer Inc · Tinian, MPBuilt 1972 · S/N 28-7325199N15918Ramseier Peter A · Imperial Beach, CAS/N 28-7305185N15919Tikhomirov Anton · Ashland, MABuilt 1973 · S/N 28R-7335106N1591AKlein Frank J · Riley, KSBuilt 1951 · S/N 20-827N1591EWingsleasing LLC · Wichita, KSBuilt 1978 · S/N 17271057N1591JWingard Edward J · Powell, OHBuilt 1968 · S/N 28-24001N1591VAviation Academy LLC · Wichita, KSBuilt 1974 · S/N 17263685N15925Everglades Aviation Academy LLC · Weston, FLBuilt 1973 · S/N 34-7350109N159274dw Interests LLC · Longview, TXBuilt 1973 · S/N 28-7325202
Back to AD 90-04-06 R1