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.

N28810Air & Road Sports Inc · Las Vegas, NVBuilt 1978 · S/N AA5B0834N28815Registered aircraftBuilt 1978 · S/N AA5B0836N28819Sun Samuel K · San Diego, CABuilt 1978 · S/N AA5B0838N2881PChicago Glider Club · Minooka, ILBuilt 1987 · S/N 1011N2881QNeenah Aircraft Leasing LLC · Neenah, WIBuilt 1971 · S/N 17259881N28820Elite Flying Group LLC · Northampton, MABuilt 1987 · S/N 1014N2882CG & M Aircraft Inc · Wheat Ridge, COBuilt 1979 · S/N 44-7995302N2882RPostlewait Logging Co · Port Allegany, PABuilt 1969 · S/N 28R-35317N2882TParis Air Inc · Vero Beach, FLBuilt 1972 · S/N 34-7250180N28831Stewart William G · Thousand Oaks, CABuilt 1978 · S/N AA5B0842N28834Vogel Victor H Trustee · Loveland, OHBuilt 1978 · S/N AA5B0844N28837Hamlin Timothy B · Garden City, KSBuilt 1940 · S/N 1579N28838Giuffre Matthew S · The Villages, FLBuilt 1978 · S/N AA5B0726N28839Turgeon Douglas · Anderson, SCBuilt 1978 · S/N AA5B0846N2883MRegistered aircraftBuilt 1946 · S/N 12-1423N2883TGolembiewski William · Hookstown, PABuilt 1972 · S/N 28-7225265N2883XRamano Raymond C · Napa, CABuilt 1967 · S/N 17700283N2883ZFoster Gary E · Kress, TXBuilt 1959 · S/N 18-7045N28842Turnquest Joad · Sanford, NCBuilt 1979 · S/N 28-7916417N28847Mayeda Ronald K · Foster City, CABuilt 1978 · S/N AA5B0851N28848Voltz John H · Alexandria, LABuilt 1978 · S/N AA5B0852N2884DThree Wing Flight School LLC · Stratford, CTBuilt 1979 · S/N 28-7916504N2884PRocky Creek Jbd Inc · Boca Grande, FLBuilt 1955 · S/N 18-4481N2884TBonner John A · Riverside, CABuilt 1972 · S/N 28-7225266N2884XAngle Of Attack Flying Company LLC · Springfield, MOBuilt 1979 · S/N 28-7916511N2884ZSpurgeon Paul M · Brooksville, MSBuilt 1978 · S/N 1239-78N28852Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2013 · S/N 2843732N28854Air Devices Co LLC · Alpena, MIBuilt 1978 · S/N AA5B0861N28856Thompson Mitchell L · Exton, PABuilt 1978 · S/N AA5B0863N28857Sentell Charles S III · Minden, LABuilt 1978 · S/N AA5B0864N28859Newman Richard Donald · Mercer Island, WABuilt 1978 · S/N AA5B0866N2885DLehigh Valley Flying Club Inc · Lehigh Valley, PABuilt 1979 · S/N 28-7990520N2885FDunkly Daniel L · Chico, CABuilt 1979 · S/N 28-7990521N2885GWisconsin Aviation Inc · Watertown, WIBuilt 1979 · S/N 28-8090001N2885KDierkes Steven P · Henderson, NVBuilt 1979 · S/N 28-7990525N2885PLeprechaun Air Service Inc · Syracuse, KSBuilt 1954 · S/N 18-4482N2885QFisher Global LLC · Conway, ARBuilt 1971 · S/N 17259885N2885RArrow Flight LLC · Springfield, VABuilt 1969 · S/N 28R-35318N2885ZMclaughlin Paul E · Mansfield, OHS/N 374-78N28863Koleszar John R · Lynnfield, MABuilt 1978 · S/N AA5B0870N28864Magnuson Lloyd W · Opelousas, LABuilt 1940 · S/N 1606N28865Maritime Aviation LLC · Kalispell, MTBuilt 1978 · S/N AA5B0871N28866Marcoski Edward T · Downers Grove, ILBuilt 1978 · S/N AA5B0872N28869Registered aircraftBuilt 1978 · S/N AA5B0874N2886KTallman George L Jr · Ocala, FLBuilt 1979 · S/N 28-7990529N2886PBurg Mark S · Powell Butte, ORBuilt 1955 · S/N 18-4483N2886QWright Flyers Club Inc · Huber Heights, OHBuilt 1971 · S/N 17259886N2886TAtkins Joseph Van · Lenoir, NCBuilt 1972 · S/N 28-7225268N28878Alsup Patrick J · League City, TXBuilt 1978 · S/N AA5B0876N28879Cady Eugene Roland · Port Orange, FLBuilt 1978 · S/N AA5B0877
Back to AD 90-04-06 R1