OpenAirDocs.org
AD 81-18-04 R2

Registered aircraft · 81,728

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:81-18-04-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
  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.

N2345LD&S Development LLC · Spring, TXS/N M-177N2345PSpitzer Helicopter LLC · Woodland Hills, CABuilt 1991 · S/N 1991N2345QPrunier Phillip M · Kokomo, INBuilt 1963 · S/N M-416N2345RBlue Wave Air LLC · Huntsville, ALBuilt 1981 · S/N 27-8154019N2345YJackson Shaun K · Tyler, TXBuilt 1967 · S/N 17700145N2345ZRegistered aircraftBuilt 1977 · S/N 17270190N2346MHendrickson Gary A DBA · Gold Beach, ORS/N 12-1609N2346QBurt Marcus D · Pendleton, ORS/N M-425N2346TBailey Benjamin J · Lincolnton, GABuilt 1971 · S/N 28-7225050N2346VGauvreau Paul J · Lafayette Hill, PABuilt 1981 · S/N 38-82A0058N2346ZSoutheast Equipment LLC · Sheridan, WYS/N M-65N2347QBefumo Joesph M · Manchester, CTS/N M-451N2347ZZaitsev Saba A · Brooklyn, NYBuilt 1962 · S/N M-59N23480Pkp Aviation LLC · Alexandria, VABuilt 1999 · S/N 18280412N2348BHuff Michael W · Fair Grove, MOBuilt 1978 · S/N 38-79A0020N2348FBas Part Sales LLC · Greeley, COBuilt 1978 · S/N 38-79A0400N2348JArensmeyer Daniel D · Weybridge, VTBuilt 1963 · S/N M-303N2348MSurgent Richard L · Wall Township, NJBuilt 1947 · S/N 12-1607N2348SGeorgia Forestry Commission · Macon, GABuilt 1999 · S/N 18280411N2348ZHerrick Herbert D · Flint, MIBuilt 1962 · S/N M-60N23490Lg Mcdonald Enterprises Inc · Rose Bud, ARBuilt 1992 · S/N 2223N23497Full Throttle Aviation LLC · Clayton, DEBuilt 2007 · S/N 172S10512N2349LPiper Aircraft Inc · Vero Beach, FLBuilt 1979 · S/N 38-79A0729N2349MMurray Donald L · Two Harbors, MNBuilt 1946 · S/N 12-1494N2349QLedford Russell R III · Swansea, SCBuilt 1963 · S/N M-417N2349RSalser Aviation LLC · Ocala, FLBuilt 1998 · S/N 18280413N2349XNorris James A · Export, PABuilt 1998 · S/N 18280414N2349ZUnderwood Richard R · Armuchee, GABuilt 1962 · S/N M-61N234AJMullins Land Co Inc · Aiken, SCBuilt 1995 · S/N 3246008N234AMMondkar Avinash M · Payson, AZBuilt 2003 · S/N 051N234ARHague Arsh · Orangeburg, NYBuilt 1977 · S/N AA5B0452N234ASRegistered aircraftBuilt 2020 · S/N 70297N234BAJohnson Alan Lee · Pikeville, KYBuilt 2000 · S/N 869-2000N234BGLangeland Thomas Arthur · San Antonio, TXBuilt 1965 · S/N 30-909N234BMHickey John W · Monterey, CABuilt 1985 · S/N 1330N234BPYoung Tim M Trustee · Edmond, OKBuilt 1992 · S/N 24-3283N234BRHolmes Tracy H · Boerne, TXBuilt 2015 · S/N 001N234CSundquist Steven A · Yakima, WABuilt 2006 · S/N 72406N234CPZan Am LLC · Findlay, OHBuilt 2000 · S/N 28-43369N234DGSnyder Patrick M · Cortland, NYBuilt 2000 · S/N 25039CN234DKKellis Dana S · Farmington, UTBuilt 2024 · S/N 74825N234ECCook James C · Waverly, ALBuilt 1984 · S/N 234N234EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2023 · S/N 172S13098N234FFAviato I LLC · Palo Alto, CABuilt 2026 · S/N 172S13574N234GAAllen Dean C II · Green Sea, SCBuilt 1967 · S/N 680036N234GBChristensen Gary B · Mesa, AZBuilt 2017 · S/N 60161N234GMCunningham Hal A · Standard, CABuilt 1976 · S/N 17266438N234HBLentini Christopher · Ardmore, OKBuilt 1992 · S/N 692-92N234HUStevens Matthew S · Penn Yan, NYBuilt 1996 · S/N 1336N234HYMcleran Ralph Charles · Novato, CABuilt 2007 · S/N 2415
Back to AD 81-18-04 R2