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.

N9226SSpencer Montgomery L · Clinton, SCBuilt 1975 · S/N M-1723N9227JBinns George E · Hackettstown, NJBuilt 1966 · S/N 28-3297N9227MMullis Brent S · Garfield, GABuilt 1966 · S/N 3442N9227WMasterman Robert David · Chugiak, AKS/N 11097CN9228DLavender James R · Gainesville, TXBuilt 1958 · S/N 22-6288N9228LRegistered aircraftBuilt 1993 · S/N 14024CN9228MSteubs Mike H · Portland, ORBuilt 1966 · S/N 1185N9228VDuval James A · Lima, OHBuilt 1969 · S/N 690049N92296Raymes Billy F · Stedman, NCBuilt 1995 · S/N 200007N9229CNoble Land & Cattle Inc · Albion, NEBuilt 1978 · S/N 28-7890391N9229DStevens Mark F · Ocean Springs, MSBuilt 1958 · S/N 22-6289N9229FCooke John W III · Carthage, TXBuilt 1997 · S/N 17280294N9229JUnterschuetz Phillip David · Ladysmith, WIBuilt 1966 · S/N 28-3299N9229MMadsen Jan Eric · Lincoln, NEBuilt 1966 · S/N 1186N9229SRegistered aircraftBuilt 1975 · S/N M-1724N922AKSanderson David C · Fort Davis, TXBuilt 1978 · S/N 15281807N922CTSweptwing Holdings LLC · Houston, TXS/N 1064N922DDHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1989 · S/N 1168N922EAButler Ronald A · Cumming, GAS/N 17263921N922ESSpears Esten W · Ocala, FLBuilt 2010 · S/N 80922N922KDDoughty Robert M · Earlville, ILBuilt 1993 · S/N 0058N922PBillester Stephen E M · Parker, COBuilt 1974 · S/N 271HN922PWWilliams Carlton M · Big Lake, AKBuilt 2025 · S/N 001N922TAAtp Aircraft 4 LLC · Wilmington, DEBuilt 1997 · S/N 17280249N922TJBowar Gary R · Miranda, SDBuilt 2008 · S/N 503-2008N922WSWerth Jill · Canandaigua, NYBuilt 1973 · S/N 947-73N92306High Wingers Inc · Racine, WIBuilt 1973 · S/N 17261557N92307Lowcountry Flight LLC · Johns Island, SCBuilt 1973 · S/N 17261558N9230DTbo Enterprises Inc · Chippewa Falls, WIBuilt 1958 · S/N 22-6290N9230MPernick Kevin · Milford, IABuilt 1966 · S/N 1187N9230SSlominski Marcus A · Chapin, SCBuilt 1976 · S/N M-1791N9230TProctor Richard P · Statesboro, GAS/N 11095CN9230VCloud Surfing Aviation LLC · Costa Mesa, CAS/N 690062N92318Flitepro Inc · Murrieta, CAS/N 17261561N9231JLeetz Tom · Elgin, ILBuilt 1966 · S/N 28-3302N9231VShaffer Lawrence · West Des Moines, IABuilt 1969 · S/N 690050N92324Pea-Wayman Flight LLC · Daytona Beach, FLBuilt 1973 · S/N 17261562N9232BLaird Charles L · Adelanto, CABuilt 1958 · S/N 55032N9232GHarold H Bruner · Pinehurst, IDBuilt 1992 · S/N 19001CN9232JAdirondack Flying Club LLC · Rome, NYBuilt 1966 · S/N 28-3305N9232LLuquette Harley M · Abbeville, LABuilt 1971 · S/N AA1A-0132N9232RRogers Ricky R · Saint Francis, KSS/N 19003CN9232TSannella Joseph J · Missoula, MTS/N 19002CN9232VFerri Lawrence E · Lake Worth, FLBuilt 1969 · S/N 690056N9233LGreen Samuel B · Clifton Park, NYBuilt 1971 · S/N AA1A-0133N9233MSlone Buddie M · Waynesburg, KYBuilt 1966 · S/N 1188N9233VRenner David C Jr · Belleville, ILBuilt 1969 · S/N 690063N9234ACruz Salvador A · Sumter, SCS/N 21001CN9234ELdg LLC · Kalispell, MTBuilt 1992 · S/N 14033CN9234KUnusual Attitudes LLC · Stow, OHBuilt 1976 · S/N 28-7690232
Back to AD 90-04-06 R1