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.

N8558YFritsch Nathaniel · Ettrick, WIBuilt 1968 · S/N 30-1705N8559CJones Donald T · Barrigada, GUS/N 18-2711N8559EFlynn Mark K · Quinton, VABuilt 1959 · S/N 7HC-8N8559VHolub Mark A · Dallas, TXBuilt 1974 · S/N 307-75N8559ZMoss Aviation LLC · Howell, NJBuilt 1985 · S/N 0472N855AVD & J Training Planes LLC · Logan, UTBuilt 1978 · S/N 44-7995174N855CPVector Air LLC · Erie, COBuilt 1998 · S/N 17280461N855GKUavionix Corp · Bigfork, MTBuilt 2017 · S/N 72581N855MPPerez Mario · Oak View, CABuilt 1978 · S/N AA1C0165N855PCMcalee Dennis E · Defiance, MOBuilt 2008 · S/N 70970N855REBrowne Thomas J · Grass Valley, CABuilt 1986 · S/N MOORS 0001N855TSSteier Tim A · Blue Earth, MNBuilt 2005 · S/N 0001N8560CGuy James L P · Wasilla, AKBuilt 1953 · S/N 18-2713N8560DMachovsky Andrew J · Mesa, AZS/N 22-5794N8560MN8560m LLC · Rehoboth Beach, DES/N 0476N8561VParatus Air Inc · Auburn, INBuilt 1985 · S/N 0484N8562DKrupinski Floyd M · Chugiak, AKFirst renewal noticeBuilt 1957 · S/N 18-6212N8562FWilbur-Ellis Co · Salinas, CABuilt 1966 · S/N 7806N8563CPearson Ronald M · Sutton, AKS/N 18-2712N8563YJohnson Richard · Fort Lauderdale, FLBuilt 1985 · S/N 1110N8564FRmi Air LLC · Ocilla, GABuilt 1976 · S/N 28-7715282N8564NEby Leo V · Clearville, PAS/N 28R-7135112N8564VWarfield Gerald Alan · Saltillo, MSS/N 1049-74N8564YGingers Holdings Inc · Jacksonville, FLBuilt 1968 · S/N 30-1711N8566CGamble Cody M · Palmer, AKBuilt 1958 · S/N 18-6398N8566VBrown Mill Ranch LLC · Lamar, COBuilt 1974 · S/N 140-75N8566YClarke George W III · Sierra Vista, AZBuilt 1968 · S/N 30-1714N8567DBelleau Thomas D · Anchorage, AKBuilt 1959 · S/N 18-6785N8567VDavey Bernard V · Eagle Lake, MNBuilt 1974 · S/N 1071-75N8567YJohnson Randy D · Becket, MAS/N 30-1715N8568CCavanaugh Darrel N · Wasilla, AKBuilt 1953 · S/N 18-2723N8569CRudd Wayne G · Basalt, COBuilt 1954 · S/N 18-2720N8569DRegistration Pending · Willow, AKRegistration pendingBuilt 1958 · S/N 18-6223N8569QSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842404N8569VMachen Paul Stewart · Tallulah, LABuilt 1974 · S/N 795-75N856DASpanaflight LLC · Puyallup, WABuilt 1980 · S/N 15284377N856DBRobinson Scott J · Menifee, CABuilt 2007 · S/N 81440N856GDByrd Benjamin E · Moab, UTBuilt 2000 · S/N 001N856KWrong Brothers LLC · Sedgwick, KSBuilt 1997 · S/N 9608100N856KWMurphy Michael J · Mendota Heights, MNS/N 188N856LSlack Troy Trustee · New Concord, OHBuilt 1930 · S/N 117N856NDHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1989 · S/N 4495001N856PProfessional Training Aircraft LLC · Wilmington, DEBuilt 2018 · S/N 2843944N856RHWijma Alexander Sotiri · Cumming, GABuilt 2009 · S/N 22032N856SBWard James · Chattanooga, TNBuilt 2009 · S/N 71541N8570CMoos Jacob W · Dillingham, AKBuilt 1953 · S/N 18-2722N8570FIxi LLC · West Bloomfield, MIBuilt 1976 · S/N 28-7790258N8570RSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842405N8570VJ K Air Inc · Chaffee, NYFirst renewal noticeBuilt 1974 · S/N 308-75N8571VFlywyo LLC · Kalispell, MTBuilt 1974 · S/N 1072-75
Back to AD 90-04-06 R1