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.

N5032TFree Lutheran Association Of Pilot Supporters Inc · Plymouth, MNBuilt 1972 · S/N 28-7225325N5032URegistration Pending · Fort Huachuca, AZRegistration pendingBuilt 1978 · S/N 465-79N5032VLewis Timothy W · Thousand Palms, CABuilt 1978 · S/N 1069-79N50338Ware Michael · Bovina, TXBuilt 1978 · S/N 1072-79N5033DSigurdson Richard J · Olivia, MNBuilt 1978 · S/N 289-78N5033FRohaly Richard L · Prineville, ORBuilt 1978 · S/N 1064-78N5033KRichard Robin G · New Franken, WIBuilt 1978 · S/N 369-78N5033PHouser Kyler D · West New York, NJBuilt 1958 · S/N 24-36N5033REastern Cincinnati Aviation Inc · Batavia, OHBuilt 1974 · S/N 17263274N5033SGpsp Aviation LLC · Bronx, NYBuilt 1970 · S/N 28R-35762N5033VGarvis Darren G · Livermore, CABuilt 1979 · S/N 1070-79N5033WSapp Jedidiah T · Cordova, AKBuilt 1978 · S/N 1071-79N5033ZCada Kenneth C · Phoenix, AZS/N 22-8651N5034GDyson James R · Hilltop Lakes, TXBuilt 1978 · S/N 373-79N5034HHernandez Dorothy V · Juneau, AKBuilt 1975 · S/N 17265309N5034KPiercy Ronald S · Moses Lake, WABuilt 1978 · S/N 1073-79N5034MHood Bruce Allen Jr · Windsor, SCBuilt 1965 · S/N 28-20749N5034NLittle Gregory L · Carnegie, OKBuilt 1979 · S/N 291-79N5034PNeufeld William J · Bostwick, FLBuilt 1958 · S/N 24-37N5034SPlattsmouth Aviation LLC · Plattsmouth, NES/N 28R-35801N5034VBibler Barry D · Spearfish, SDBuilt 1978 · S/N 467-79N5034WCurran Robert A · Waldorf, MDBuilt 1978 · S/N 468-79N50350Redline Shane Z · Amarillo, TXBuilt 1978 · S/N 471-79N50358Lockhart 50r Partners LLC · Austin, TXBuilt 1978 · S/N 1286-79N5035GLasche James R Jr · Weatherford, TXS/N 1284-79N5035JNewton Justin T · Hurdland, MOS/N 1285-79N5035LSteinbauer Timothy · Sandusky, OHBuilt 1971 · S/N 492N5035MFlight World Inc · San Juan, PRBuilt 2001 · S/N 172S8967N5035NCp Aviation Inc · Santa Paula, CABuilt 1978 · S/N 470-79N5035QWilfer Dennis M · Fairbanks, AKBuilt 1979 · S/N 292-79N5035SReady Airways LLC · Roseville, CABuilt 1970 · S/N 28R-35766N5035WHennells Dann · Naples, FLBuilt 1961 · S/N 28-37N5035XAtlantic Arrow Aircraft Inc · Kennesaw, GABuilt 2026 · S/N 172S13522N5035ZAmish Peter S · Newberry, FLBuilt 1961 · S/N 22-8653N50361Mcbride Daniel · Burleson, TXBuilt 1979 · S/N 478-79N50363Dennis Steven M · Rice Lake, WIS/N 10599N5036GVagias Janet Rose · Niceville, FLBuilt 1979 · S/N 473-79N5036RArctic Winds Inc · King Salmon, AKS/N R18200628N5036SArrow II Flyers LLC · Jacksonville, FLBuilt 1970 · S/N 28R-35804N5036WAeroglide Aviation Group LLC · Trenton, NJBuilt 1961 · S/N 28-38N50371Potter Michael J Jr · Fairbanks, AKBuilt 1978 · S/N 283-78N50376Hayes Brad M · Grove, OKBuilt 1978 · S/N 282-78N5037CHakel Bruce A · Fairbanks, AKBuilt 1979 · S/N 1086-79N5037KD & K Aviation Inc · Milford, IABuilt 1979 · S/N 1087-79N5037NTriniair LLC · Warner Robins, GABuilt 1979 · S/N 480-79N5037RJlinn Aviation Inc · Quinlan, TXBuilt 1974 · S/N 17263278N5037SGannon Gary L · Cumberland, WIS/N 28R-35781N5037TPhoenix East Aviation LLC · Daytona Beach, FLBuilt 1972 · S/N 34-7250205N5037ZBoyd Christian K · Corinth, TXBuilt 1961 · S/N 22-8655N50380C P Aviation Inc · Santa Paula, CABuilt 1979 · S/N 1291-79
Back to AD 81-18-04 R2