OpenAirDocs.org
AD 82-23-03 R1

Registered aircraft · 1,185

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:82-23-03-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:82-23-03-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.

N269TAMadison Ql Partners LLC · Dallas, TXBuilt 2000 · S/N 650-7112N26BDArkansas Bolt Co · Little Rock, ARBuilt 1992 · S/N 062N26FNDodson International Parts Inc · Rantoul, KSBuilt 1975 · S/N 011N26MEJ Jets Inc · Los Angeles, CABuilt 1982 · S/N NA 0315N26TNAj Air LLC · Blackwell, OKS/N 418N270JPLopez Fabio A · Denver, NCS/N 078N271ACTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N 189N275ERContinuum Aviation LLC · Oklahoma City, OKBuilt 2005 · S/N 275N277ALAti Jet Inc · El Paso, TXBuilt 1984 · S/N 104N277MKCasmos LLC · Wilmington, DEBuilt 1980 · S/N 341N277RSMaize & White Aviation LLC · Youngstown, OHBuilt 2004 · S/N 258693N2787Valiair Lc Trustee · Casper, WYBuilt 1984 · S/N 257208N278TTThunderun Aviation Corp · Buffalo, NYBuilt 1995 · S/N 104N27AXN27ax LLC · Tulsa, OKBuilt 2001 · S/N 147N27GAValiair Lc Trustee · Casper, WYS/N 181N27TZSparrow Aircorp Inc · Dover, DEBuilt 1977 · S/N 213N280BDLcg Enterprises LLC · Greenwich, CTBuilt 2003 · S/N 332N282TRed Star Aero Holdings LLC · Lewes, DEBuilt 1974 · S/N 42N285CTCf Aviation Trust LLC Trustee · Wilmington, DEBuilt 1983 · S/N 085N285DHRoyal Air Freight Inc · Waterford, MIBuilt 1982 · S/N 026N288FATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1994 · S/N 148N289AWAir Gato Enterprises Inc · Clearwater, FLBuilt 1987 · S/N 628N28DCMbogo Energy LLC · Boerne, TXBuilt 1994 · S/N 139N28PHYoung Family Aviation LLC · Sugar Grove, ILS/N 194N28TXMidwest Flying Service Dos LLC · Sheldon, IABuilt 1992 · S/N 650-7007N28USN28us LLC · Miami, FLBuilt 1993 · S/N 242N28ZFCore Projects Inc · Fresno, CAS/N NA0458N290CKKalitta Charters LLC · Ypsilanti, MIBuilt 1976 · S/N 090N290GSBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 2038N290MXJbs Aviation LLC · Great Neck, NYS/N 199N291BBattelle Memorial Institute · Columbus, OHBuilt 2001 · S/N 317N292PCLightfoot Holdings LLC · Dover, DEBuilt 1982 · S/N 99N292WALifetime Chimney Supply LLC · Plainview, NYS/N 207N293PWatkins Air LLC · Mountain Brk, ALBuilt 1990 · S/N 049N295CKKalitta Charters LLC · Ypsilanti, MIBuilt 1980 · S/N 295N298CKKalitta Charters LLC · Ypsilanti, MIBuilt 1980 · S/N 298N29BBattelle Memorial Institute · Columbus, OHBuilt 2005 · S/N 343N29LNLucky29 Liquors LLC · Loveland, COS/N 389N2FQTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1986 · S/N 167N2SMMagnus Caro LLC · Alpine, WYBuilt 1991 · S/N 040N3007Empire Airlines Inc · Lebanon, MOBuilt 2000 · S/N 258487N300ANTwin Sixties Holdings LLC · Dallas, TXBuilt 1999 · S/N 025N300TCOrlando Financial Corp · Bear, DEBuilt 1978 · S/N 241N300XL1911 Partners LLC · Rockledge, FLBuilt 1979 · S/N 276N303PCJc Pace Holding Co · Fort Worth, TXBuilt 1999 · S/N 650-7098N303PM303pm LLC · Lakewood, COBuilt 1982 · S/N 103N303XX303 Aviation LLC · North Plains, ORS/N 196N304PCFlorida Avm LLC · Venice, FLBuilt 1986 · S/N 650-0110N305BBBsc Landing LLC · Saint Louis, MOBuilt 1999 · S/N 105N306PAAerotrust Services Corp Trustee · Wilmington, DES/N 650-0053
Back to AD 82-23-03 R1