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.

N31LDGustte Phil · North Fort Myers, FLBuilt 1973 · S/N 17262736N31LHUp And Up Aviation LLC · Magnolia, TXBuilt 1977 · S/N 28-7816236N31LLNeidert Melvin E · Ulysses, KSBuilt 1993 · S/N MII 1239N31LYTofte Arthur Shawn · Lewis Center, OHBuilt 2008 · S/N 3RX011N31MAlley Shane C · Jackson, MOS/N 188N31MJN31mj LLC · Naples, FLBuilt 2020 · S/N 18283118N31MSWagon Leasing LLC · Jonesboro, ARBuilt 2018 · S/N 593-2018N31NDSchloesser Raymond E · Poland, INS/N 32-654N31PAUtter Joseph Lynn · Springfield, MOBuilt 1967 · S/N MA-132N31PCFlight World Inc · San Juan, PRBuilt 1958 · S/N 23-1349N31PEPhantom Eagle LLC · Hot Springs, VAFirst renewal noticeBuilt 1996 · S/N 14086CN31PLGorum Michael Wren · Red Lodge, MTBuilt 1998 · S/N 18280095N31PPPlyler Aviation Lp · Sherman, TXBuilt 1969 · S/N PP-1N31RKf Lift LLC · Snyder, TXBuilt 1978 · S/N 32R-7885150N31RBTigre Ecossais Aviation Inc Trustee · Wilmington, DEBuilt 1975 · S/N AA5B-0156N31REManley Brian C · Glen Allen, VABuilt 1966 · S/N 32-530N31RWSpot Air LLC · Burlington, TXBuilt 1977 · S/N 17268693N31SN31s LLC · Wadsworth, OHBuilt 1971 · S/N 28-7205080N31SCObryant Jeffrey A · Fairbanks, AKBuilt 1967 · S/N 79N31SETangent LLC · Phoenix, AZBuilt 2005 · S/N 978-2005N31SGHamilton Enterprises Inc · Reno, NVBuilt 1996 · S/N 377-320-132-18PN31SMWings Over Texas Aviation Inc · Killeen, TXBuilt 1965 · S/N 635N31TBRusso Christopher · Huntsville, TXS/N 483N31TDLewis Timothy H · Bristow, VABuilt 2010 · S/N 40059N31TGNaiman Nicholas A · Ramona, CABuilt 1995 · S/N TJ2-8-38GN31THNet Air Co · Monroe, MIBuilt 1979 · S/N AA5B1142N31TJAdams Ian B · Laramie, WYBuilt 2002 · S/N 60414N31TLT M L Aircraft Inc · Narrowsburg, NYS/N 28R-7235314N31TVCornea Kevin Troy · Palm City, FLBuilt 1979 · S/N 27-7954054N31UERemc Leasing LLC · Bismarck, NDBuilt 2020 · S/N 3349N31UPGuardian Aero LLC · Flora, ILBuilt 2013 · S/N 2294N31VCVelocity Cruisers LLC · Mabank, TXBuilt 2001 · S/N 3RX015N31VGTita Enterprises LLC · Apex, NCBuilt 2004 · S/N 3551N31VHAmy Inc · Wilmington, DEBuilt 2005 · S/N 3966N31VSJenny Timothy J · Remsen, NYBuilt 1999 · S/N 1273-99N31VTSnediker Daniel G · Pittsburgh, PABuilt 1966 · S/N 28-3208N31VUJav Enterprises LLC · Broomfield, COBuilt 2018 · S/N 2844179N31VXGordon Charles M Trustee · Haymarket, VABuilt 2018 · S/N 00182N31WABeausoleil Robert N · Phoenix, AZBuilt 1977 · S/N 2N31WBBaker James P · Brighton, COBuilt 1995 · S/N 22470N31WFTaylor Peter L · Beaumont, TXBuilt 1999 · S/N 1461N31WGFleischman James H · Remus, MIBuilt 1990 · S/N 1951N31WKKing Wesley A · Los Angeles, CABuilt 1995 · S/N 1060N31WM3 Point Aviation LLC · Claremont, NHBuilt 2018 · S/N CC19-0027N31WTThomas Norman W · Forest, VABuilt 1980 · S/N 172RG0291N31WYBellamy Mark A · Freeville, NYBuilt 2010 · S/N 3108N31XEverson Dustin J · Providence, RIBuilt 1992 · S/N 671-92N31YBritton Stephen D · Delhi, LABuilt 1957 · S/N TD-41N31YFCharliefoxtrot LLC · Farmington, MOBuilt 2015 · S/N 1158-2015N31ZRRusso R Michael · Pipersville, PABuilt 2004 · S/N 23093
Back to AD 81-18-04 R2