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.

N49681Sunwest Aviation Inc · Santa Ynez, CAFirst renewal noticeBuilt 1979 · S/N 15283495N4968JOperation Stinky Weasel LLC · South Lyon, MIBuilt 1968 · S/N 28R-30719N4968LSchoolcraft William F · Middletown, OHBuilt 1967 · S/N 28-4339N4968PDuncan Arnold A · Bozeman, MTBuilt 1981 · S/N 15284863N4968VWilliams Charles S · Pearland, TXBuilt 1941 · S/N 75-8624N4968ZGomm Bruce J · Shawano, WIBuilt 1961 · S/N 22-8572N49696Stoffer Aviation LLC · Marion, INS/N 15283496N4969ECapricorn Equipment Co · Madisonville, KYBuilt 1978 · S/N 17271685N4969GSanford Aircraft LLC · Winter Springs, FLBuilt 1979 · S/N 17273516N4969LLubnau Berdy G · New Braunfels, TXBuilt 1967 · S/N 28-4341N4969ZJohnson James E · Stevensville, MTS/N 22-8577N496DSDelaware State University · Dover, DEBuilt 1993 · S/N 2816105N496ECHatfield James D · Hagerman, IDBuilt 2004 · S/N 1356-2003N496GRegistration Pending · Orlando, FLRegistration pendingBuilt 1966 · S/N 1209N496HMTalon Air Service Inc · Soldotna, AKBuilt 1976 · S/N 17267496N496JMAtha Michael · Dalhart, TXBuilt 2024 · S/N 1974N496KPPhilcox Kenneth J · Milton, DEBuilt 1999 · S/N 020N496LAPiper 3 LLC · Chestnut Ridge, NYBuilt 2022 · S/N 28020074N496LFNewman Brian A · Caldwell, IDBuilt 1944 · S/N 755646N496MAEzboost LLC · Torrance, CABuilt 2005 · S/N 40.496N496MGRippy Gregg P · Glenwood Springs, COBuilt 1992 · S/N 1213N496SPWingsleasing LLC · Wichita, KSBuilt 1998 · S/N 172S8037N496TPVertical Corporation · Kalispell, MTBuilt 1991 · S/N 1646N496URRabins Jaime · Chatham, ILBuilt 2015 · S/N 65-8631N496WWestern Antique Aeroplane & Automobile Museum · Hood River, ORBuilt 1931 · S/N 2023N49700Mcmillan Stewart G · Valparaiso, INS/N 75-1805N4970LAzflyers LLC · Gilbert, AZBuilt 1967 · S/N 28-4344N4970SMapoles Aviation · Pace, FLS/N 28R-35690N49710Peshak Blair Keith · Georgetown, TXS/N 15283498N4971FRegistration Pending · Cottonwood, CARegistration pendingBuilt 1979 · S/N 17273110N4971GSuper Hawk Inc · West Jordan, UTBuilt 1979 · S/N 17273518N4971JCreasy Frank Edward III · Suffolk, VABuilt 1968 · S/N 28R-30722N4971LNathanson David · Los Angeles, CAS/N 28-4345N4971TRegistered aircraftBuilt 1972 · S/N 28-7225295N4971VGorman John Scott · Homosassa, FLBuilt 1980 · S/N 172RG0436N49722Kapeller James A · Wickenburg, AZBuilt 1943 · S/N 5-1438N4972GMcchuck Properties LLC · Pensacola, FLBuilt 1979 · S/N 17273519N4972LRush City Flyers · North Branch, MNBuilt 1967 · S/N 28-4346N4972ZFreeman David B · Liberty, NCBuilt 1961 · S/N 22-8570N4973FBoraam Aviation Inc · Prospect Heights, ILBuilt 1979 · S/N 17273111N4973HFodor Scott M · Barryton, MIBuilt 1948 · S/N 11-850N4973JTroftgruben Gregory G · Buxton, NDS/N 28R-30724N4973LRahjes Luke D · Kensington, KSBuilt 1967 · S/N 28-4347N4973MHuddelston James D · Anchorage, AKBuilt 1948 · S/N 11-461N49740Horizon Aeronautics Inc · Columbia, SCBuilt 1979 · S/N 15283501N4974GPea-Wayman Flight LLC · Daytona Beach, FLBuilt 1979 · S/N 17273521N4974LPotratz Douglas R · Oshkosh, WIBuilt 1967 · S/N 28-4348N4975FFg Aviation LLC · La Jolla, CABuilt 1979 · S/N 17273112N4975GBermuda Dunes Flight Training LLC · Palm Desert, CABuilt 1979 · S/N 17273522N4975JP&N Corp · Marion, IABuilt 1968 · S/N 28R-30727
Back to AD 90-04-06 R1