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.

N3054TVidal Aviation LLC · Gaithersburg, MDBuilt 1979 · S/N 28-7990325N3054ZSandall Brian E · Lake Stevens, WABuilt 1959 · S/N 22-7008N30553Jfe LLC · Flossmoor, ILBuilt 1968 · S/N 17701322N30556Amundson Clyde E · Poplar Grove, ILBuilt 1968 · S/N 17701324N30557Wilson Thomas L · Sheboygan, WIBuilt 1968 · S/N 17701325N3055BSale Reported · Gainesville, FLSale reportedS/N 28-7990137N3055CCrecente Joseph W · Indn Hbr Bch, FLBuilt 2007 · S/N 28025CN3055EFisher Joseph · Canadian, TXS/N 1579N3055PZebroski Andrew John · Seattle, WABuilt 1957 · S/N 23-967N30561Eisele William L · Laporte, INBuilt 1978 · S/N 28-7990096N30565Flowings LLC · Orlando, FLBuilt 1968 · S/N 17701331N30567Sale Reported · West Liberty, KYSale reportedBuilt 1968 · S/N 17701332N3056ARegistered aircraftBuilt 1953 · S/N 25700N3056MGrald Jonathan A · New Hampton, NYS/N 12-1744N3056SMagic Shuttle Bus Air Tours LLC · Traverse City, MIBuilt 1979 · S/N 28R-7918058N3056ZPopson LLC · Peachtree City, GABuilt 1979 · S/N 28-7990412N30570Gallacher Mark A · Salem, UTBuilt 1968 · S/N 17701333N30571Spencer Burton D · Mchenry, ILS/N 17701334N30574Carter Peter M · Elkhorn, WIBuilt 1969 · S/N 17701337N30578Rhodes Michael · Jacksonville, FLBuilt 1969 · S/N 17701339N30579Dry Creek Services LLC · Lodi, OHBuilt 1974 · S/N 17264145N3057FN3057f LLC · Branson, MOBuilt 1978 · S/N 28-7990226N3057MAg Aero Inc · Lenzburg, ILBuilt 1977 · S/N 28-7890293N3057PMcneil Michael D · Caro, MIS/N 23-969N30584New Horizons Aviation LLC · East Helena, MTBuilt 1969 · S/N 17701344N3058MMcguire Patrick · Greenleaf, WIS/N 12-1585N3058TN3058t LLC · Cheyenne, WYBuilt 1979 · S/N 28R-7918062N3058ZLove Glen L · Poplar Grove, ILBuilt 1959 · S/N 22-7013N30592Kussmaul Richard · Clinton, MIBuilt 1994 · S/N 11093CN30597Brewer Aviation LLC · Winslow, ARBuilt 1969 · S/N 17701350N30599Wilson Phillip W Jr · Kailua, HIBuilt 1969 · S/N 17701351N3059BBay De Noc Flying Club Inc · Escanaba, MIBuilt 1978 · S/N 28-7990138N3059FAtwell Charles A · Eldred, NYBuilt 1969 · S/N 28-25760N3059GStulp Annessa C · Lamar, COBuilt 1968 · S/N 37N3059RTimes Arrow LLC · Highland, MDBuilt 1969 · S/N 28R-35620N3059SRatte Clifford H · Gulf Breeze, FLBuilt 1979 · S/N 28R-7918061N305BSAllen Andra L · Gila, NMBuilt 1999 · S/N S1796N305DWPugleasa William Hunter · Lowell, ARBuilt 1982 · S/N 15285502N305KGBelisle Kenneth C · Jacksonville, FLS/N SN038N305MDPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28020255N305NDUniversity Of North Dakota · Grand Forks, NDBuilt 2023 · S/N 2881616N305PTCappe Investment Group LLC · Homestead, FLBuilt 1974 · S/N 17264131N305RSElite Approach LLC · Chesterfield, MOBuilt 2001 · S/N 172S8834N305UMParagon Airplane Leasing Co · Fort Myers, FLBuilt 2022 · S/N 28020051N305XXDs Group LLC · Miami, FLBuilt 1975 · S/N 17265513N30603Registered aircraftBuilt 1969 · S/N 17701353N30608Christiansen Aviation LLC · Wilmington, DEBuilt 2004 · S/N 4496180N3060BPrestige Worldwide Aviation LLC · Downers Grove, ILBuilt 1978 · S/N 28-7990139N3060FEl Paso Aero Inc · El Paso, TXBuilt 1978 · S/N 28-7990227N3060LLang Scott T · Waseca, MNBuilt 1979 · S/N 28-7916251
Back to AD 90-04-06 R1