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.

N211WKKelley William J · Arroyo Grande, CABuilt 1978 · S/N 176N211WTBetelgeuse Aviation LLC · Houston, TXBuilt 1978 · S/N 177RG1321N211WYHalverson Aviation LLC · Missoula, MTBuilt 2014 · S/N 3212N211XSmith Amy E · Raymond, NHS/N 8N211XZDoty James A · Ocala, FLBuilt 2006 · S/N 82121N2121AGitre Daniel J · Lakeview, MIBuilt 1952 · S/N 22-564N2121QSchardt James A · Garden Valley, CABuilt 1974 · S/N 177RG0521N2121TSiebols Johan · Friendswood, TXS/N AA5B-1031N2121UBurk Timothy R Trustee · Ramona, CABuilt 1989 · S/N BW002N2121WSambell Warren D · Arlington, TXBuilt 1973 · S/N M1493N21228Atp Aircraft 4 LLC · Wilmington, DEBuilt 1978 · S/N 44-7995043N2122AGubler Joseph A · Fairhaven, MABuilt 1952 · S/N 22-563N2122JCharles City Aeronautics Inc · Charles City, IABuilt 1978 · S/N 28-7916199N2122KKnight Paul · Kawkawlin, MIBuilt 2024 · S/N 2024PKN2122LWare Pat · Farwell, TXFirst renewal noticeBuilt 1978 · S/N 28-7990257N2122NOwen Jason Ryan · Fort Irwin, CABuilt 1979 · S/N 28R-7918039N2122RAdventure North Flying Service LLC · Aitkin, MNS/N 28-5464N2122WRegistration Pending · Ubly, MIRegistration pending, pending cancellationS/N M-1495N21237Parker Jeff · Chelsea, ALBuilt 1974 · S/N 17263911N2123AItechnology Design Inc · Gypsum, COBuilt 1978 · S/N 28-7990105N2123BLovell Mark S · Templeton, CABuilt 1949 · S/N 6550N2123KStone Kent H · Franklin, TNBuilt 1979 · S/N 28-7990238N2123MPapadopoulos Dimitris Alexander · Dallas, TXBuilt 1979 · S/N 28R-7918034N2123QMellor James F · Spanish Fork, UTS/N 177RG0523N2123TMy Way Aviation LLC · Weston, FLS/N 28R-7135066N2123WSimmons Aeronautical LLC · Springfield, MOBuilt 1973 · S/N M-1496N21246Eastern Stearman Inc Trustee · Leesburg, VAS/N 17263914N21249Western Kentucky Petroleum Inc · Osage Beach, MOS/N 17263916N2124FHesseltine Robert J · Grand Terrace, CABuilt 1978 · S/N 28-7916173N2124JDomas Jeffrey P · Mankato, MNBuilt 1978 · S/N 28-7916201N2124NLivestock Service Inc · Douglas, AZBuilt 1951 · S/N 18-259N2124QBas Part Sales LLC · Greeley, COBuilt 1974 · S/N 177RG0524N2124WSerra Joseph I · Inverness, FLBuilt 1973 · S/N M-1497N21255Wright Attitudes Inc · Taft, TNBuilt 1938 · S/N 1047N2125MNfh Aviation LLC · Pikeville, KYBuilt 2000 · S/N 17280905N2125QRizzuto Nunzio Stephen · Decatur, ALBuilt 1974 · S/N 177RG0525N2125TBasquit Kenneth · Pittsburgh, PAS/N 28R-7135068N2125WWittmer Daniel J · Tucson, AZBuilt 1973 · S/N M-1499N21262Aysta Nathan P · Hermantown, MNBuilt 1968 · S/N 130N2126JChristie Ian A H · Limon, COS/N HB007N2126QDurable Industrial Finishing Co Inc · Tucker, GABuilt 1974 · S/N 177RG0526N2126WFormanek Carl F · Glen Flora, WIBuilt 1974 · S/N M-1502N2126XCandace A Learned Enterprises Inc · Long Beach, CABuilt 1979 · S/N 44-7995273N21272Eagle Aviation Inc · Tucson, AZBuilt 1974 · S/N 17263920N2127CRowsey Andrew M · Corinth, MSBuilt 1959 · S/N 7GC-50N2127DMetro Aircraft Co · Bloomington, MNBuilt 1978 · S/N 447995131N2127PDerbenwick Gary F · Colorado Springs, COBuilt 1979 · S/N 28-7990291N2127RCohen Blanche F · Aurora, COBuilt 1969 · S/N 28-5465N2127TGeiger Glenn M · Cincinnati, OHBuilt 1971 · S/N 28R-7135070N2128Boone T Daniel · Avon, ILBuilt 1968 · S/N 475
Back to AD 90-04-06 R1