OpenAirDocs.org
AD 2007-04-19 R1

Registered aircraft · 108,433

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:2007-04-19-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:2007-04-19-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.

N21234Positive Rate LLC · Kenosha, WIBuilt 1982 · S/N 340A1207N21236Gjedde David C · Morristown, TNBuilt 1972 · S/N 18261506N21237Parker Jeff · Chelsea, ALBuilt 1974 · S/N 17263911N21238Hatfield Derik L · Mesa, AZBuilt 1972 · S/N 18261508N2123AItechnology Design Inc · Gypsum, COBuilt 1978 · S/N 28-7990105N2123EDream Flights LLC · Brewton, ALBuilt 2004 · S/N 18281331N2123GCasten Scot R · Vernonia, ORBuilt 1958 · S/N 51423N2123KStone Kent H · Franklin, TNBuilt 1979 · S/N 28-7990238N2123LPanther Air LLC · Alameda, CABuilt 1976 · S/N E-886N2123MPapadopoulos Dimitris Alexander · Dallas, TXBuilt 1979 · S/N 28R-7918034N2123NKangas Brian Alfred · Houghton, MIBuilt 1955 · S/N 31815N2123RHowell William J · Incline Village, NVS/N 18255323N2123TMy Way Aviation LLC · Weston, FLS/N 28R-7135066N2123WSimmons Aeronautical LLC · Springfield, MOBuilt 1973 · S/N M-1496N2123YPalin Investments 3 LLC · Vancouver, WABuilt 2007 · S/N 18281893N2123ZGauntt Chep R · Pasco, WABuilt 1963 · S/N 18051223N21244Connors Geoffrey M · La Center, WABuilt 1972 · S/N 18261512N21246Eastern Stearman Inc Trustee · Leesburg, VAS/N 17263914N21247Registered aircraftBuilt 1972 · S/N 18261515N21249Western Kentucky Petroleum Inc · Osage Beach, MOS/N 17263916N2124FHesseltine Robert J · Grand Terrace, CABuilt 1978 · S/N 28-7916173N2124GSilicz Alexander Nicholas · Shafter, CAS/N 51424N2124JDomas Jeffrey P · Mankato, MNBuilt 1978 · S/N 28-7916201N2124LMax D Watkins Pc · Tulsa, OKS/N D-9920N2124NLivestock Service Inc · Douglas, AZBuilt 1951 · S/N 18-259N2124RKokjer Kenneth J · Fairbanks, AKBuilt 1964 · S/N 18255324N2124WSerra Joseph I · Inverness, FLBuilt 1973 · S/N M-1497N21251De La Fuente Rene M Trustee · Yorktown, VABuilt 1972 · S/N 18261518N21254High Wing 182 LLC · Lenoir City, TNBuilt 1972 · S/N 18261519N21257Stc Aviation Services LLC · Logan, UTBuilt 1972 · S/N 18261521N2125ACable Thomas G · Rockford, MIBuilt 2003 · S/N 18281230N2125MNfh Aviation LLC · Pikeville, KYBuilt 2000 · S/N 17280905N2125RHogue William B Jr · Simi Valley, CABuilt 1964 · S/N 18255325N2125TBasquit Kenneth · Pittsburgh, PAS/N 28R-7135068N2125VGallagher Stephen · Delray Beach, FLBuilt 1977 · S/N 32R-7780431N2125WWittmer Daniel J · Tucson, AZBuilt 1973 · S/N M-1499N2125ZStone Michael D · Boise, IDBuilt 1963 · S/N 18051225N21260Airborne Athletics Inc · Bloomington, MNBuilt 1973 · S/N 18261523N21262Aysta Nathan P · Hermantown, MNBuilt 1968 · S/N 130N21263Suburban Air Corp · Castro Valley, CABuilt 2003 · S/N 172S9429N21268Aufderhar Kenneth G · Lopez Island, WABuilt 1972 · S/N 18261528N2126FVista Aviation Inc · Pacoima, CABuilt 2007 · S/N 172S10458N2126GSmith Jonathan R · Waxhaw, NCBuilt 1958 · S/N 51426N2126JChristie Ian A H · Limon, COS/N HB007N2126LLuurtsema Jon A · Alto, MIBuilt 1976 · S/N D-9913N2126SGarnet Ridge LLC · Brooksville, FLS/N 29-0133N2126WFormanek Carl F · Glen Flora, WIBuilt 1974 · S/N M-1502N2126XCandace A Learned Enterprises Inc · Long Beach, CABuilt 1979 · S/N 44-7995273N21271Barnett Ryan M · El Reno, OKBuilt 1972 · S/N 18261529N21272Eagle Aviation Inc · Tucson, AZBuilt 1974 · S/N 17263920
Back to AD 2007-04-19 R1