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.

N6899FLevel Up Aviation LLC · Newton, ALBuilt 1976 · S/N 28-7725081N6899NStearns Lloyd Bernard · Georgetown, TXBuilt 1968 · S/N 680167N6899UMayo Clayton E · Ten Mile, TNBuilt 1963 · S/N 2603N689AW Grotendiek LLC · Portland, ORBuilt 1951 · S/N 22-92N689BTDoell Brad J · Elsie, NEBuilt 1977 · S/N 28-7890132N689ENafsinger Nicholas A · Rosharon, TXS/N 354N689HSTexxon Resources Inc · Winter Park, FLFirst renewal noticeBuilt 1959 · S/N 1169N689LHChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 2881272N689MAN28179 Inc · West Gilgo Beach, NYBuilt 2006 · S/N 506-2006N689NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2014 · S/N 4496375N68ACSchgallis Richard J · Gainesville, VABuilt 1977 · S/N 15280781N68ADMorgan Edward J · Murchison, TXBuilt 2006 · S/N 22838N68AGDelucia Dennis DBA · Franklin, PAExpired dealer, pending cancellationBuilt 1997 · S/N 243404N68AH740 Assoc Inc · Wilmington, DEBuilt 1968 · S/N 30-1685N68BAllen April E · Green Cove Springs, FLBuilt 1976 · S/N AA5A-0182N68BDBuiqui Aerospace Corp · Kissimmee, FLBuilt 1980 · S/N 17273907N68BLPhillipson Justin M · Vacaville, CABuilt 1983 · S/N LYNSKY 01N68BWRegistered aircraftBuilt 1969 · S/N 700007N68CNEichten Steve G · Colleyville, TXBuilt 1969 · S/N 28R-35388N68CSTrojen Properties LLC · Joplin, MOS/N 988N68DBLai LLC · Flowood, MSS/N 722N68DEMazzoni Dennis · Mays Landing, NJBuilt 1974 · S/N 745-74N68DGDellar Randy Roger · Wasilla, AKS/N 1208-95N68DWAero Group I LLC · Woodstock, VABuilt 1977 · S/N 28-7890006N68EEBurtt John B · Pierson, MIBuilt 1975 · S/N 18-7509087N68FSistrunk Donald M · Ragley, LABuilt 1956 · S/N 22-4107N68GJDc Foote & Associates Inc · Camarillo, CAS/N 28-7425210N68GPSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1967 · S/N 301656N68HKPomeroy Andy Lee · Seattle, WABuilt 2004 · S/N 60323N68JCCapps Jon T · Bentonville, ARBuilt 1975 · S/N AA5-0801N68JJRegistration Pending · N Richlnd Hls, TXRegistration pendingBuilt 1966 · S/N 1107N68JXRybarczyk Thomas B · Benton, KSBuilt 1992 · S/N S1-10-59N68JYHowell Jon · Texarkana, ARBuilt 1968 · S/N 28R-30850N68KAAakre Keith E · Granite Falls, MNBuilt 1958 · S/N 7GC-21N68KBKeller Bros Airport Inc · Lebanon, PABuilt 1961 · S/N 24-2467N68KFDelconte Anthony T · Old Hickory, TNBuilt 2012 · S/N S9505-0122N68KTHobein Ted · Wheaton, ILBuilt 1999 · S/N 22584N68LCDriver Matthew · Rio Rancho, NMBuilt 1966 · S/N 670243N68LHGottschall James W · Highland, WIBuilt 1990 · S/N 434N68LKKing Larry E Jr · Wenatchee, WABuilt 1968 · S/N 18-8642N68LRMs Aero Inc · Lakeville, OHBuilt 1966 · S/N 30-1000N68MABig Creek Flyers LLC · Lewes, DEBuilt 2004 · S/N 2277N68MCAlpha Enterprises · Burley, IDBuilt 1981 · S/N 8-0004N68MEPeigneux Brothers Llp · Malta, MTBuilt 1968 · S/N 625N68MHScott Jerry E · Houston, TXS/N 1039N68NDSand Nicholas Patrick · Alta, IABuilt 1992 · S/N 668-92N68PJOdonnell Paul E · Schuylerville, NYBuilt 2019 · S/N BD4C021N68PVAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2007 · S/N 442-07/OTCN68QCobb Lee C · Van Alstyne, TXBuilt 1971 · S/N OHB-1970N68RLeroy Philippe G · Willcox, AZS/N 2114
Back to AD 90-04-06 R1