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.

N8571YSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842406N8572DRubbert Jan D · Upham, NDBuilt 1958 · S/N 18-6228N8572VEast Rick · Muscle Shoals, ALBuilt 1974 · S/N 1073-75N8572ZSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842407N8573COcean Aerial Ads Inc · Ocean City, MDBuilt 1953 · S/N 18-2726N8573JSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842408N8573VSchrack Kevin · Loganton, PABuilt 1974 · S/N 796-75N8573XSale Reported · North Royalton, OHSale reportedBuilt 1981 · S/N 38-81A0095N8574CVan Wagner Aerial Media LLC · Hollywood, FLBuilt 1953 · S/N 18-2728N8574KSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842409N8575VMcintyre Jon D · Fairbanks, AKBuilt 1975 · S/N 142-75N8575WSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842410N8576CReser Byron G · Walla Walla, WABuilt 1953 · S/N 18-2730N8576VJam Three LLC · St George, UTBuilt 1974 · S/N 498-75N8576XSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842411N8576YCenterline Holdings LLC · Belgrade, MTS/N 18-8889N8577Burke Jeremy D · Westminster, COBuilt 1964 · S/N 2737N8577VHoran Spraying LLC · Plainview, TXBuilt 1974 · S/N 309-75N8577YSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842412N8578Ray Christopher Kevin · Wake Forest, NCBuilt 1973 · S/N 915-73N8578CRiver Valley Flyers LLC · West Hartford, CTBuilt 1976 · S/N 28-7690152N8578DCoy Shane A · Nenana, AKBuilt 1958 · S/N 18-6236N8578EDamrow L Bruce · Jay Em, WYBuilt 1959 · S/N 7GC-132N8578VNelson Timothy E · Fairbanks, AKBuilt 1974 · S/N 143-75N8578ZSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842413N8579Ralls Eddie · Evergreen, ALBuilt 1973 · S/N 457-73N8579CSolberg John W · Bismarck, NDBuilt 1953 · S/N 18-2732N8579NWillaero LLC · Union City, TNBuilt 1971 · S/N 28-7105133N8579VWalsh Leo A Jr · Anchorage, AKBuilt 1974 · S/N 797-75N857ACToedtli Bryan S · Vancouver, WAS/N 7AC-2520N857ERAlpha International Aircraft Inc · Lewes, DES/N 15282420N857GArcher Flight LLC · Wilmington, DEBuilt 2018 · S/N 2881068N857JWWarren Joseph A · Milford, DEBuilt 1963 · S/N 2435N857MMVigilante Helicopters LLC · Lewistown, MTBuilt 1982 · S/N 723N857SSjs Aviation Co · Casper, WYBuilt 1981 · S/N 28-8190224N857SCFf22 LLC · Scottsdale, AZBuilt 2024 · S/N 2881741N857SPSoutheastern Oklahoma State University · Durant, OKS/N 172S8115N8580DKedrowski James L · Wasilla, AKBuilt 1958 · S/N 18-6238N8580ESkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842414N8581ASkyborne Airline Academy Inc · Vero Beach, FLBuilt 2024 · S/N 28020159N8581DDutch Air LLC · Kalispell, MTBuilt 1957 · S/N 18-6239N8581JSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842415N8581VObx Airplanes LLC · Manteo, NCBuilt 1975 · S/N 805-75N8582CCurran Aviation Services LLC · Yorba Linda, CABuilt 1976 · S/N 28R-7635166N8582ESkyborne Airline Academy Inc · Vero Beach, FLBuilt 2024 · S/N 28020160N8582JMarchione Laverne R · Diamondville, WYBuilt 1967 · S/N 15066482N8582MSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2016 · S/N 2844160N8582VOcean Aerial Ads Inc · Ocean City, MDBuilt 1975 · S/N 144-75N8583Totorige Carson J · Glennallen, AKBuilt 1973 · S/N 916-73N8583BSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2024 · S/N 28020201
Back to AD 90-04-06 R1