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.

N4831TPower Flow Systems Inc · Daytona Beach, FLBuilt 1972 · S/N 28R-7235120N4832ESenn David L · Oak Ridge, TNBuilt 1959 · S/N 7GC-40N48333Central Texas College · Killeen, TXBuilt 1979 · S/N 15283324N4833LAdbm LLC · Oldsmar, FLBuilt 1967 · S/N 28-4176N4833TDodson International Parts Inc · Rantoul, KSBuilt 1972 · S/N 34-7250155N48340Candace A Larned Enterprises Inc · Long Beach, CABuilt 1979 · S/N 15283326N4834ANicoletti Will · Eagle River, WIBuilt 1956 · S/N 22-3987N4834ESweeney Michael J · Seattle, WABuilt 1978 · S/N 17271670N4834LBell Hubert D · Lewiston, IDBuilt 1967 · S/N 28-4178N4834ZRoesner David A · Salina, KSBuilt 1961 · S/N 22-8408N48353Clifton Joshua M · Marion, INS/N 18362N4835GFiedler Aviation LLC · Suffolk, VABuilt 1979 · S/N 17273383N4835LSims Kyle Z · Locust Grove, GAS/N 28-4179N4835TPero Thomas E · Richland, MIBuilt 1972 · S/N 28-7225218N48361Love Roger F · East Grand Forks, MNBuilt 1992 · S/N 2527N48365Ching Robert · Elsie, MIBuilt 1976 · S/N 1N4836ASales Joe Haney · Seminole, TXS/N 22-3989N4836GEvolo Aviation LLC · Worthington, OHBuilt 1979 · S/N 17273384N4836LPeterson Wayne · Dexter, MNBuilt 1967 · S/N 28-4180N4836ZDewolfe III Everett C · Cumby, TXBuilt 1961 · S/N 22-8410N4837FWesellairplanes Com Inc · Wilmington, DEBuilt 1976 · S/N 28-7715071N4837LNavarro Ricky L · Riverview, FLBuilt 1967 · S/N 28-4181N4838Fajardo Mark A · Longmont, COBuilt 1975 · S/N KB-1N4838BAerolina Inc · Hendersonville, NCBuilt 1979 · S/N 15283665N4838FThomason Booker T Jr · Chicago, ILBuilt 1976 · S/N 28-7715072N4838LSandstrom David E · Anchorage, AKBuilt 1967 · S/N 28-4182N4839GPaw Lifter Aero LLC · Madison, INBuilt 1979 · S/N 17273386N4839LStandard David W · Toccoa, GABuilt 1967 · S/N 28-4183N4839WPiscoya Thomas G · Anchorage, AKBuilt 1989 · S/N 1809012N4839ZMacias-Flores Guadalupe · Garden City, KSBuilt 1961 · S/N 22-8413N483ACTessos Air Service Inc · Wilmington, DEBuilt 1999 · S/N 1282-99N483EAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 1979 · S/N 17273688N483FLOliver Zachary J · Seligman, AZBuilt 1971 · S/N 28-7125291N483RVCoverstone Timothy L · Bellemont, AZBuilt 2004 · S/N 70175N483SPScandinavian Aviation Academy Inc · El Cajon, CABuilt 1998 · S/N 172S8029N483YClassic Air Inc · Paso Robles, CABuilt 1931 · S/N 4297N48400Vector-USA LLC · Olive Branch, MSBuilt 1979 · S/N 15283332N4840LIrons Eric P · Enoch, UTBuilt 1967 · S/N 28-4186N48410Azar Suzanne S · El Paso, TXS/N 15280907N4841DDoorglobe Inc · San Francisco, CABuilt 1979 · S/N 17272371N4841FVidhun Raghuraman R · Southbury, CTBuilt 1976 · S/N 28-7790067N4841LPapa India Echo Inc · Chambersburg, PABuilt 1967 · S/N 28-4187N4842AHill Steven Douglas · Stoneville, NCBuilt 1956 · S/N 22-3995N4842THampsten Jacob Clay · Mesquite, NVS/N 28-7225222N4843Burke Timothy E · Temple, TXS/N RWW-1N4843ANous Air LLC · Yukon, OKBuilt 1956 · S/N 22-3996N4843BMaddox Emily Brown · Rosharon, TXBuilt 1979 · S/N 15283668N4843EMoody Jerry W · Olympia, WABuilt 1959 · S/N 7GC-43N4843THuizenga Jamie L · Pierre, SDBuilt 1972 · S/N 28-7205205N4843ZLeno Stuart J · San Antonio, TXBuilt 1997 · S/N 001
Back to AD 90-04-06 R1