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.

N4714KJld Air LLC · North Hampton, NHBuilt 1976 · S/N R1722016N4714RAlford William J · Erie, MIBuilt 1979 · S/N 172RG0014N4714YSoukup Matthew J · Eagle River, AKS/N 18-8956N4715JClarke Brent H · Neversink, NYS/N 17273666N4715LSmith Bryan E · Mt Juliet, TNBuilt 1967 · S/N 28-4035N4715ZMuehlberg Stephen E · Newcastle, OKBuilt 1961 · S/N 22-8259N4716LLong Steven M · Baton Rouge, LABuilt 1967 · S/N 28-4036N4717AOppegaard Craig E · Saint Louis Park, MNS/N 18-4935N4717BCoastal Flight Inc · Tierra Verde, FLBuilt 1979 · S/N 15283595N4717JBrock Aviation Flight School LLC · Douglasville, GABuilt 1966 · S/N MB-175N47189Xclusive Level Aircraft World LLC · Kissimmee, FLS/N 15283183N4718AQuinby Gary D Trustee · Ardmore, OKBuilt 1979 · S/N A1520880N4718KMayes John · Carson City, NVS/N R1722017N4718LSnt Aviation LLC · Laurel, MSBuilt 1967 · S/N 28-4038N47193Cloud Dancer Aviation Inc · Deland, FLBuilt 1979 · S/N 15283185N4719AAvquest Aviation Services LLC · Montgomery, NYBuilt 1956 · S/N 18-4939N4719FFrederick Joel · Hobe Sound, FLBuilt 1979 · S/N 17273076N4719LMinderman David J · Westlake, OHBuilt 1967 · S/N 28-4039N471AArcher Aircraft LLC · Wilmington, DEBuilt 2013 · S/N 2843743N471ACWard Allen M · Andalusia, ALBuilt 1998 · S/N 410-98N471AKAkima Logistics Services LLC · Usaf Academy, COBuilt 2018 · S/N CC18-0090N471AMWells Alex E · Bend, ORBuilt 2004 · S/N 2271N471ATAirmen Testing & Training Inc · Lantana, FLBuilt 1987 · S/N 0737N471BHRocky Mount LLC · Kalispell, MTBuilt 1960 · S/N 2558N471FJForeman Frank A · Call, TXBuilt 2011 · S/N 72325N471HCHinds Community College · Raymond, MSBuilt 2024 · S/N 28020199N471JROrtiz Rivera Jose E · Bayamon, PRBuilt 1972 · S/N 17260933N471KWheeler M Andrew · Westfield, INBuilt 2002 · S/N 471AN471MHHughes Michael J · Mayville, WIBuilt 2020 · S/N 767N471NPGallant David A · Hartsel, COBuilt 1999 · S/N 22471N471PRRed Arrow Aviation LLC · Santa Teresa, NMBuilt 1973 · S/N 17262016N471SPPine Ventures LLC · Malmo, NEBuilt 1998 · S/N 172S8014N47204Reinhardt Michael J · Tonawanda, NYBuilt 1977 · S/N 1499N4720AP P & J LLC · Gillette, WYBuilt 1956 · S/N 18-4941N4720BAffiliated Air Services Inc · Vincentown, NJBuilt 1979 · S/N 15283596N4720FBennett Ronald W · North Pole, AKBuilt 1963 · S/N 18-7989N4720RHotkeys Holding LLC · Silver Spring, MDBuilt 1979 · S/N 172RG0016N4721BEuro 2000 Inc · Merritt Island, FLBuilt 1979 · S/N 15283597N4721LLee Christopher S Sr · Quinton, VABuilt 1967 · S/N 28-4043N4721RWaterdawg Express LLC · Pocatello, IDBuilt 1979 · S/N 172RG0017N47225Aviation Partners Inc · Carson City, NVBuilt 1977 · S/N 28-7890050N47227N47227 Inc · Hobe Sound, FLBuilt 1977 · S/N 28R-7737158N4722AJoos Devon T · Menlo Park, CABuilt 1956 · S/N 18-4943N4722SStallman Jon · Chico, CABuilt 1996 · S/N 002N4723BEuro 2000 Inc · Merritt Island, FLBuilt 1979 · S/N 15283598N4723PChristiansen Aviation LLC · Wilmington, DEBuilt 1980 · S/N 15284804N4723RSmolkin Alexander S · North Chesterfield, VABuilt 1979 · S/N 172RG0018N4723ZMartin William S · S Coffeyville, OKBuilt 1961 · S/N 22-8268N4724JRegistration Pending · Orlando, FLRegistration pendingS/N MB-184N47253De Wan Madisun Nicole · Tarpon Springs, FLBuilt 1979 · S/N 15283198
Back to AD 90-04-06 R1