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.

N88477Holland William T III · Midway, ARBuilt 1974 · S/N 136-75N8847CBlumenberg Donald D · Fulton, SDBuilt 1953 · S/N 22-1459N8847FNeitzer Robert W · Milwaukee, WIBuilt 1976 · S/N 28-7725126N8847JFlw LLC · Sandpoint, IDS/N 28-2805N8847MTravel Air LLC · Chico, CABuilt 1964 · S/N TD-575N8847NMcdougal Thomas K · Woodward, OKBuilt 1969 · S/N 28-25699N8848CLeppert James J Trustee · Dickey, NDBuilt 1953 · S/N 22-1464N8848JMegaw George C · Fort Lauderdale, FLBuilt 1965 · S/N 28-2806N8848NPro Tech Aviation LLC · Corona, CABuilt 1969 · S/N 28-25700N8848YBrunot Frank A · Spring Hill, FLBuilt 1969 · S/N 30-1907N88497Airspace Aerial Media LLC · Saint Louis, MOBuilt 1946 · S/N 16121N8849CFitts David A · Salem, ORBuilt 1953 · S/N 22-1463N8849JBailey Aviation Company LLC · Little Rock, ARBuilt 1965 · S/N 28-2807N8849NCafran Lloyd V · Youngsville, NCBuilt 1969 · S/N 28-25701N884ATDot Aviation LLC · Wilmington, DEBuilt 2012 · S/N 4496321N884CAColeman Aero Club · Apo AeBuilt 1978 · S/N 17271876N884DJohnson David L · Blaine, MNBuilt 2010 · S/N 80653N884DCTanner Greg L · Bend, ORBuilt 1961 · S/N 24-2434N884EFChudy Zbigniew P · Southington, CTBuilt 1999 · S/N 884N884FTFlorida Institute Of Technology · Melbourne, FLBuilt 2008 · S/N 4496250N884JSCrane John R · Niceville, FLBuilt 1977 · S/N 340-77N884MWWarfel Michael G · La Verne, CABuilt 2009 · S/N 81525N884PSSpainhower Paul Allex · Taylorsville, UTS/N 2318N884RVDannebrock Paul W · Lockport, NYBuilt 2012 · S/N 90884N884SADamico Frank J · Pittsburgh, PABuilt 2003 · S/N 0037N884WGVandermay Brandon · Winnemucca, NVBuilt 1994 · S/N 94-0001N8850NGregs Airplane Rental LLC · Eloy, AZBuilt 1969 · S/N 28-25702N8851JMoore Jeffrey A · Lawrenceburg, TNBuilt 1965 · S/N 28-2815N8851NBloodworth Nathan B · Hendersonville, TNS/N 28-25703N8852CWobken Mark E · Orange, CABuilt 1976 · S/N 28R-7635184N8852LFederman Cecilia · Beaumont, CABuilt 1974 · S/N AA1B-0452N8852YWikle Luther M · Laceys Spring, ALBuilt 1969 · S/N 39-7N8853DSlaughter Don Wayne · Farmville, NCBuilt 1958 · S/N 22-6024N8853JN8853j LLC · Oak Park, ILBuilt 1965 · S/N 28-2817N8854CMid Continent Aircraft Corp · Hayti, MOBuilt 1953 · S/N 18-2900N8854DKidd Clifford L Jr · Monahans, TXBuilt 1958 · S/N 22-6025N8854LPfs Air Inc · Yellville, ARBuilt 1974 · S/N AA5-0654N8854YSeeds John S Jr Trustee · Tequesta, FLBuilt 1970 · S/N 39-9N88553Riggin Flight Service Inc · Madison, SDBuilt 1946 · S/N 16178N8855NIndy Distributors Inc · Noblesville, INBuilt 1969 · S/N 28-25709N8856CBritton Mark W · Wasilla, AKBuilt 1953 · S/N 18-2913N8856FRotorcraft Unlimited LLC · Brooksville, FLS/N 43-0194N8856JFifty Six Juliet LLC · West Lafayette, INS/N 28-2820N8856LRuales Edison R · Miami, FLFirst renewal noticeBuilt 1974 · S/N AA5-0656N8856NGrant Shane J · Cape Coral, FLBuilt 1969 · S/N 28-25711N8857Aviation Management Systems LLC · Fallbrook, CABuilt 1973 · S/N 254-73N8857CValkenburg Toby · Anchorage, AKBuilt 1953 · S/N 18-2914N8857DHollan William E Jr · Winston Salem, NCBuilt 1958 · S/N 22-6028N8857JNguyen Tu K · Costa Mesa, CABuilt 1965 · S/N 28-2822N8857MDunn Brady · Gilmer, TXS/N M-597
Back to AD 90-04-06 R1