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.

N456AMKrause Kade G · Jackson, MTBuilt 1998 · S/N 1412N456ASGutman Daniel W · North Andover, MABuilt 2004 · S/N 40.456N456BTHatfield Timothy E · Parowan, UTBuilt 2013 · S/N 4712N456CBCollins Bruce H · Caldwell, TXBuilt 1968 · S/N 17257257N456CCYale Companies LLC DBA · Indianapolis, INBuilt 2021 · S/N 2881506N456DSlesser Carl J · Crestwood, KYBuilt 1993 · S/N 21569N456DPBorder Zachary J · Molalla, ORBuilt 1991 · S/N 365N456DWJstream Lc · Sheridan, WYS/N 21040N456EMMiller William E · Goldsboro, NCBuilt 2013 · S/N 91893N456HLCrawford Clark W Trustee · La Quinta, CABuilt 2013 · S/N 72282N456HUCornelius Wayne · Mount Arlington, NJBuilt 1998 · S/N 1436N456JDLehner Jeffrey K Trustee · The Woodlands, TXBuilt 2004 · S/N 80485N456LLemma Joseph M · Parker, COBuilt 1962 · S/N 28-863N456MDMyres Mark D · Freeland, WABuilt 1996 · S/N 20107N456PBAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1997 · S/N 400-97N456PCMendelson Mark L · Owego, NYBuilt 2018 · S/N 25787N456PMBerry Michael G · Hot Springs, ARBuilt 1966 · S/N 28-22354N456PPRoberts Calvin D · Bluebell, UTBuilt 2025 · S/N BC-001N456RBSammons Michael A · Lubbock, TXS/N 654N456RHMalik Todd S · Matthews, NCBuilt 1979 · S/N AA5B1252N456RJGraae Michael Horace · Los Angeles, CABuilt 1995 · S/N 21701N456RRAir America Flight Center LLC · Daytona Beach, FLBuilt 1976 · S/N 28R-7635457N456SGGavitt Stephen M · Rensselaer, NYBuilt 2010 · S/N 91307N456SPAc Aviation LLC · Ocklawaha, FLBuilt 1999 · S/N 172S8320N456THB R S Leasing Inc · Wilmington, DEBuilt 1980 · S/N ME-319N456TWSchmidt Gail M · Florence, COBuilt 2007 · S/N 02-1217N456WMWright Alfred M · Toney, ALBuilt 2001 · S/N 001N456YDodson International Parts Inc · Rantoul, KSBuilt 2000 · S/N 2843353N4570MMatthews Richard W · Kasilof, AKBuilt 2018 · S/N 040750N4570WGuffey Jerry D · Lebanon, TNS/N 13060N4571HCosta Felipe R · Winston Salem, NCBuilt 1948 · S/N 15-345N4571WBernard Scott Sr · Denham Springs, LAS/N 13061N4571XFly Boys Aviation LLC · Tecumseh, MIS/N 28-7690039N4572WKelton Joel B · May, TXBuilt 1976 · S/N 13062N4573White James Jr · Glen Allen, VAS/N 101N4573JRoss James A · Barrington, RIS/N 28R-30438N4573RKaufmann Carl S · Springfield, MABuilt 1965 · S/N 28-21314N4573ZMatty Elizabeth · Tucson, AZS/N 22-8082N45747Paulson Christopher M · Eatonville, WABuilt 1943 · S/N 75-5459N4574JWakefield Aircraft LLC · Cooperstown, NDBuilt 1968 · S/N 28R-30439N4574RKing Vincent A · Grand Junction, COBuilt 1965 · S/N 28-21316N4574TBas Part Sales LLC · Greeley, COBuilt 1972 · S/N 34-7250137N4575FSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1976 · S/N 28-7715049N4575WN4575w LLC · Santa Fe Springs, CABuilt 1976 · S/N 13065N4575XPar Mar Bluffs LLC · Parker, SDS/N 28-7690034N4576FDakota Aviation LLC · Sioux Falls, SDBuilt 1976 · S/N 28-7715050N4576XElon Aviation LLC · Burlington, NCBuilt 1975 · S/N 28R-7635081N4576ZBauman Solomon A · Lyle, WAS/N 22-8085N4577Gateway Of Sturgis LLC · Sturgis, MIBuilt 1999 · S/N 172S8285N45786Janecek David · Eastsound, WAS/N AA5-0390
Back to AD 90-04-06 R1