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.

N4896TVosler Dean S · Bay City, MIBuilt 1972 · S/N 28-7225233N4896VSouth Aero LLC · Albuquerque, NMBuilt 1980 · S/N 172RG0411N48972Pickett Matthew A DBA · Gig Harbor, WABuilt 1978 · S/N 15281083N4897ESig Flights LLC · Hickory, NCBuilt 1978 · S/N 17271674N4897FGnl Aviation LLC · Weatherford, OKFirst renewal noticeBuilt 1976 · S/N 28-7790071N4897GWings Over Texas Holdings LLC · Denton, TXBuilt 1979 · S/N 17273444N4898BPrecon Inc · Anaheim, CABuilt 1979 · S/N 15283697N4898FLima-001 LLC · Muscatine, IABuilt 1979 · S/N 17273097N48990Hyldburg Aviation · Plymouth, MABuilt 1977 · S/N 15281090N4899GJf Property Leasing Inc · Port Orchard, WAS/N 17273446N4899LSweat Larry D · Meridian, IDBuilt 1967 · S/N 28-4266N489ACKuza Flyers LLC · Rock Hill, SCBuilt 1999 · S/N 413-98N489ALHehl Adam D · Anchorage, AKBuilt 1956 · S/N 18-4769N489BBBoatman John H Jr · Smyrna, TNS/N JB001N489BCAviation Services Inc · Barre, VTBuilt 1974 · S/N 17264443N489ERMenefee Scott A · Los Banos, CABuilt 1978 · S/N 17272083N489JOrr Matthew W · Kirkland, WAS/N 265N489JEChambless Mardre F II · Panama City, FLBuilt 2004 · S/N 90508N489LARed Baron LLC · Middletown, DES/N 47007TN489PWsi Southwest Inc · Cliff, NMBuilt 1965 · S/N 28-21083N489PFFleming Peter A · Santa Clarita, CABuilt 2014 · S/N 2813N489RSViage LLC · Boston, MABuilt 2004 · S/N 40.379N489RVBoyter Wayne · Winston, ORBuilt 2008 · S/N 21275N489TJUnknown Media LLC · Cape Canaveral, FLS/N 3024N48ARGacey Inc Trustee · Wilmington, DEBuilt 1966 · S/N 30-1328N48BGWhitfill Mark J · Crockett, TXBuilt 1978 · S/N 17271064N48BKKrebs Brian G · Hartland, WIBuilt 2012 · S/N 82136N48BRField Christopher R · Kingston, TNBuilt 2009 · S/N 90951N48CEEssential Aviation Llcregistered · Hickory, KYBuilt 1958 · S/N TD-163N48CLSharp Wade L · Asheville, NCS/N 21184N48DXSomers Andrew · El Paso, TXBuilt 2003 · S/N 386N48EAHillbilly Air LLC · Wilmington, DEBuilt 2010 · S/N 3114N48EBEbgineering Inc · Ocklawaha, FLBuilt 2003 · S/N 70755N48ELRegistration Pending · Livermore, CARegistration pendingBuilt 2004 · S/N 1363N48ERChess Group LLC · Minden, LABuilt 1978 · S/N AA5B0906N48EVRichardson Mark E · Altus, OKBuilt 2007 · S/N 823N48GHYellowstone Aviation Inc · Jackson, WYBuilt 1999 · S/N 2049N48GKAnderson Kirby L · Mcveytown, PABuilt 1980 · S/N 48N48GWMajerle Steven A · Big Lake, AKBuilt 1965 · S/N CS-1N48HAFiack Daniel P · Sun Valley, IDBuilt 1953 · S/N 22-975N48HGJahn Glenn R · Torrance, CABuilt 2005 · S/N 70449N48HUMelair 6 LLC · Easton, MDBuilt 2024 · S/N 3438N48HYStruble Anne D · Springville, UTBuilt 2002 · S/N 2196N48JAJahawk Leasing LLC · Sugar Grove, ILBuilt 1975 · S/N 17265312N48JJTotten James C · Newark, NJBuilt 1979 · S/N GA7-0110N48JKKeahey Britt · Saint Joseph, LABuilt 1972 · S/N 17260693N48JWLee William L · Jonesborough, TNBuilt 1989 · S/N 2N48KBRydberg Lawrence · Albuquerque, NMBuilt 1998 · S/N 26N48KSHolcomb Garry M · Point, TXS/N PTS101N48MBCaddell Charles Thomas · Wadesboro, NCBuilt 2000 · S/N 60059
Back to AD 90-04-06 R1