OpenAirDocs.org
AD 81-18-04 R2

Registered aircraft · 81,718

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.

N1144LComposite Sign Products Inc · Zeeland, MIBuilt 1964 · S/N 306N1144MCcr Aviation LLC · Kalispell, MTS/N 17259444N1144WNimmo Lawrence · Cordova, MDBuilt 1981 · S/N 24-1189N1144XFly Texas Sky LLC · Arlington, TXFirst renewal noticeBuilt 1975 · S/N 28-7505215N1144ZBay Lux Ventures LLC · Tampa, FLBuilt 1977 · S/N 287890231N1145JPrestridge Austin · Newark, OHBuilt 1974 · S/N 145N1145TWilliams Thomas J · Burr Ridge, ILBuilt 1981 · S/N 24-1191N1146LSak Aviation LLC · Cheney, KSBuilt 1981 · S/N 24-1198N1146VPlane Cents LLC · Henderson, NVBuilt 1996 · S/N 2641N1147N7371y LLC · Waterford, MIBuilt 1964 · S/N 30-423N11476Shannon Kenneth H · Washington, DCBuilt 1975 · S/N 17702340N1147JSandel Henry Adrian III · Natchez, MSBuilt 1974 · S/N 132N1147LLandry Lonny Reid · Fort Worth, TXBuilt 1964 · S/N 309N1147XPax Flyers LLC · Hollywood, MDBuilt 1975 · S/N 28R-7535259N1148ATyrrell Luke L · Fairbanks, AKBuilt 1951 · S/N 18-742N1149AFodor Scott M · Barryton, MIBuilt 1951 · S/N 18-743N114ABHartnell Bernard L Trustee · Grand Junction, COBuilt 2018 · S/N 140102N114ANHake Scott W · Swoope, VABuilt 1978 · S/N 14396N114ATSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1994 · S/N 14619N114AWCameron Hugh R · Gainesboro, TNBuilt 1976 · S/N 14095N114AZWebb Brent E · Safford, AZBuilt 2019 · S/N 140304N114BShankle Michael L · Culpeper, VABuilt 1993 · S/N 14588N114BBServtek LLC · Waterloo, WIBuilt 1977 · S/N 24-0118N114BCBoatman John H Jr · Smyrna, TNS/N 376N114BGJohnson Mark A · Thousand Oaks, CABuilt 1987 · S/N 216N114BMJaswal Faisal · La Conner, WABuilt 1976 · S/N 14082N114BXRcs Aviation LLC · Indian Trail, NCBuilt 1992 · S/N 14543N114CDNorwest Ventures LLC · Santa Cruz, CABuilt 1963 · S/N 30-37N114CECommander Air LLC · Purcellville, VABuilt 1996 · S/N 14640N114CFAw Chartering LLC · Franklin, TNBuilt 1974 · S/N 28-7505080N114CGUnited Aviation LLC · Whitehall, PABuilt 1995 · S/N 14628N114CMCunningham Terence R · Santa Barbara, CABuilt 1977 · S/N 18-7709146N114CTTairex Inc · Wilmington, DES/N 14413N114DCHaley Jack Michael Trustee · Keller, TXBuilt 1990 · S/N 057N114DFNorthwoods Distribution Services Inc · Rhinelander, WIBuilt 1978 · S/N 14360N114DJJohnson Danny A · Joplin, MOBuilt 1994 · S/N 455N114DKQualitair LLC Trustee · MichelstadtBuilt 1990 · S/N 0923N114DSNewberg Curtis · Willmar, MNBuilt 2007 · S/N 80886N114DWLayman Nathan L · Hudson, WIBuilt 1978 · S/N 14408N114ECBulldog132llc · Boulder, COBuilt 1971 · S/N BH100/132N114EEEngstrom Eric R · Eastover, NCBuilt 1978 · S/N 14357N114ELNaperville Flying Club · Woodridge, ILBuilt 1981 · S/N 32-8106096N114ERIhle Edward A · Elmendorf, TXS/N 0879N114FAJprg Aviation Inc · Orlando, FLBuilt 1978 · S/N 17271720N114FBFly Appleton LLC · Appleton, WIBuilt 2005 · S/N 172S9811N114GJefferson Devin S · Sandia, TXS/N TK-1N114HPDolanair LLC · Coal Valley, ILBuilt 1978 · S/N 14370N114HSHenderson State University · Arkadelphia, ARBuilt 2007 · S/N 21092CN114JAWright Richard D · Acworth, GABuilt 1978 · S/N 14365N114JCRossi Michael W · Boca Raton, FLBuilt 1984 · S/N 1092
Back to AD 81-18-04 R2