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.

N5976BVarney Walter E · Charlotte, NCBuilt 2018 · S/N 25515N5976EFunkhouser Dennis E · Fredericksburg, VABuilt 1978 · S/N 17271978N5976LGoertz Anton Oscar · Santa Fe, NMS/N AA1-0276N5976QEscobar Timothy · San Antonio, TXBuilt 1965 · S/N 848N5976XFandler Frederick · Shady Shores, TXBuilt 1961 · S/N 119N5977DCarr James C · Wasilla, AKBuilt 1957 · S/N 18-5439N5977PAir-2-Eds LLC · Mesa, AZBuilt 1959 · S/N 24-1070N5977SRothwell Rocky J · Valdosta, GABuilt 1966 · S/N MA-50N5977UMorrow Robert H · Wyndmoor, PABuilt 1970 · S/N 28-26862N5977ZBrown Michael S · Kenai, AKBuilt 1965 · S/N 18-8234N5978DWinkelman Ronald A · Chugiak, AKBuilt 1956 · S/N 18-5441N5978LCorbin Thomas T · Titusville, FLBuilt 1969 · S/N AA1-0278N5978PMealey Patrick James Jude · Menlo Park, CABuilt 1959 · S/N 24-1071N5978QBauer Jared R · Sugar City, COBuilt 1965 · S/N 3208N5979DVeal Tim S · Egegik, AKBuilt 1956 · S/N 18-5442N5979QBlount Aviation LLC · Metairie, LABuilt 1965 · S/N 849N5979SJohnson Jay W · Wichita, KSBuilt 1966 · S/N MA-60N5979UWings Of Grace Ministries Inc · Melbourne, FLS/N 28-26867N5979ZSchuster Timothy A · Carrington, NDBuilt 1965 · S/N 18-8237N597AGSkywest Leasing Inc · St George, UTBuilt 2024 · S/N 2881756N597CBBrandon Air LLC · Valley Stream, NYBuilt 1989 · S/N 3213029N597DAb Prop Plane II LLC · Metairie, LABuilt 2017 · S/N 172S12068N597DCClark James D · Godley, TXBuilt 2021 · S/N 2021DCN597DMBrandon Air LLC · Valley Stream, NYBuilt 1976 · S/N 17268041N597GCAg-Av8r Flying Services LLC · Brookline, NHBuilt 1959 · S/N 7GC-72N597JFDiamond Travel LLC · Olive Branch, MSBuilt 1977 · S/N 28-7890262N597JGKnoxville Flyers Inc · Knoxville, TNBuilt 1997 · S/N 2843087N597LDewitt Troy C · Lake Elmo, MNS/N 30-575N597LELeading Edge Aviation Inc · Bend, ORFirst renewal noticeBuilt 1986 · S/N 597N597MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2020 · S/N 40.1215N597NDNicholas James Esch · Cedar Rapids, IABuilt 1967 · S/N 670041N597RARedtail Aviation LLC · Brookville, PABuilt 2004 · S/N 40.444N597RVBeckley Jeff A · Windsor Heights, IAFirst renewal noticeBuilt 2007 · S/N 70936N597SMoore Charles W · Lees Summit, MOBuilt 1999 · S/N 23995N597SCSpartan Education LLC · Tulsa, OKBuilt 2020 · S/N 2881410N597SPViolet Sparkle Pearl LLC · Hanover, NHBuilt 2000 · S/N 172S8525N597TTTerrell David R · Smithville, TNBuilt 1969 · S/N 17701403N597TXCareer Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13229N597WBaccas Christopher · Sun City Center, FLBuilt 1971 · S/N 28-7125465N5980UT A Aviation LLC · Tucson, AZBuilt 1970 · S/N 28-26870N5980WCooke Carole J Trustee · Aguila, AZBuilt 1967 · S/N 28-4260N5980ZOyster Flite Investments Inc · Wilmington, DEFirst renewal noticeBuilt 1965 · S/N 18-8238N5981DPrecision Ag LLC · Kenmare, NDBuilt 1957 · S/N 18-5446N5981LAnthony Allen J · Commerce Township, MIBuilt 1969 · S/N AA1-0281N5981STucker Mark R · Williamsburg, VABuilt 1966 · S/N MB-72N5981UEast Sun Corp · Greensboro, NCS/N 28-26759N5981WLudwing Jonathan · Tompkinsville, KYBuilt 1967 · S/N 28-4322N5981ZFell Donald M Trustee · Homer, AKBuilt 1965 · S/N 18-8239N5982HClipper New Mexico LLC · Albuquerque, NMBuilt 1949 · S/N 16-609N5982SPercy Gary A · Wedderburn, ORBuilt 1966 · S/N MB-73
Back to AD 81-18-04 R2