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.

N7486PMakee Markus J · Painesville, OHBuilt 1961 · S/N 24-2679N7486WBaney David · Summitville, INBuilt 1963 · S/N 28-1396N7486YGardner Canaan · Chandler, OKBuilt 1964 · S/N 30-547N74870H O S Aviation LLC · Mount Pleasant, SCBuilt 1976 · S/N AA5B-0270N74875Thomas Martin G · Tucson, AZBuilt 1976 · S/N AA5B-0271N74877Hopkinson Keith G · Spicewood, TXBuilt 1976 · S/N AA5B-0272N74878Stiles Steven A Trustee · Pebble Beach, CABuilt 1976 · S/N AA5B-0273N7487DSouthern Cross Aviation Inc · Wilmington, DEBuilt 1957 · S/N 18-5826N7487GRich Aviation Services LLC · Fort Worth, TXBuilt 1970 · S/N 17259187N7487KMesones Juan D · North Yarmouth, MEBuilt 1950 · S/N 20-401N7487PShockley Lee W · Denver, COBuilt 1961 · S/N 24-2680N7487RDeschamp Patrick B · Bottineau, NDS/N 28-22040N7487ZTruckee Tahoe Soaring Assoc · Truckee, CABuilt 1965 · S/N 25-3502N74881Rockwood Holdings LLC · Valrico, FLBuilt 1976 · S/N AA5B-0274N74882Huntley David · San Antonio, TXBuilt 1976 · S/N AA5B-0276N74884Switek Robert E Jr Trustee · San Andreas, CABuilt 1976 · S/N AA5B-0278N74886Fisher Robert W · Madison, ALBuilt 1976 · S/N AA5B-0280N74889Unlimited Aviation LLC · Webster, NYBuilt 1967 · S/N 28-4519N7488DDust Devil Herefords Inc · Ingomar, MTBuilt 1957 · S/N 18-5827N7488P2final LLC · Leesburg, VABuilt 1961 · S/N 24-2681N7488RSimpson Kevin B · Newberg, ORBuilt 1966 · S/N 28-22042N7488WAnuradha Jairam · Camas, WABuilt 1963 · S/N 28-1399N7489DKelly Kevin M · Eagle River, AKBuilt 1957 · S/N 18-5828N7489FColdwell Jerry Lee · Jordan, MTBuilt 1977 · S/N 570595N7489GCloud Fleet Aviation LLC · Fort Lauderdale, FLBuilt 1970 · S/N 17259189N7489JMayer Thomas D · Medford, ORBuilt 1968 · S/N 28R-30849N7489LMills Randall J · Monroe, MIBuilt 1975 · S/N 18-7509076N7489PRegistration Pending · Whitefish, MTRegistration pendingBuilt 1961 · S/N 24-2682N7489WHostetler Kevin · Green Forest, ARBuilt 1963 · S/N 28-1400N748ACSweeet Aviation LLC · Dover, DEBuilt 1999 · S/N 847-99N748AKKatz Andres U · Dallas, TXBuilt 2017 · S/N 81853N748BPNiehaus Michael J · West Burlington, IABuilt 2005 · S/N 10994N748CDuffel Christopher · Bellevue, WABuilt 1985 · S/N 25N748CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 172S11570N748DAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1980 · S/N ME-341N748EMMaxwell Edward G · Louisville, KYBuilt 2022 · S/N 71812N748GHummingbird Aviation LLC · Custer, SDBuilt 2023 · S/N 1319N748HHEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1991 · S/N 1748N748JLTallevast LLC · Sarasota, FLBuilt 2009 · S/N 81585N748LLdz Aviation Resources LLC · Sayville, NYBuilt 1976 · S/N 0748N748MSchapler Robert H · Alexandria, VABuilt 2006 · S/N 70048N748MKAero-Tech Services Inc · Lititz, PABuilt 2022 · S/N 172S12780N748PASkywest Leasing Inc · St George, UTBuilt 2019 · S/N 2881190N748PKHaller Kurt L · Pleasanton, CABuilt 2019 · S/N 001N748RAAri Ben Aviator Inc · Fort Pierce, FLBuilt 1988 · S/N 2841035N748RSGrady Michael J · Farmington, NMBuilt 1968 · S/N 28-5230N748SBright Skies Sales And Leasing LLC · Hendersonville, TNS/N 1728N748SPBg-Ip LLC · Saratoga, CABuilt 2000 · S/N 172S8682N748WHHuete Charles W · Carriere, MSBuilt 1969 · S/N AA1-0297N748WMTruett Michael J · Beavercreek, ORBuilt 2025 · S/N 92314
Back to AD 81-18-04 R2