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.

N55638Nimble Solutions Corp · Anchorage, AKBuilt 1944 · S/N 77-420N5563MJudkovitz Shmuel · Brooklyn, NYBuilt 1967 · S/N 100N5563QFishero John D · Spring, TXBuilt 1965 · S/N 2970N5563UBlair James S · Beltsville, MDBuilt 1970 · S/N 28-26882N5563ZTeterboro School Of Aeronautics Inc · Virginia Beach, VABuilt 1962 · S/N 22-9360N55640Adams Charles G III · Tawas City, MIBuilt 1973 · S/N 28-7305430N55641Gizzy LLC · Fish Creek, WIBuilt 1973 · S/N 28R-7335263N55646Bluto Paul · Branson, MOBuilt 1973 · S/N 28-7325450N55648Pic Aviation Inc · Bloomsburg, PABuilt 1973 · S/N 28-7305434N5564FVazquez Oscar C · Moreno Valley, CABuilt 1968 · S/N 28-24904N5564UGoldinger Matthew L · Ligonier, PABuilt 1969 · S/N 28-26291N55652A Group Inc · Houston, TXBuilt 1973 · S/N 28R-7335266N55656Denovellis Dennis T · Sidney, NEBuilt 1973 · S/N 28-7325453N55659Beiderman Allan R · Melbourne, FLBuilt 1973 · S/N 28-7305439N5565FHenley Brett · Manchester, TNBuilt 1968 · S/N 28-24905N5565PGrant Zachary J · Indianapolis, INBuilt 1958 · S/N 24-629N5565UFiebich Stephan C · Kearney, MOBuilt 1969 · S/N 28-26292N55660Cifuentes Julio · Naples, FLS/N 28R-7335268N55667Stanick Paul J · Whitinsville, MABuilt 1973 · S/N 287305438N5566UKingsbury Janet L · Miramar, FLBuilt 1969 · S/N 28-26293N5566WRegistered aircraftBuilt 1962 · S/N 28-660N5566ZAlex Lawrence P · Loves Park, ILBuilt 1962 · S/N 22-9363N55671Brown Christopher A · Tigard, ORBuilt 1973 · S/N 28-7305440N55673Smith Gordon H · Racine, WIBuilt 1973 · S/N 28-7305442N55675Sykes Kinsley · Palm Coast, FLBuilt 1973 · S/N 28-7305443N55677Arrow II Aviation LLC · Rocky Mount, NCBuilt 1973 · S/N 28R-7335270N55678Murdick Robert A II · Bluemont, VABuilt 1973 · S/N 28R-7335271N5567MAnderson Layne A · Wichita Falls, TXBuilt 1967 · S/N 092N5567QRicol Aviation LLC · Naples, FLBuilt 1965 · S/N 2972N5567W3k Weavers Investment Group LLC · Shelbyville, KYBuilt 1962 · S/N 28-661N55680Madsen Pest Management LLC · Siren, WIBuilt 1973 · S/N 28-7325466N55687Rieber Russell C · Stockton, CABuilt 1973 · S/N 28-7305444N5568PSimon Jack · Spring Hill, TNBuilt 1958 · S/N 24-632N5568QJ & F Aviation Adventure LLC · North Fort Myers, FLS/N 637N5568WRegistration Pending · Lebanon, INRegistration pending, pending cancellationS/N 28-662N55691Brown Alan · Lugoff, SCS/N 28-7305447N55695Straight Arrow Aviation LLC · Aurora, ILBuilt 1973 · S/N 28R-7335273N55696Walla Walla University · College Place, WABuilt 1973 · S/N 28R-7335274N55699Hill Caleb · Indianapolis, INBuilt 1973 · S/N 28R-7335281N5569MWichita Flight Training LLC · Wichita, KSBuilt 1967 · S/N 079N5569QBrian C Elbert · Rochester, NHBuilt 1965 · S/N 2973N5569UJapikse Bert · Pawleys Island, SCBuilt 1970 · S/N 28-26884N5569WBridges Michael D · Clovis, NMBuilt 1962 · S/N 28-663N5569ZLevandowski Joseph · Hamburg, NYBuilt 1962 · S/N 22-9273N556BKd Helicopters Inc · Shingleton, MIBuilt 1986 · S/N S1235N556FLKarg Asset Management LLC · Pocahontas, ARS/N 28-7125395N556JRSemmig Jeffrey C · Oceanside, CABuilt 1987 · S/N 1144N556KRWhitaker Robert M · Richfield, UTBuilt 2004 · S/N 90279N556MKurdzel Mark A · Chattanooga, TNS/N 10150N556MKPickering Gordon D · La Pine, ORBuilt 2001 · S/N 294
Back to AD 90-04-06 R1