OpenAirDocs.org
AD 81-18-04 R2

Registered aircraft · 81,720

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.

N12976Wanda Collins Professional Pilot Services LLC · Madisonville, TXBuilt 1973 · S/N 17262421N1297AOrwick Robert J · Newell, SDS/N 18-1101N1297FJprg Aviation Inc · Orlando, FLBuilt 1979 · S/N 17272990N1297JLemrich Aero Inc · Dallas, TXS/N 297N1297XScott Benjamin D · Grove City, OHS/N 170N12983Haman Aviation Services LLC · Nokomis, FLBuilt 1973 · S/N 17262427N12984Go Fly Az LLC · Gilbert, AZBuilt 1975 · S/N 17702394N12985Alamakee Flyers · Waukon, IABuilt 1973 · S/N 17262429N12991Usda Forest Service Fepp · Columbia, SCBuilt 1973 · S/N 17262432N12997Wausau Flying Service Inc · Wausau, WIS/N 17262437N1299AHunsicker Greg A · Berryton, KSBuilt 2000 · S/N 80252N1299URice Melvin G · Bridgeport, TXBuilt 1976 · S/N 17266993N1299XMunoz David · Corona, CAS/N 2680N1299ZWojdac David E · Mosinee, WIS/N TD-467N129AGMarsh Equipment LLC · Aurora, ORBuilt 2024 · S/N 4496574N129AXBradley William R · Colorado Springs, COBuilt 2005 · S/N 60326N129BAAdvise By Air LLC · Whittier, CABuilt 2004 · S/N 18281353N129BRMiller Theodore C Jr · Edinburg, TXBuilt 2008 · S/N 52AN129CCChilds David E · Amber, OKBuilt 2002 · S/N 9951CCN129CPUpright Aviation LLC · Helena, MTBuilt 2001 · S/N 18067CN129DPaqua David · Norwalk, CTBuilt 2008 · S/N 1858N129DDDruckenbrodt Donald D · Fredericksburg, TXS/N 1393N129FRWings Over Texas Holdings LLC · Denton, TXBuilt 1981 · S/N 17275338N129GCBlue Air Training Corp · Las Vegas, NVBuilt 1980 · S/N 55N129GHWoelbing Aviation LLC · Franksville, WIBuilt 1994 · S/N M-1-1775N129GRGunderson Marlon O · Lake Elmo, MNBuilt 2017 · S/N GR01N129HFHeritage Asset Leasing LLC · Ronkonkoma, NYBuilt 2004 · S/N 172S9667N129JAWhite River Holdings LLC · Hernando, MSBuilt 2022 · S/N 18283172N129JBKuykendall Robert J · Jefferson, WIBuilt 2009 · S/N 6-4584N129JPSlezak Douglas C · Atascadero, CAS/N 003N129JTNiles Air LLC · Concord, NCBuilt 2024 · S/N 18283288N129JZThomas James E · Forsyth, GABuilt 2002 · S/N 60321N129KFf22 LLC · Scottsdale, AZBuilt 2022 · S/N 172S12825N129MAAttwood Nicholas John · Ashburn, VAS/N 2890219N129MFAviation Sciences LLC · Cambridge, MABuilt 1984 · S/N 129N129MSWinging It LLC · Kalispell, MTBuilt 2004 · S/N 3712N129MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2003 · S/N 4496172N129RVVans Aircraft Inc · Aurora, ORBuilt 2000 · S/N 2N129SAero Quest LLC · Olive Branch, MSBuilt 1974 · S/N 17263118N129SEBarrington Air Inc · Littleton, COBuilt 1998 · S/N 18280384N129SLLee Aero LLC · Wichita, KSBuilt 1979 · S/N 17273503N129SWRoyal Air LLC · Sarasota, FLBuilt 2018 · S/N 172S12210N129SYDaigle Danny · Greenville, MEBuilt 1978 · S/N 17270741N129TBPeer Thomas A · Tullahoma, TNBuilt 2018 · S/N 82289N129TFGary Boyce Aircrft Sales LLC · Shelbyville, TNBuilt 2026 · S/N 70673N129WMSky Solutions LLC · Detroit, MIBuilt 2004 · S/N 10564N129WSNew Horizon Aviation Inc · Warwick, RIBuilt 2005 · S/N 172S10012N129WTHill Tool LLC · Missoula, MTBuilt 2014 · S/N 001N129XCCatbird Cub LLC · Tampa, FLBuilt 2019 · S/N CC19-0047N129YEBuell Travis W · Harper, TXBuilt 2002 · S/N 3334
Back to AD 81-18-04 R2