OpenAirDocs.org
AD 90-04-06 R1

Registered aircraft · 68,369

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.

N2377Young Robert L · Oakwood, ILBuilt 1970 · S/N 16408488N2377EBeck Roger M Trustee · Goode, VABuilt 1978 · S/N 17271256N2377LBarnes Matthew · Cost, TXS/N M-217N2377UCardinal Flight Systems LLC · Cary, NCBuilt 1979 · S/N 28-8016021N2378Suridutch Inc · Englewood, FLBuilt 1992 · S/N 2066N23784St Clair Joseph M · Wills Point, TXBuilt 1939 · S/N 7244N2378BEssler Kim L · Garrison, NDBuilt 1978 · S/N 38-79A0029N2378MLacher Louis R Jr · Wasilla, AKBuilt 1946 · S/N 12-1623N2378TKeiffer Taylor H · Atlanta, GABuilt 1971 · S/N 28-7225059N2378UInternational Flight Academy LLC · Ft Worth, TXBuilt 1979 · S/N 28-8016022N2378ZMugleston Tim H · Waldport, ORBuilt 1962 · S/N M-102N23798Jet Air Inc · Iowa City, IABuilt 1998 · S/N 17280603N2379GDesselle Howard J III · Marksville, LAS/N 38-79A0509N2379KEast Bay Inc · Stanton, MNBuilt 1979 · S/N 18-8009054N2379MThies Trevor H · Seattle, WABuilt 1946 · S/N 12-1624N2379PHendrix Kim R · Cheboygan, MIBuilt 1979 · S/N 38-79A0970N2379YThelwell Llansley · Frisco, TXBuilt 1967 · S/N 17700179N237BMarcum William N · Corpus Christi, TXBuilt 2003 · S/N 60070N237CSHorizon Flyers LLC · Kingsford, MIBuilt 1968 · S/N 28-24230N237FYSpace Coast Aircraft Co · Merritt Island, FLBuilt 1989 · S/N 2842015N237HYZeus Flight LLC · Ketchum, IDBuilt 2003 · S/N 2237N237LSSouth Florida Ultralights Inc · Mulberry, FLBuilt 2020 · S/N 21242N237MGGeorgia Aviation Authority · Eastman, GABuilt 2024 · S/N 2881815N237MLN237ml LLC · Glennallen, AKS/N 18-6787N237RDGracely Richard H · Durham, NCBuilt 2023 · S/N 20494N237WTGage Scott M · Anchorage, AKS/N 18 237N237WYClemens Aviation LLC · Wichita, KSBuilt 2015 · S/N 3237N2380Atlantic Rotors LLC · Saint Inigoes, MDBuilt 1992 · S/N 2070N23800Adams Michael S · Huntsville, ALBuilt 1979 · S/N 38-79A1055N23803Direct Fly USA LLC · Searcy, ARBuilt 1939 · S/N 1437N23805Woodworth Mark S · Madison, OHBuilt 1939 · S/N 1439N2380AAircraft Engineering Inc · Eagle Lake, FLBuilt 1998 · S/N 17280617N2380KPiper Aircraft Inc · Vero Beach, FLBuilt 1979 · S/N 38-79A0603N2380MPiggott William H · Madison, CTBuilt 1977 · S/N 28-7890249N2380PWalker Kody Chance · Hobbs, NMBuilt 1955 · S/N 22-2771N2380TRegistered aircraftS/N 28-7225060N23817Guy Claude E · Sand Springs, OKBuilt 1939 · S/N 1451N2381KCarolinas Energy Associates LLC · Hays, NCBuilt 1979 · S/N 38-79A0605N2381MArnold V Charles F · Anchorage, AKS/N 12-1509N2381NHoyt Vance E Jr · Marina, CAS/N 38-79A0817N2381ZLeone Brighter Developments LLC · Carlsbad, CABuilt 2005 · S/N 17281276N23824American Lighthouse Transportation Inc · Dry Ridge, KYBuilt 1977 · S/N M-1999N2382LRadloff Nicholas R · Fort Atkinson, IABuilt 1963 · S/N M-222N2382RTampa Bay Aviation Inc · Clearwater, FLBuilt 1999 · S/N 17280700N2382TGethers Adolph B · Dothan, ALBuilt 1971 · S/N 28-7205031N2382VAnywhere Atp LLC · Mount Juliet, TNBuilt 1982 · S/N 38-82A0061N23830Klosterman Jack L · Cincinnati, OHBuilt 1978 · S/N M-2002N23833Gray Shane C · Interlochen, MIBuilt 1939 · S/N 1469N23836Hofacker Paul E · Brookville, OHS/N 1472N2383FLaminar Aerospace LLC · Waukegan, ILBuilt 1978 · S/N 38-79A0411
Back to AD 90-04-06 R1