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.

N399DPThomason Charles P · Columbus, GABuilt 1999 · S/N 2005N399ESBray Aviation LLC · Calera, OKBuilt 1997 · S/N 17280155N399HPPresley Denny · Tracy, CABuilt 2022 · S/N 81311N399JPL&M Aircraft Inc · Rome, GABuilt 1977 · S/N 177RG1111N399JTGiannoulas Chris Paul · Federal Way, WAS/N 28-7425315N399MJohnsey Stanford Wallace · Kingsville, TXBuilt 1990 · S/N 999N399MACavorite Aviaton LLC · West Jordan, UTBuilt 2004 · S/N 2843599N399RMEyles Edwin W Jr · Butler, PABuilt 1975 · S/N AA5A-0048N399RSRegistered aircraftBuilt 1999 · S/N 5477N399SBBuchanan Sam C · Athens, ALBuilt 1999 · S/N 25241N399TCTexas State Technical College · Waco, TXBuilt 2024 · S/N 28020190N399XHlavin Mark S Trustee · Lakewood Ranch, FLBuilt 1978 · S/N AA1C0192N39ACCoyle Whitney J · Edgewater, FLBuilt 2021 · S/N 24020N39AFTuskegee Airmen National Historical Museum Inc · Detroit, MIBuilt 1983 · S/N 9N39AHCapital Aircraft LLC · Juneau, AKBuilt 2001 · S/N 2140N39ALMcentire David J · Bainbridge, INBuilt 2005 · S/N 01N39BPEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1999 · S/N 2906N39BRSystems Research Corp · Wilmington, DEBuilt 1991 · S/N 122639N39CFFedrigo John A · Moneta, VAS/N 38-79A0765N39CTRotramel Paul D · Hardinsburg, KYBuilt 1968 · S/N 28R-30712N39CWWindham Charles R · Rogersville, TNBuilt 2012 · S/N 91447N39DBKwasinski Mark W · Kalamazoo, MIBuilt 1969 · S/N 153N39DCCruson Dale E · Ontario, ORBuilt 1993 · S/N 20374N39DRLehigh Valley Flying Club Inc · Lehigh Valley, PABuilt 1976 · S/N 28-7790221N39DUYokoo Kureha · Petaluma, CAS/N 22818N39ECSmith Adria A · Kingwood, TXBuilt 1968 · S/N 28-4985N39ESHowell Jeff D · Payette, IDBuilt 2010 · S/N 0100N39FZLongley Charles A · Nome, AKBuilt 1962 · S/N 18-7745N39GMonteleone Gene R · Mount Vernon, TXS/N 15N39GCWilliams Jeffrey D · Florence, ALBuilt 1980 · S/N AS123N39GDNovember Sierra Romeo LLC · Byron Center, MIS/N 10250N39GHApaka Lee K · Fairfield, CABuilt 1975 · S/N 65N39GMBacon Gregory A · Prairie Home, MOS/N 0001N39GTAshwill Gregory L Trustee · Overgaard, AZBuilt 2018 · S/N SC-100N39HBBartle Henson P · Independence, ORBuilt 2012 · S/N 1N39HUCallaghan Jonathan D · Driggs, IDBuilt 2015 · S/N 3234N39HYReed Hollow Aviation LLC · Franktown, COBuilt 2001 · S/N 2137N39JMJads Aviation LLC · Rowlett, TXBuilt 1960 · S/N 23-1943N39JPCabebe Brian M · Mesa, AZBuilt 1978 · S/N 217N39KWFier William J · Austin, TXBuilt 2000 · S/N 3374N39KYYang Chi · Lafayette, COBuilt 1979 · S/N 447995304N39LDMau Thomas E · Kenmare, NDS/N 18-5757N39LTGeorgia Forestry Commission · Macon, GABuilt 2003 · S/N 924-2003N39MRGraupman Gerald · Chicago, ILBuilt 1969 · S/N EGA-1N39NDTerwillegar Charles E · Renton, WABuilt 1967 · S/N R1720082N39NSMacair Inc · Corvallis, ORBuilt 1998 · S/N 2003N39RFHughes Todd R · Euless, TXBuilt 1996 · S/N 532N39RLAdams Nathan M · Edgewater, FLBuilt 1972 · S/N 416-HN39RSRoberts Terrance M · Fayetteville, ARBuilt 1980 · S/N RS001N39SDMbm Leasing LLC · Jacksonville, NCBuilt 1966 · S/N 28-3565
Back to AD 90-04-06 R1