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.

N61713Miller Melanie L · Spanaway, WABuilt 1975 · S/N 17264750N61718Ortman Bernard R · Bozeman, MTBuilt 1975 · S/N 17264753N6171LGoode Stephen C · Canton, TXBuilt 1970 · S/N AA1-0371N61727Mays Gloria J · College Station, TXBuilt 1975 · S/N 17264755N6172DBlue Spruce Aviation LLC · Fairview Park, OHBuilt 1979 · S/N 17272617N6172LKantor Dimitry · Essex, MDBuilt 1970 · S/N AA1-0372N6173Whirlybirds LLC · Monroe, CTS/N 2253N61733Pan Air Flying Club Inc · Miami, FLBuilt 1975 · S/N 17264760N61737Executive Flight Institute LLC · Murrieta, CABuilt 1975 · S/N 17264763N61738Finn Development LLC · Kaysville, UTBuilt 1975 · S/N 17264764N61739Southern Aero LLC · Homestead, FLS/N 17264765N6173DArs Logistics LLC · Hackettstown, NJBuilt 1957 · S/N 22-4820N6173WDiaz Jose O · Ramey, PRBuilt 1964 · S/N 28-20190N61743Carruth John T · Danvers, MNBuilt 1975 · S/N 17264768N61748Zapata Raymond E · Cabo Rojo, PRBuilt 1975 · S/N 17264772N6174DOtoole Makena · Cordova, AKBuilt 1957 · S/N 22-4821N6174LHanson Alan L · Manchester, MIS/N AA1-0374N6174RLaurel Highlands Aeronautical Academy · Latrobe, PAS/N 172RG0103N61752Lee Robert Eric · Charleston, WVBuilt 1975 · S/N 17264774N61755K E F Enterprises · Plymouth, MABuilt 1975 · S/N 17264777N61759Watkins Joe C · Albany, GABuilt 1975 · S/N 17264780N6175GKimber 123 Holdings LLC · Morgantown, WVBuilt 1979 · S/N 17273574N6175HLafferty Dietrich Ian · Brooklyn, NYBuilt 1979 · S/N 15284138N6175QKingsky Flight Academy LLC · Lakeland, FLS/N 15285184N6175TNewell John D · Cleveland, TXBuilt 1994 · S/N RV-4-2722N6175ZSpot-Air LLC · Burlington, TXBuilt 1959 · S/N 25-208N61760Little Duane V · Puyallup, WABuilt 1975 · S/N 17264781N61761Hawk Aviation Inc · Rush City, MNBuilt 1975 · S/N 17264782N61763Bortoto Da Silva Alexandre · Fort Lauderdale, FLBuilt 1975 · S/N 17264784N61764Wohlgemuth Terry D · Squaw Valley, CABuilt 1994 · S/N 1N61765Dean Mark T · Van Alstyne, TXBuilt 1975 · S/N 17264785N61769Jackson Lynn B · Cocoa Beach, FLBuilt 1975 · S/N 17264787N6176DSawyer Stephen W · Brigham City, UTBuilt 1957 · S/N 22-4823N6176GGaruda Flight Training LLC · Miami, FLBuilt 1979 · S/N 17273575N6176JWertz Joseph S Jr · Shoemakersville, PABuilt 1976 · S/N 28-76-15321N61770Mwbw LLC · Shawano, WIBuilt 1975 · S/N 17264788N61772Henry Donald R · Lake Stevens, WABuilt 1975 · S/N 17264789N61778Cambridge Valley Flying Club Inc · Shushan, NYBuilt 1975 · S/N 17264793N6177NDesmarais Dan · Soldotna, AKBuilt 1993 · S/N 839N61780Delaney Kevin P · Germantown, TNBuilt 1975 · S/N 17264794N61783Copper River Airmotive LLC · Copper Center, AKBuilt 1975 · S/N 17264797N61785Fort Sam Houston Flying Club · San Antonio, TXBuilt 1975 · S/N 17264799N61786Northwest Wings LLC · Hillsboro, ORBuilt 1975 · S/N 17264800N61789Padilla Frank J · Vacaville, CAS/N 17264802N61794Dm Asset Management LLC · Plain City, OHBuilt 1975 · S/N 17264807N61799Flf Aviation LLC · West Columbia, SCBuilt 1975 · S/N 17264810N6179HCriss Enterprises LLC · Titusville, FLBuilt 1979 · S/N 15284139N6179PHarris Robert C · Spring Hill, FLS/N 90849N6179RMcclinton Charles R · Cape Coral, FLBuilt 1979 · S/N 172RG0104N617ARReeves Douglas G · Lewisville, TXBuilt 2002 · S/N 24968
Back to AD 90-04-06 R1