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.

N4144XSkywest Leasing Inc · St George, UTBuilt 1999 · S/N 2843267N41457Aviation Medical Experts LLC · Wilmington, DEBuilt 1974 · S/N 28-7415221N41459Erick Enterprises LLC · Spreckels, CABuilt 1974 · S/N 28-7415222N4145AUniverstiy Of Illinois · Savoy, ILBuilt 1998 · S/N 2843150N4145GUniversity Of Illinois · Savoy, ILBuilt 1998 · S/N 2843151N4145JDyka Samuel M · Flushing, MIBuilt 1966 · S/N 28-22469N4145PBlackhawk Holding Corp · Wilmington, DEBuilt 1959 · S/N 23-1626N4145XUniversity Of Illinois · Savoy, ILBuilt 1998 · S/N 2843152N41468Boyer Daniel W · Carroll, OHBuilt 1974 · S/N 28R-7435188N4146DBird Acquisition LLC · Phoenix, AZBuilt 1998 · S/N 2843153N4146EHarrison Jeffrey L · Fairbanks, AKBuilt 1978 · S/N 18-7809085N4146JJackson Billy B · Los Angeles, CABuilt 1966 · S/N 28-22470N4146MKincaid Adam D · Anchorage, AKBuilt 1947 · S/N 12-3045N4146RUniversity Of Illinois · Savoy, ILBuilt 1998 · S/N 2843160N4146TUniversity Of Illinois · Savoy, ILBuilt 1998 · S/N 2843168N4146XOtt Dean R · Carrollton, OHBuilt 1968 · S/N 247N41472Jeborah Aero LLC · Jefferson City, MOBuilt 1974 · S/N 28-7425245N41474Indian Hills Community College · Ottumwa, IABuilt 1974 · S/N 28-7415229N41477Shepro Scott M · Senoia, GABuilt 1974 · S/N 28-7405107N4147EEnglerth Mark J · Wasilla, AKBuilt 1978 · S/N 18-7809086N4147GStinson Aaron M · Anchorage, AKFirst renewal noticeBuilt 2000 · S/N 28-43364N4147HKoerner Stephen F · Kankakee, ILS/N 15-29N4147KUniversity Of Illinois · Savoy, ILBuilt 1998 · S/N 2843169N4147TChandler Air Service Inc · Chandler, AZBuilt 1999 · S/N 2843272N4147YReisdorf Steven R · Saint Cloud, MNBuilt 1976 · S/N 956-76N4147ZHopper Bruce · Chugiak, AKBuilt 1965 · S/N 18-8225N41482Cannella Ingrid D · Pineville, LABuilt 1974 · S/N 28-7415231N4148DSkywest Leasing Inc · St George, UTBuilt 1998 · S/N 2843170N4148EDoody Michael C · Knoxville, TNBuilt 1978 · S/N 18-7809087N4148HRegistered aircraftBuilt 1978 · S/N 24-0647N4148TChristiansen Aviation LLC · Wilmington, DEBuilt 1999 · S/N 4496027N4148YTailwheel Flying LLC · Rochester, MNBuilt 1976 · S/N 280-76N4148ZWillet Gerald E · Townsend, MTBuilt 1965 · S/N 18-8227N4149Huish Aaron Leo · Mesa, AZBuilt 1969 · S/N 01010N41497Bagley Russell L · Frankston, TXBuilt 1974 · S/N 28-7425249N41498G&M Aircraft Inc · Wheat Ridge, COBuilt 1974 · S/N 28-7415237N4149ABoard Of Trustees · Savoy, ILBuilt 1998 · S/N 2843189N4149CBoard Of Trustees · Savoy, ILBuilt 1998 · S/N 2843190N4149GBoard Of Trustees · Savoy, ILBuilt 1998 · S/N 2843191N4149JElko Aviation Group LLC · Elko, NVBuilt 1966 · S/N 28-22474N4149TCrosswinds Flying Club Inc · Bloomington, ILBuilt 1998 · S/N 2843192N414BCRoche Robert C · Casa Grande, AZBuilt 1965 · S/N 28-21129N414DEdgewater Aviation LLC · Lake Havasu City, AZBuilt 1999 · S/N 460N414DJSuper Tiger LLC · New York, NYBuilt 1979 · S/N AA5B1298N414EBRegistration Pending · Carson City, NVRegistration pending, pending cancellationS/N 128N414JRGunderson Milton J · Mora, MNBuilt 1996 · S/N 1431N414LGElite Fleet LLC · Spofford, NHBuilt 2006 · S/N 817-320-659N414LJRegistered aircraftBuilt 1971 · S/N 102MN414PMKnaub Samuel S · Fairbanks, AKBuilt 2010 · S/N 001N414RMMutzman Richard C Trustee · Dublin, OHBuilt 1979 · S/N AA5B1313
Back to AD 90-04-06 R1