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.

N4158YAlliance Aircraft Sales Inc · Pierre, SDBuilt 1994 · S/N 1809103N4158ZSchaetzel Paul Robert · New Meadows, IDBuilt 1965 · S/N 18-8340N41593Flyin LLC · Hyde Park, UTS/N 28-7415286N41594Butler John P · Hazelhurst, WIBuilt 1994 · S/N 1809113N41598Fox Flying Club Inc · Wheaton, ILBuilt 1999 · S/N 2843290N4159AHauser Associates Inc · Coral Gables, FLBuilt 1994 · S/N 1809106N4159DBachman Aviation LLC · Independence, IAS/N 1809110N4159HSponsler Frederic L · Fox River Grove, ILBuilt 1948 · S/N 15-42N4159KRegistered aircraftBuilt 1998 · S/N 22015CN4159MShapnek Lawrence R · Cedar Crest, NMBuilt 1947 · S/N 12-3058N4159PSparks Brian E · Monmouth, ORBuilt 1959 · S/N 23-1644N4159SCrew Marshall D · Spokane, WABuilt 1994 · S/N 1809109N4159XHagglund Carl D · Pendleton, ORS/N 341N4159YBauer Aviation LLC · Reese, MIBuilt 1977 · S/N 23877N415AMUtah State University · Logan, UTBuilt 2005 · S/N 40.517N415BDWhiting Ian W · Coto De Caza, CABuilt 1974 · S/N BH120/246N415CAFly For Fun Aircraft LLC · Baltimore, MDS/N 2843215N415CFAlo Fliteline Lc · Waterloo, IABuilt 1975 · S/N 28-7505118N415GKCentral Clinton County Flying Club Inc · Jersey Shore, PABuilt 1982 · S/N 28-8290151N415GSKirkman Robert Nolan · Pilot Mountain, NCBuilt 2004 · S/N 81406N415HPRichmond George H Jr · Elkhorn, NEBuilt 1963 · S/N 30-181N415JBBrewer Allen E · Madison, MSBuilt 1999 · S/N 1463N415KGSky Safety Inc · San Antonio, TXBuilt 2005 · S/N 40.483N415MEngelien Wendell · Port Orange, FLBuilt 2025 · S/N 24456N415MRKropp Matthew M · North Creek, NYBuilt 2014 · S/N 001N415MSNextgen Flight Academy Inc · Riverside, CABuilt 1978 · S/N 28-7816430N415PABird Acquisition LLC · Phoenix, AZBuilt 2001 · S/N 2843448N415RGalyon Aviation LLC · Sweetwater, TNBuilt 1958 · S/N TD-161N415SGriffing Flying Service Inc · Port Clinton, OHBuilt 1978 · S/N 28-7990041N415WHPaavola Troy E · Kansas City, MOS/N 28R-7435199N41604Schuur Rodney E · Slayton, MNBuilt 1974 · S/N 28-7415290N41606My Flight LLC · Cypress, TXS/N 287415291N41609Worthington John F II · Russiaville, INBuilt 1974 · S/N 28-7405124N4160DThompson Johnny J E · Coppell, TXS/N 512N4160FYatin Servet · Weston, MABuilt 2000 · S/N 2844028N4160JIvy James E · Alba, TXS/N 28-22489N4160POgle Richard W Jr · Joplin, MOS/N 23-1645N41614Cartier Edward J Jr · Columbia, MSS/N 28-7415294N41618Evv Warrior LLC · Evansville, INBuilt 1974 · S/N 28-7415295N41619Charles City Aeronautics Inc · Charles City, IABuilt 1974 · S/N 28-7415296N4161JRegistration Pending · Hardinsburg, KYRegistration pendingBuilt 1966 · S/N 28-22490N4161PRegistered aircraftBuilt 1999 · S/N 2843309N4161ZAri Ben Aviator Inc · Fort Pierce, FLBuilt 1998 · S/N 2843129N41622Stingray LLC · Kalispell, MTBuilt 1974 · S/N 28-7415297N41623Airplanesusa LLC · Schaumburg, ILBuilt 1974 · S/N 28-7405126N4162YGarrels Gregory J · Salcha, AKBuilt 1977 · S/N 242-77N41639Airmotive Service LLC · Brigham City, UTBuilt 1974 · S/N 28-7415299N4163BHarrop Blake N · Willard, UTBuilt 2006 · S/N 884163N4163FHammans Gail A · Hot Springs, ARBuilt 1976 · S/N 28-7725003N4163HPetro Jerry R · Williamsburg, VABuilt 1948 · S/N 15-47
Back to AD 90-04-06 R1