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.

N47EZRinell Eric S · San Luis Obispo, CABuilt 2020 · S/N 0002N47FSDahl Duane A · Glasgow, MTS/N 11-102N47GQMccoy Robert M · Barksdale, TXS/N 2196N47HJWhite Billy C · Baker, FLBuilt 1987 · S/N 476N47HSJames David R · Wayne, MIBuilt 1956 · S/N 883N47HYJoseph C Thomas · Lenoir, NCBuilt 2000 · S/N 2054N47JGCorcoran Peter A · Fallbrook, CABuilt 1976 · S/N 47N47JKKerr Jerry T · Mount Vernon, WABuilt 1996 · S/N J1GF-1108N47JLElliott David Robert · San Jose, CABuilt 1996 · S/N 3923N47JPBigger Val J · Las Cruces, NMBuilt 2003 · S/N 1900N47JQJaquish William E · Tunkhannock, PABuilt 2003 · S/N 2109N47LMelugin Michael R · Manteo, NCBuilt 1977 · S/N 0770N47LHPompano Senior Squadron Flying Club Inc · Pompano Beach, FLBuilt 1979 · S/N 28-7990480N47LULetourneau University · Longview, TXBuilt 2017 · S/N 4496416N47MLWitt Jerry D III · Houston, TXBuilt 1956 · S/N 22-3865N47NZFish Dwain E · Silver Springs, NVS/N 1947N47PGRandall Skye Sanjay · Lansdowne, PABuilt 1977 · S/N AA5A0340N47PLGreer Wesley E · Woodstock, GABuilt 2008 · S/N 72157N47RGGossard Philip G · Stonington, MEBuilt 1994 · S/N 3290N47RHWilson Alexander M · Inyokern, CAS/N 177RG0185N47SSandlapper Aviation Of De Inc · Bennington, VTBuilt 1970 · S/N 28R-35769N47SDWampler William C · Canton, TXS/N 108-0989N47STFuhs Nicholas J · Advance, NCS/N 2739N47TDBeene Donald · Westfield, INBuilt 1999 · S/N 60023N47TSStewart Terry · Anchorage, AKBuilt 1977 · S/N 18-7709120N47TWRiley Steven M · Bucyrus, KSBuilt 2026 · S/N 0005611N47VMCox Michael · Casper, WYBuilt 2023 · S/N 634-2023N47WCFly Girls Aviation LLC · Saint Amant, LABuilt 1959 · S/N TD-241N47WLSchettler Patrick J · Garnett, KSBuilt 2001 · S/N MM001N47ZRZira 2x Alw LLC · College Place, WAFirst renewal noticeBuilt 1968 · S/N 28-4974N48007White Andrew Kyle · San Diego, CABuilt 2003 · S/N 5497-01N4800LFlying Aces LLC · Scappoose, ORBuilt 1967 · S/N 28-4139N4800MDunn Bernard P · Carson City, NVBuilt 1980 · S/N 15284484N4800VRegistered aircraftBuilt 1980 · S/N 172RG0382N4800ZGorzynski Dustin B · Great Falls, MTBuilt 1961 · S/N 22-8367N4801GFrederick Aero Development Inc · Murrieta, CAS/N 17273349N4801LWilliams Fire Apparatus Inc · Ashland, ALBuilt 1967 · S/N 28-4140N4801ZButler Delbert C · Caldwell, IDS/N 22-8368N48024Aftcloud Inc · Ontario, CABuilt 1979 · S/N 15283270N4802JSwaz Aviation LLC · Mesa, AZBuilt 1968 · S/N 28R-30603N4802LKrishna Vijay · Appleton, WIBuilt 1967 · S/N 28-4141N4802TSmith Terry G · Kamuela, HIS/N 28R-7235111N4802ZHoffman James R · Bethel, AKBuilt 1962 · S/N 18-7800N4803Molek Jon · Warren, OHS/N 1126N48033Franconi Michael J · Newington, CTBuilt 1979 · S/N 15283271N4803FNorman Howard A · Freeport, ILBuilt 1976 · S/N 28-7715067N4803GAarow Aircraft Leasing LLC · Mcminnville, ORBuilt 1979 · S/N 17273351N4803JWhite Jack D · Orangevale, CABuilt 2012 · S/N S94120077N4803LJc And Co Menswear Inc · Tulsa, OKS/N 28-4142N4803ZBuffalo Flyers LLC · Buffalo, MOBuilt 1961 · S/N 22-8370
Back to AD 90-04-06 R1