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.

N4328HCalabretta Charles J · Hanford, CABuilt 1978 · S/N 24-0708N4328JWeldon Thomas · Marysville, OHBuilt 1967 · S/N 28-22703N4328MMisch Gordon L · Toledo, WABuilt 1947 · S/N 12-3262N4328NTalker Albert · Stroudsburg, PABuilt 1983 · S/N 28-8416020N4328QBetzner John C · Medway, MABuilt 1971 · S/N 17260228N4328TWhite Mickey S · Hyrum, UTBuilt 1970 · S/N 28-26927N4328XWhitehair Donald N · Stevensville, MTBuilt 1946 · S/N 12144N4328ZWilmarth Rebecca C · Red Devil, AKBuilt 1968 · S/N 18-8646N43291Etheredge Mark · Pell City, ALBuilt 1974 · S/N 28-7415448N4329MByrne Matthew A · West Allis, WIBuilt 1983 · S/N 28-8490021N4329PDunn Danvil L · East Meadow, NYBuilt 1983 · S/N 28-8490022N4329QElfers Brian K · Colfax, WAFirst renewal noticeBuilt 1971 · S/N 17260229N4329XS&S Aircraft Inc · Bennington, VTBuilt 1975 · S/N 28R-7635011N4329ZWalters Leif C · Wasilla, AKBuilt 1968 · S/N 18-8644N432AEArnold Neil · Caro, MIBuilt 1968 · S/N 690019N432APSky Bear LLC · Marfa, TXBuilt 2024 · S/N 3432N432BQBrowning Aviation LLC · Deputy, INS/N Q-002N432CMFuller Carl C · Fairplay, MDS/N 25105N432DGBiddle Dave S · Cave Creek, AZBuilt 2001 · S/N 60210N432ERUnicorn Wings LLC · Cary, ILBuilt 1998 · S/N 17280652N432HPFuehrer Wyatt R · Coatesville, INBuilt 1977 · S/N 28-7790547N432MBJenks Jesse Basil · Cambria, CABuilt 2011 · S/N 001N432MEEdwards Michael S · Sacramento, CAS/N 18-7609131N432MJ43rd Aviation Flying Club Inc · Wethersfield, CTBuilt 1983 · S/N 241413N432PWSimple Aviation LLC · Suwanee, GABuilt 2014 · S/N 92051N432RVShort Thaddeaus Allen · Conroe, TXBuilt 2006 · S/N 60269N432TTBeam John A III · Old Hickory, TNBuilt 2000 · S/N 21089N433Precision Air Inc · Manning, SCBuilt 1979 · S/N AA5B1189N4330DHildebrand David S · Albuquerque, NMBuilt 1983 · S/N 28-8490026N4330EDooley Jon S · Greensburg, INS/N 38-78A0555N4330HKoper James F · Decatur, TNBuilt 1948 · S/N 15-113N4330MCarson Brian P · Battle Creek, MIBuilt 1947 · S/N 12-3269N4330QSouthwest Aviation Specialties LLC · Tulsa, OKBuilt 1971 · S/N 17260230N4330TBc 180 LLC · Chouteau, OKBuilt 1971 · S/N 28-7205142N4330ZOcean Aerial Ads Inc · Ocean City, MDBuilt 1968 · S/N 18-8650N43311Myers James · Coolidge, AZBuilt 1974 · S/N 28-7425355N43314Gardners Guns & Mfg LLC · Elk City, OKBuilt 1984 · S/N 28-8490029N43316Double M Aviation LLC · Lakeland, FLBuilt 1974 · S/N 28-7415468N4331MNieves Osvaldo Colon · San Juan, PRS/N 28-8416028N4331PWilson Cecil · Lithonia, GABuilt 1983 · S/N 28-8416029N4331QLewis Brandon · Columbiaville, MIBuilt 1971 · S/N 17260231N4331RConsolidated Aviation Services LLC · Seymour, TNBuilt 1974 · S/N 17263084N4331XS E D Air LLC · Kimball, SDBuilt 1975 · S/N 28-7625013N43321Alexander Terry · Stamps, ARFirst renewal noticeBuilt 1974 · S/N 28-7425357N43325Air Ventures Flying School LLC · Smithfield, RIBuilt 1974 · S/N 28-7425358N43326Draco Flight School DBA · Chino, CABuilt 1974 · S/N 28-7415471N4332AButterfield Robert S · Shelbyville, INBuilt 1956 · S/N 22-3687N4332GEdmundson George · Hood River, ORBuilt 1971 · S/N 042N4332LRubman Tracy L · Shelburne, VTBuilt 1983 · S/N 28-8416031N4332NThree Wing Flight School LLC · Stratford, CTBuilt 1983 · S/N 28-8416034
Back to AD 90-04-06 R1