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.

N2383PJkr7 LLC · The Dalles, ORBuilt 1955 · S/N 22-2774N2383WMcclure Miles · Vancouver, WAS/N MB-18N23841Lam Capital Management LLC · Sheridan, WYBuilt 1999 · S/N 17280710N2384JEdwards Isaac J · Glen Ellyn, ILBuilt 1963 · S/N M-342N2384LChristiansen Aviation LLC · Wilmington, DEBuilt 1999 · S/N 17280706N2384MDiedrich Steve · Sandpoint, IDS/N 12-1510N2384PLarsen Steve J · Colton, ORS/N 22-2775N2384QTailwind Ventures LLC · Three Rivers, MIS/N M-464N2384UMoody Bible Institute Of Chicago · Spokane, WABuilt 1999 · S/N 17280708N2384YArea-I Flying Club LLC · Atlanta, GAS/N 17700184N23851Giordano Kim O · Foxboro, MABuilt 1978 · S/N M-2006N23859Fu Jinlin · Olympia, WABuilt 1976 · S/N MB-811N2385ADevries Myles · Cut Bank, MTBuilt 1952 · S/N 22-750N2385KHaynes Vincent L · Maumelle, ARBuilt 1979 · S/N 38-79A0610N2385MLucatorto Jeffrey A · Mc Gaheysville, VABuilt 1946 · S/N 12-1627N2385TSquawk 1200 LLC · Springboro, OHBuilt 1971 · S/N 28-7225064N2385YSpeedboat Photo Helicopter LLC · Rehoboth Beach, DES/N 0538N2385ZStacy Rick A · Arlington, OHBuilt 2016 · S/N 70554N23869Boggs Ricky L · London, OHBuilt 1939 · S/N 1505N2386ENiblack Ward Scott · Tecumseh, MIBuilt 1978 · S/N 17271261N2386MHoeffler James P · Fort Collins, COBuilt 1946 · S/N 12-1628N2386NHoelzle Paul R · Fremont, OHS/N 38-79A0820N2386RLand Air & Sea LLC · Concord, NCBuilt 1970 · S/N 28-5602N2386THub City Aviation Academy LLC · Lubbock, TXBuilt 1971 · S/N 28-7225065N2386VEastern Cincinnati Aviation Inc · Batavia, OHBuilt 1999 · S/N 17280702N2386ZHoffman Kurt T · Savannah, GABuilt 1962 · S/N M-109N23878Beach Jacob A · Ladson, SCBuilt 1939 · S/N 1514N2387BMacken Inc Corp · Saint Paul, MNBuilt 1948 · S/N 3687N2387KClipper Properties LLC · Saratoga, WYBuilt 1979 · S/N 38-79A0833N2387MOlson Catherine R · Two Rivers, AKBuilt 1946 · S/N 12-1630N2387SWittkop Joseph D · Dillingham, AKBuilt 1979 · S/N 18-7909142N2387UChristiansen Aviation LLC · Wilmington, DEBuilt 1999 · S/N 17280721N2388Beliveau Richard A · Carlsbad, CABuilt 1943 · S/N 75-8077N2388BN2388b LLC · Salem, ORBuilt 1978 · S/N 38-79A0031N2388MVotaw Kristina M · Anchorage, AKBuilt 1947 · S/N 12-1631N2388TSlatner John W · Sims, NCBuilt 1978 · S/N 38-78A0787N2388YMay James E · Nashville, GABuilt 1967 · S/N 17700188N2388ZKoehler Brian L · Washington, IAS/N M-94N2389DRowland James E Jr · Pennsville, NJFirst renewal noticeBuilt 1978 · S/N 38-79A0293N2389FDavenport Jimmy J · Hayesville, NCBuilt 1978 · S/N 38-79A0413N2389TForeman O Dean · Springfield, TNBuilt 1978 · S/N 38-78A0789N2389VMoody Bible Institute Of Chicago · Spokane, WABuilt 1999 · S/N 17280729N2389WCherney Cody L · Belleville, KSBuilt 1966 · S/N MB-24N238ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2000 · S/N 4496037N238DMCopeland Gary L · Williamsburg, MIBuilt 1972 · S/N 19-72N238FYSpace Coast Aircraft Inc · Merritt Island, FLBuilt 1989 · S/N 2841175N238GMac-V Aviation Inc · Central Point, ORBuilt 2007 · S/N 196CN238LSMckissock Mark D · Cambridge Springs, PABuilt 2011 · S/N 91019N238MAFogg Phillip G · Aurora, ORBuilt 1998 · S/N 5238N238MGGeorgia Aviation Authority · Eastman, GABuilt 2024 · S/N 2881816
Back to AD 90-04-06 R1