OpenAirDocs.org
AD 90-04-06 R1

Registered aircraft · 68,375

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.

N33CMCharley Ernie · Gakona, AKBuilt 1976 · S/N 18-7609082N33CRConstitutional Defense Arizona LLC · Scottsdale, AZBuilt 1977 · S/N 28-7725287N33CTThree Wing Flight School LLC · Stratford, CTBuilt 1977 · S/N 28-7890136N33DBBowers Albert Joseph Jr · Aberdeen, MDBuilt 1970 · S/N 17701451N33DGStout Russell · Theodosia, MOBuilt 2012 · S/N 70168N33DHHarrington David · Lake Saint Louis, MOBuilt 1966 · S/N MB-4N33DSAvion Ahoy LLC · Jacksonville, FLS/N 680176N33DVKostreva Adam · Riverton, WYBuilt 1970 · S/N 234-70N33ECMccammon Aviation LLC · Sullivan, INS/N 28-7225182N33EFJarosak Theodore J Jr · Portage, INBuilt 1985 · S/N 1345N33ELAdvancing Blade LLC · Glenwood, MNBuilt 1992 · S/N 20770N33ERCrump Edward J · Boonton, NJBuilt 1978 · S/N AA5B0884N33ESDuncan Ernest Michael · Dripping Springs, TXBuilt 1976 · S/N 28R-7635461N33EYYoung Robert E · Princeton, NCBuilt 2016 · S/N 11354N33FKMotis Joseph D · Huntington Beach, CABuilt 1970 · S/N 28-5763N33FUZeiset Karl D · Salmon, IDBuilt 1979 · S/N 241N33GLJohnston Jeremy A · Cedar Springs, MIBuilt 1983 · S/N 532N33GRHeadrick John Eric · Eolia, MOS/N 259-76N33GSFish N Fly LLC · Hobe Sound, FLS/N 15281292N33GVMilhous Richard J · Aguila, AZBuilt 2017 · S/N PETERSON 3N33HJMoore Michael E · Renton, WABuilt 1976 · S/N 1974N33HSN33hs LLC · Tallahassee, FLS/N 1HSN33HURunzel Brothers Aviation LLC · Bensenville, ILS/N 1310N33JSaunders Dwayne E · Cary, NCBuilt 1973 · S/N JF-1N33JCMurphree Matthew · San Marcos, TXBuilt 1977 · S/N 28-7890144N33JFKimsey Thomas Wayne · Warner Robins, GABuilt 1965 · S/N 30-820N33JJFincor Inc · Miami Beach, FLBuilt 1972 · S/N AA5-0061N33JKMidway Aviation Co · Plant City, FLBuilt 1977 · S/N 7-0132N33JXProuty Timothy V Trustee · North Providence, RIBuilt 1977 · S/N AA5B0585N33KMathison John Michael · Fernley, NVBuilt 1977 · S/N 828N33KJPlane Fun Inc · Bow, WABuilt 1998 · S/N 23035N33LJUniversal Aviators Academy Inc · El Monte, CABuilt 1978 · S/N 15282023N33LTKelly Tony R · Aberdeen, MSBuilt 1997 · S/N 799-97N33LYBobo Robert A · Pullman, WABuilt 2001 · S/N 001N33NCRv Air Inc · Fresh Meadows, NYBuilt 2007 · S/N 81882N33PDStairs Karl O II · Livingston, TNS/N 1N33PHPine Creek Adventures Inc · Benton, PABuilt 1959 · S/N 24-1451N33PLMcgraw Dennis S · Oakland, TNBuilt 2005 · S/N 60526N33PZRygiel Jerome A · Saint Cloud, FLBuilt 1975 · S/N 28-7615040N33RQPhilyaw David A · Saint James, MOBuilt 1939 · S/N 3082N33RTMcnamara Thomas Joseph · Santa Rosa, CAS/N 601-65-2171N33RWSpencer Joseph C · Asheboro, NCBuilt 1960 · S/N 23-1948N33SMoose Aviation LLC · Henderson, KYBuilt 1995 · S/N K066N33SPCray Jaeger · Hilton Head, SCS/N 28-366N33SSRegistration Pending · Palmdale, CARegistration pendingBuilt 1966 · S/N 30-1104N33SVAviat Aircraft Inc · Afton, WYBuilt 2025 · S/N 3457N33SYFlight Level 510 LLC · El Dorado Hills, CABuilt 2004 · S/N 40.370N33TEDuncan Charles W III · Houston, TXBuilt 2011 · S/N 3137N33TGPiper LLC · Crystal Lake, ILBuilt 1975 · S/N 28R-7635006N33VLPalmer Thomas W · Boulder City, NVBuilt 1994 · S/N 11043
Back to AD 90-04-06 R1