OpenAirDocs.org
AD 90-04-06 R1

Registered aircraft · 68,375

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.

N3211EApm Leasing LLC · Casper, WYBuilt 1978 · S/N 17271470N3211PJudie Bear Air LLC · Bend, ORFirst renewal noticeBuilt 1957 · S/N 23-1152N32123Kell Matthew D · Kodiak, AKBuilt 1974 · S/N 28-7515076N32124Howard John D · Palm Bay, FLBuilt 1974 · S/N 28-7515077N32128David William Christy Trustee · Willis, TXBuilt 1974 · S/N 28-7505028N32129Weaver Arnold G · Sandusky, MIS/N 28R-7535028N3212FMcdonald Ronald W · Olive Branch, MSBuilt 1967 · S/N 670005N3212QBrighters David E Trustee · Baton Rouge, LABuilt 1977 · S/N 28-7790443N3212TRichmond Timothy R · Deland, FLBuilt 1967 · S/N 17700512N3213NRegistered aircraftBuilt 1946 · S/N 22403N3213ZDasher Daryl L · Boring, ORBuilt 1959 · S/N 22-7153N32140Dura Timothy L · Henderson, NVS/N 65084N3214DHill James P · Eagle Point, ORS/N 18-8209025N3214FPicker Larry L · Stanfield, ORBuilt 1967 · S/N 670007N3214TJohnson Hugh S · Rochester, NYBuilt 1967 · S/N 17700514N32151Wilson James E III · Brentwood, CAS/N 28-7505030N32156Fier Michael A Sr · Mundelein, ILBuilt 1974 · S/N 28-7525029N3215FWinick Scott R · Jay, VTBuilt 1967 · S/N 670008N3215TMcgee Debra L · Tuscola, TXBuilt 1967 · S/N 17700515N3215ZCastle Richard E · Callao, MOS/N 22-7155N3216Ropp Dwight F · Pasco, WAS/N 30-796N32160Emmons Thomas M · Millington, MIBuilt 1974 · S/N 28-7525030N32161Helseth Keith A · Kirksville, MOBuilt 1974 · S/N 28-7515082N32165Cole Charles V · Sparta, TNBuilt 1974 · S/N 28-7515084N32169Airleasing LLC · Beverly Hills, CABuilt 1974 · S/N 28-7505031N3216EChrabot Gerard S · Virginia Beach, VABuilt 1978 · S/N 17271471N3216FPerry Edward Glen Trustee · Ozark, ARBuilt 1967 · S/N 670009N3216TWss Aviation Inc · Jerseyville, ILBuilt 1967 · S/N 17700516N32170Kenslow Michael · Denton, TXBuilt 1974 · S/N 28-7505032N32171Chicken Hawk Aviators LLC · Pembroke Pines, FLBuilt 1974 · S/N 28-7505033N32172International Aviation Group LLC · Lake Wales, FLBuilt 1974 · S/N 28R-7535030N32177Ace Aircraft Leasing Inc · Nazareth, PABuilt 1974 · S/N 28-7525031N32178Nebraska Generator Service LLC · Gibbon, NEBuilt 1974 · S/N 28-7525032N3217ZQuality Aviation Inc · Marana, AZFirst renewal noticeBuilt 1959 · S/N 22-7158N32181Weaver James D · Montgomery, INBuilt 1974 · S/N 28-7515088N32189Long Todd A · Maple Plain, MNBuilt 1974 · S/N 28-7515090N3218JKanooth Steven L · Washougal, WABuilt 1966 · S/N 15065918N3218MAthol Aggregate LLC · Athol, IDBuilt 1947 · S/N 12-1881N3218TShepherd Darren · Shepherdsville, KYBuilt 1967 · S/N 17700518N32191Czyszczon Aviation LLC · St Pete Beach, FLS/N 28-7515092N32192White Charles J · Spring Lake, MIBuilt 1974 · S/N 28-7515093N32194Parker Brandt · Hillsboro, WIBuilt 1974 · S/N 28-7505036N32196Overstreet Bradley · Greenville, SCBuilt 1974 · S/N 28R-7535034N32198Garrison Resource Development LLC · Bridgeport, TXBuilt 1974 · S/N 28-7525035N3219FTop Flight Detail LLC · Middlebury, INS/N 670012N3219GWest Mi Shooting Alliance For Excellence Sfty LLC · Marne, MIBuilt 1976 · S/N 18-7709030N3219RSotelo Aviation LLC · Naples, FLBuilt 1969 · S/N 28R-31132N321ALFincher William T · Chandler, AZBuilt 1976 · S/N 17268353N321BCGeorge Nathan V · Dardanelle, ARS/N 370-95N321BDFoskett James Jerome · Pewaukee, WIBuilt 1975 · S/N BH120/292
Back to AD 90-04-06 R1