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.

N2130RAscend Aviation LLC · Ira, MIBuilt 1969 · S/N 28-5466N2130TWasson Ronald L · Colleyville, TXBuilt 1971 · S/N 28R-7135073N2130WUnusual Attitudes Flying Club Inc · Mount Vernon, MOBuilt 1974 · S/N M-1505N21318Raw Racing Inc · Puyallup, WABuilt 1978 · S/N 44-7995046N2131ESchuman William C II · Poplar Grove, ILBuilt 1997 · S/N 24-3401N2131JAllen Harvey · Elfrida, AZBuilt 1978 · S/N 28-7990215N2131QImhoff Donald W · Baton Rouge, LABuilt 1974 · S/N 177RG0531N2131TMullin Thomas F III · Birmingham, ALBuilt 1971 · S/N 28R-7135111N2131WRussek Rick · Cave Creek, AZBuilt 1974 · S/N M-1506N21320Diehl Rodney L Trustee · San Jose, CABuilt 1974 · S/N 17263929N21321Bell Robert A · Las Vegas, NVBuilt 1974 · S/N 17263930N21323A2t Guys Aviation LLC · Williamston, MIBuilt 1978 · S/N 28-7916033N21329Propeller Enterprises LLC · Gilbert, AZBuilt 1974 · S/N 17263931N2132JHolley William M · Rock Port, MOBuilt 1978 · S/N 28-7990216N2132QHawk Aviation Inc · Chesapeake Beach, MDBuilt 1974 · S/N 177RG0532N2132TMatejcek Lina M · Owatonna, MNBuilt 1971 · S/N 28-7125448N2133JHoosier Aviation LLC · Terre Haute, INBuilt 1978 · S/N 28-7990217N21347Kessler Frank J Jr · Gallatin, TNBuilt 1974 · S/N 17263933N2134DRich Lucas Aircraft Sales LLC · Lincoln Park, NJBuilt 1978 · S/N 28-7916144N2134ERice Larry Anthony Trustee · Yucaipa, CABuilt 1978 · S/N 28-7990180N2134JMcmahan Michael Anthony · Dunwoody, GABuilt 1978 · S/N 28-7990218N2134QLuft Aviation Inc · Wilmington, DEBuilt 1974 · S/N 177RG0534N2134RVanek Peter · Sedona, AZBuilt 1969 · S/N 28-5467N2134TBartow Municipal Airport Development Authority · Bartow, FLBuilt 1971 · S/N 28R7135142N2134WJustison David L · Hillsboro, ILBuilt 1974 · S/N M-1508N21351Midwest Flying Service LLC · Wilmington, DEBuilt 1974 · S/N 17263934N2135BMiloud Chadd K · Fort Worth, TXBuilt 1978 · S/N 28-7916110N2135FMark Alan Bennett · Trinidad, COS/N 28-7990188N2135TPeter Prince Aviation Center LLC · Milton, FLBuilt 1971 · S/N 28R-7135139N21360Weede Roger H · Dubois, WYS/N 17263935N2136JHanus John E · North Kingstown, RIBuilt 1978 · S/N 28-7990219N2136MWashington Israel · Cincinnati, OHBuilt 1977 · S/N 28-7816253N2136QStoneman Excav Co Inc · Ashland, VABuilt 1974 · S/N 177RG0536N2136YW Tech Consulting Inc · Wilmington, DEBuilt 1979 · S/N 28-7916368N2136ZPorta Frank T · Charleston, WVBuilt 1979 · S/N 28R-7918111N21374Stratus Aviation LLC DBA · Vacaville, CABuilt 1974 · S/N 17263938N2137JAdverse Yaw LLC · Milford, CTBuilt 1978 · S/N 28-7916205N2137QInternational Air Services Inc Trustee · Carson City, NVBuilt 1974 · S/N 177RG0537N2137TWatson Jay C · Midland, TXBuilt 1971 · S/N 28-7105160N21389Registration Pending · Waldo, WIRegistration pendingBuilt 1974 · S/N 17263942N2138AKingdom Air Corp · Sutton, AKBuilt 1952 · S/N 18-1859N2138PRedwood Barry Lindon · Forest, VABuilt 1956 · S/N 23-729N2138RWisdom Victor · Sterling, COBuilt 1965 · S/N 646N2139AAero Seat Inc · Sterling, COBuilt 1952 · S/N 18-1861N2139JHotung Lisa M · Amherst, NYBuilt 1978 · S/N 28-7990220N2139TFlight School Of Gwinnett Inc · Lawrenceville, GABuilt 1971 · S/N 28R-7135145N2139WRegistration Pending · Lake Worth, FLRegistration pendingBuilt 1974 · S/N M-1509N213AMNorton Cole R · Marion, IAS/N 559-73N213AZHardcastle Kenny W · Caulfield, MOBuilt 2018 · S/N 90277N213BPJim Nichols Air Service LLC · Fincastle, VABuilt 1986 · S/N 28-8690056
Back to AD 90-04-06 R1