OpenAirDocs.org
AD 81-18-04 R2

Registered aircraft · 81,733

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.

N44LYPuls Kurt V · Valparaiso, INS/N 82777N44MHDrewry James D · Dayton, TXBuilt 1979 · S/N 13308N44MNBaker Larry M · Greenville, TXBuilt 1977 · S/N 212236N44NFPeak Aviation LLC · Ashland, ORBuilt 2012 · S/N 3151N44NPInternational Air Services Inc Trustee · Carson City, NVBuilt 2000 · S/N 14679N44PDBurril Leslie A · Cleveland, GAS/N 1N44PFVaayu Aviation LLC · Newark, CABuilt 1970 · S/N 28-26800N44PGSimon Jevon D · Buckley, WABuilt 1999 · S/N 2522-001N44PHHatch Fletcher A III · Vero Beach, FLBuilt 2002 · S/N 0002N44PJSchaufenbuel Todd W · Imperial, NEBuilt 1992 · S/N 1209N44PMPhipps Johnny · Salem, ORBuilt 1952 · S/N 22-726N44PPKnr Inc · Evanston, WYBuilt 1955 · S/N 22-2576N44PWWeber Peter III Trustee · Loudon, TNBuilt 1979 · S/N 28-8090147N44PXMartinez Victor J · Sylmar, CAS/N JNC-1N44PYSegler Angela U · Marco Island, FLBuilt 2000 · S/N 172S8543N44QGraf Erwin · Clayton, NCBuilt 1974 · S/N 446N44RRRichardson Robert L · Rch Palos Vrd, CABuilt 1985 · S/N R-1N44RTWinkelman Dan · Bethel, AKBuilt 1971 · S/N 18-8927N44SDKandle Douglas A · Boise, IDBuilt 2015 · S/N TCQ1007068N44SJHarpreet Sandhu · Livermore, CABuilt 1977 · S/N 0752N44SKCm3 LLC · North Las Vegas, NVBuilt 2004 · S/N 10534N44SMHinds Community College · Raymond, MSBuilt 1976 · S/N 28R-7635076N44STTakvorian Sevag · West New York, NJBuilt 1979 · S/N 17271609N44TCKinzie Hon K · Anchorage, AKBuilt 2002 · S/N 9941CCN44TDChristian Joe L · Naylor, GABuilt 1973 · S/N 1000N44TGBlue Water Flying Services LLC · Lumberton, TXS/N 0509N44UDB & K Aviation LLC · Danville, CABuilt 2017 · S/N 172S12072N44UGNomadic Aviation LLC · Sheridan, WYBuilt 1991 · S/N 10088CN44UHAlba Leasing Services LLC · Scottsdale, AZBuilt 2015 · S/N 4677N44UKN44uk Partners LLC · Burlington, WABuilt 2005 · S/N 10969N44VFLorenz Reiff A · Dayton, OHBuilt 2007 · S/N 3FX023N44VTNelson William R · Caldwell, IDBuilt 1994 · S/N 20121N44VVHampton Warrior II Inc · Shelter Island, NYBuilt 1980 · S/N 28-8116009N44WBEvans Jerry R · York, PABuilt 1980 · S/N A1520909N44WCWhite Eagle Investments LLC · San Jose, CABuilt 1995 · S/N 20242N44WDDemray William S · Northville, MIBuilt 1969 · S/N 30-1860N44WERedman Harvey E · Lapeer, MIBuilt 1998 · S/N 001N44WKMaiden Robert M · Williamson, GABuilt 1983 · S/N 11144N44WLLitton Wade N · Townsend, MTBuilt 2026 · S/N 20510N44WMBloomfield Robert C · Anchorage, AKBuilt 1974 · S/N 18-7409095N44WPAnderson Stuart R Jr · Sahuarita, AZBuilt 2015 · S/N ES1N44WTMoore Arlon A · Newcastle, CABuilt 2002 · S/N 23178N44WZWild Blue Yonder LLC · Batavia, OHS/N 729N44XBBrennon Aviation LLC · North Fort Myers, FLBuilt 2002 · S/N 1215N44XCSendero Helicopters LLC · Bandera, TXBuilt 2006 · S/N 11227N44XDDuffer David · Fallbrook, CABuilt 1999 · S/N 1054N44XXFlyboy71 LLC · Kalamazoo, MIBuilt 1979 · S/N 61P07398063362N44YAAarow Aircraft Leasing LLC · Mcminnville, ORBuilt 2004 · S/N 10261N44YGAppelt Jon A · Dayton, NVBuilt 2010 · S/N 21698N44YTJohs Robert W · Palacios, TXBuilt 2020 · S/N 2383
Back to AD 81-18-04 R2