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.

N2885QFisher Global LLC · Conway, ARBuilt 1971 · S/N 17259885N2885RArrow Flight LLC · Springfield, VABuilt 1969 · S/N 28R-35318N2885ZMclaughlin Paul E · Mansfield, OHS/N 374-78N28863Koleszar John R · Lynnfield, MABuilt 1978 · S/N AA5B0870N28865Maritime Aviation LLC · Kalispell, MTBuilt 1978 · S/N AA5B0871N28866Marcoski Edward T · Downers Grove, ILBuilt 1978 · S/N AA5B0872N28869Registered aircraftBuilt 1978 · S/N AA5B0874N2886KTallman George L Jr · Ocala, FLBuilt 1979 · S/N 28-7990529N2886PBurg Mark S · Powell Butte, ORBuilt 1955 · S/N 18-4483N2886QWright Flyers Club Inc · Huber Heights, OHBuilt 1971 · S/N 17259886N2886TAtkins Joseph Van · Lenoir, NCBuilt 1972 · S/N 28-7225268N2886ZNettles William C · Soldotna, AKBuilt 1959 · S/N 18-7059N28878Alsup Patrick J · League City, TXBuilt 1978 · S/N AA5B0876N28879Cady Eugene Roland · Port Orange, FLBuilt 1978 · S/N AA5B0877N2887EMeeker Stanton · Squaw Valley, CABuilt 1978 · S/N 17271360N2887PGoldberg Aviation · Cody, WYBuilt 1955 · S/N 18-4485N2887TSanetra George W · Gary, INBuilt 1972 · S/N 28-7225269N2887XTolmachev Nikolay A · Anchorage, AKS/N 17700287N2887ZElliott Robert M · Sweetwater, TXBuilt 1959 · S/N 18-7060N28881Buttery Craig B · Loxahatchee, FLBuilt 1978 · S/N AA5B0878N28887Danos Laura S · Hampton Falls, NHBuilt 1979 · S/N 28-7990432N2888GClark Larry K · Sedalia, COBuilt 1979 · S/N 28-7911226N2888MLapoint Daniel L Jr · Bellevue, MIBuilt 1946 · S/N 12-1426N2888QChilds William C · Bridgeport, ALS/N 17259888N2888TValenstein Glenn L · Howards Grove, WIBuilt 1972 · S/N 28R-7235153N2888ZHonkomp Daniel · Euless, TXBuilt 1978 · S/N 1270-78N28890Slocum Chad W · Pleasant Grove, UTS/N 28-7990433N28893Janzen Andrew S · Oklahoma City, OKBuilt 1978 · S/N AA5B0753N28896Pafford David A · Floydada, TXS/N AA5B0752N2889TRegistered aircraftBuilt 1972 · S/N 28R-7235154N2889XKogele Donald J · Broadus, MTBuilt 1967 · S/N 17700289N2889ZPeters Thomas K · Wasilla, AKBuilt 1959 · S/N 18-7066N288ABSyrasoft Aviation LLC · Baldwinsville, NYBuilt 1962 · S/N 24-3033N288AWRegistered aircraftBuilt 2004 · S/N 81684N288BDHop Props LLC · Houston, TXBuilt 2003 · S/N 80595N288BLBlue Line Aviation LLC · Smithfield, NCBuilt 2024 · S/N 2881751N288BTValiair Ltd Co Trustee · Casper, WYBuilt 2005 · S/N 18281607N288CBCalifornia Baptist University · Riverside, CABuilt 2023 · S/N 2881635N288CDKrempp Michael E · Arlington, TXBuilt 2006 · S/N 18088CN288CFAdams Charles R · Granbury, TXBuilt 1978 · S/N AA5B0840N288CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281988N288FDFly Dynasty Corp · Ocala, FLBuilt 1967 · S/N 28-23767N288GHBowen Christina M · Shreveport, LAS/N 28-1938N288HCLampe Erik J · Appleton, WIBuilt 1992 · S/N 10101N288HGGeorgia Aviation Authority · Eastman, GABuilt 2002 · S/N 2842144N288HPChaikin Steven · Kaunakakai, HIBuilt 2001 · S/N 2843482N288JCDave Faust Inc · Wellington, KSBuilt 2008 · S/N 71711N288KDavison Pere · Cody, WYBuilt 2003 · S/N 80240N288LLWitold Siekaj · Port Townsend, WAS/N AA1B-0365N288MCTomanec Jean · Victoria, TXBuilt 2002 · S/N 18281110
Back to AD 81-18-04 R2