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.

N404EPSkywest Leasing Inc · St George, UTBuilt 2014 · S/N 172S11436N404GAEly Ag Services LLC · Sallisaw, OKBuilt 2005 · S/N 10953N404JEMedia Stew LLC · Carson City, NVBuilt 1993 · S/N 724-93N404KRCenterline Aviation Inc · Middletown, DEBuilt 2009 · S/N 18282203N404MHCall One Inc · Clarinda, IABuilt 2018 · S/N 75-10615N404NDUniversity Of North Dakota · Grand Forks, NDBuilt 2026 · S/N 28010004N404RBMyrehn Bruce D · Carmel, INBuilt 1972 · S/N AA5-0101N404SDToms Aviation Inc · Addison, ILBuilt 2006 · S/N 11217N404SEBaird Jonathan D · Saint Joseph, MIBuilt 1974 · S/N 28R-7435223N404SWWood Roger W · Sale Creek, TNBuilt 1968 · S/N 17256702N404TWRobison Dave · Roberts, IDBuilt 1997 · S/N 1348N404UXSimply Living LLC · Fort Myers, FLBuilt 1969 · S/N 28-5423N404ZMuehlberg Stephen E · Newcastle, OKBuilt 2025 · S/N 75-10404N405Burklund Joel H · Minneapolis, MNBuilt 1996 · S/N 1340N40506Dingler Larry G · Langtry, TXS/N 1753N4050GSpellbound Inc · White Bear Lake, MNBuilt 1991 · S/N 1776N4050NCrawford Reagan Matthew · Lumberton, TXBuilt 1968 · S/N 680026N4050ZMaya Aviation LLC · Lee, NHBuilt 1964 · S/N 18-8052N4051PEagle 64 LLC · Stuart, FLBuilt 1958 · S/N 23-1528N40520Goodman Larry D Trustee · Prineville, ORBuilt 1975 · S/N 18-7509121N40523Gossett Owen L · Central Point, ORBuilt 1975 · S/N 18-7509123N4052AWard Daniel W · Boonville, NCBuilt 1979 · S/N DV0100N4052FG&M Aircraft Inc · Wheat Ridge, COBuilt 1976 · S/N 28-7790002N4052VBorror Eric F · Gerber, CABuilt 1956 · S/N 18-5218N4052ZMetro Service Air · Fairbanks, AKBuilt 1963 · S/N 18-8054N4053FBluebird & Blue Skys LLC · St Simons Is, GABuilt 2023 · S/N 18283210N4053TSky High Helicopters LLC · Camarillo, CABuilt 2018 · S/N 30045N4053ZSpohnholz Randy K · Anchorage, AKBuilt 1963 · S/N 18-8056N40549Agnew Mark W · Wasilla, AKBuilt 1969 · S/N 18-8865N4054GWorks Mark S · Cincinnati, OHBuilt 2023 · S/N 30095N4054XLongmire Vaughn H · Tampa, FLS/N 5154N4054ZBiggs Craig P · Preston, IDBuilt 1963 · S/N 18-8059N40552Peeler Jason B · Flooresville, TXS/N 18-7509126N40558Hill Casey J · Anchorage, AKBuilt 1975 · S/N 18-7509127N4055KHarris William R Jr · Salisbury, CTBuilt 2020 · S/N 2611N4055NKansara Sanjay · Coopersburg, PABuilt 2020 · S/N 2619N4055XAtlas Air LLC · Salt Lake City, UTBuilt 1974 · S/N 5055CN4055ZMartin Lawrence M · Clam Gulch, AKS/N 18-8060N4056BTesar Thomas J · Williamsport, TNBuilt 2022 · S/N 4866N4056MBarfield Anthur F · Fairborn, OHBuilt 1991 · S/N 1793N4056VHillsboro Aero Academy LLC · Hillsboro, ORBuilt 2023 · S/N 30093N4056XHolliday Ralph C III · Coppell, TXBuilt 1970 · S/N 5156N4056ZG & L Airborne Inc · Wilmington, DEBuilt 1963 · S/N 18-8064N40575Evans Samuel F · Iuka, MSBuilt 1976 · S/N 18-7709018N40579Burwell Jeffery S · Wasilla, AKBuilt 1976 · S/N 18-7509129N4057MUsac Airways 693 LLC DBA · Fort Lauderdale, FLBuilt 1947 · S/N 12-2940N4057NMominee Jules T · Evansville, INBuilt 1968 · S/N 680027N4057ZBruegger Shannon B · Lance Creek, WYBuilt 1963 · S/N 18-8066N4058CHolt Tommy · Big Lake, TXBuilt 2021 · S/N 4860N4058NHancock Randall G · Evanston, WYBuilt 1968 · S/N 680168
Back to AD 81-18-04 R2