OpenAirDocs.org
AD 90-04-06 R1

Registered aircraft · 68,369

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.

N15928Bussell Matthew W · Reno, NVBuilt 1973 · S/N 28-7305187N15929Cs Flying Ltd · Grafton, OHBuilt 1972 · S/N 28-7305188N1592ABurbank Kevin L · Boscawen, NHS/N 20-829N1592PFerguson Robert C · Cornelia, GABuilt 1954 · S/N 18-3757N1592RWilliams Brian S · Marietta, GABuilt 1975 · S/N AA5B-0092N1592VGates Kenneth A · Lake Isabella, CABuilt 1974 · S/N 17263686N1592XN2211z LLC · Lantana, FLBuilt 1975 · S/N 28-7515427N15930Rogers Aviation LLC · Florence, SCBuilt 1973 · S/N 28-7305189N15931Smitty 172 LLC · Rockford, MIS/N 28R-7335108N15933Flaps Inc · White Bear Lake, MNBuilt 1973 · S/N 28-7325203N15935Stahl Dennis E · Wood Dale, ILBuilt 1973 · S/N 28-7305190N15936Brown Norman C · Kewanee, ILS/N 28-7305191N1593HKleinert John K · Baldwin, GABuilt 1975 · S/N 177RG0767N1593JRindeikis Bron · Sugar Grove, ILS/N 28-24003N1593RReichenbach Richard R · Frankfort, MIBuilt 1993 · S/N 676N1593VBarrie Woodrow L · Oxford, MIBuilt 1974 · S/N 17263687N1593XVaniscak Greg A · Fort Collins, COBuilt 1975 · S/N 28R-7535345N15943Edgerton Eddie Lee · Midwest City, OKBuilt 1973 · S/N 28-7325208N15944Habit Samuel P · Kokomo, INBuilt 1973 · S/N 28-7305193N15945Newton Flying Club Inc · Collinsville, MSBuilt 1972 · S/N 28-7305194N15946Leading Edge Inc · Cottonwood Heights, UTBuilt 1973 · S/N 28-7305195N1594UFarmer Michael E · Greer, SCBuilt 1976 · S/N 17267176N15955Air Wings Enterprise LLC · Roca, NEBuilt 1973 · S/N 28-7325210N15956Hanson Mark E · Griffin, GABuilt 1973 · S/N 28-7305196N15957Jones John E Jr · Metter, GABuilt 1973 · S/N 28-7305197N1595HSholy Fred · Granada Hills, CAS/N 177RG0769N1595RImpulsion Unlimited Inc · Huddleston, VABuilt 1975 · S/N AA5B-0095N15962Romero Jason Nathanial · Broken Arrow, OKS/N 28-7325213N15966Acosta Aaron · El Paso, TXBuilt 1973 · S/N 28-7325214N15968Culberson Donald J · Orange Park, FLBuilt 1973 · S/N 28-7305200N1596AMinelli Giovanni · Carmel, CABuilt 1951 · S/N 20-835N1596ETeam 172-03 LLC · Warsaw, INS/N 17271060N1596JWard Lawrence G · Mckenzie, ALBuilt 1941 · S/N 28-24007N1596PPassmore Aviation LLC · Claremore, OKS/N 18-3761N1596RTc Aviation Ltd · Fairbanks, AKBuilt 1975 · S/N AA5B-0096N15975Bourgeois David · Westminster, MABuilt 1973 · S/N 28-7305226N15976Lake Life Aviation LLC · Yukon, OKBuilt 1973 · S/N 28-7305203N1597BRehman Furqan · Germantown, MDBuilt 1997 · S/N 2843104N1597HAerobox LLC · Seattle, WABuilt 1975 · S/N 177RG0771N1597JLs Aviation LLC · Searcy, ARS/N 28-24008N1597PStokes Letta J · Chugiak, AKBuilt 1954 · S/N 18-3762N15984Hewitt Jeremy K · West Jordan, UTBuilt 1973 · S/N 28-7325218N1598AEllis Hal R · Colorado Springs, COBuilt 1952 · S/N 20-836N1598JHassard Maitland · Goodyear, AZBuilt 1967 · S/N 28-24009N1598RJam Cat LLC · Orlando, FLBuilt 1975 · S/N AA5B-0098N15994Self Thomas C · Madisonville, TNS/N 28-7325222N15997Stockman Greg · Allenton, MIBuilt 1973 · S/N 28-7305210N1599APetro Harold J · Des Moines, IABuilt 1952 · S/N 20-841N1599RLuka Robert E · Berea, KYBuilt 1967 · S/N 28-3845N1599XDuffys Aircraft Sales & Leasing Inc · Neillsville, WIBuilt 1975 · S/N 28-7505245
Back to AD 90-04-06 R1