OpenAirDocs.org
AD 81-18-04 R2

Registered aircraft · 81,720

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.

N2140QAtlantic Beach Flyers LLC · Atlantic Beach, FLBuilt 1974 · S/N 177RG0540N2140RStidham Stephen A · North Pole, AKBuilt 1989 · S/N 01N2140TCupples Thomas Joseph · San Marcos, CABuilt 1971 · S/N 287105162N2140VSidhu Harish · Anaheim, CABuilt 1979 · S/N 28-7990340N2140WAbbott Bruce E · Seal Beach, CABuilt 1974 · S/N M-1513N2140YNorcal Flight Club · Vacaville, CABuilt 1979 · S/N 28-7916372N21411Piper Partners · Coventry, CTBuilt 1978 · S/N 28-7990044N21412Long Island Aviators LLC · Seaford, NYBuilt 1978 · S/N 28-7990045N21413Botwinick Jeffrey Richard Patrick · Syracuse, NYBuilt 2003 · S/N 18281273N21418Woodard Christopher Shane · Forney, TXBuilt 1978 · S/N 32-7840185N2141DFoturis Inc · Kingston, PABuilt 2003 · S/N 18281297N2141JRegistered aircraftBuilt 1978 · S/N 28-7990221N2141PElliott David E · Peyton, COBuilt 1956 · S/N 23-734N2141QNeuman Allen D · Sanger, TXS/N 177RG0541N2141RM5:16 Ventures LLC · Brush Prairie, WABuilt 1979 · S/N 28-7990302N2141THorizon Ventures Inc · Red Oak, IABuilt 1971 · S/N 28R-7135144N2141WMeyer Carl F Jr · Eagan, MNBuilt 1974 · S/N M-1514N2141YAnson Air LLC · Sugar Land, TXBuilt 2003 · S/N 172S9562N2142QLichtenberg Jeffrey L · Brookfield, MOBuilt 1974 · S/N 177RG0542N2142RFieldhouse Warren W · Ocala, FLBuilt 1969 · S/N 28-5469N2142XAnvab Inc DBA · Concord, NHBuilt 1979 · S/N 28R-7918089N2142YChanfrau Frederic · Barrington, RIS/N 28-7911142N21438Texas State Technical College · Waco, TXBuilt 1979 · S/N 44-7995051N2143AUniversal Aviators Academy Inc · El Monte, CABuilt 1978 · S/N 44-7995085N2143CPlane Fun Inc Tr Trustee · Snellville, GABuilt 1973 · S/N 423-74N2143MVan Wagner Aerial Media LLC · Hollywood, FLBuilt 1946 · S/N 20928N2143NSuter John R · Jacksonville, NCS/N 12379N2143PMcgrath Susan · Morehead City, NCBuilt 1979 · S/N 28-7911103N2143TRahim Shamim Inc · Jacksonville, NCBuilt 1971 · S/N 28-7125454N2143YBk Aviation Services LLC · Graford, TXBuilt 1979 · S/N 28-7916357N21441Paris Air Inc · Vero Beach, FLBuilt 1978 · S/N 28-7916040N21442Ducote Randal J · Parker, COBuilt 1978 · S/N 28-7990048N21443Compton James R · Boise, IDBuilt 1978 · S/N 28-7990049N21446Ham Todd O · Opdyke, ILBuilt 1974 · S/N 17263946N21449Curry Robert B · Delphos, OHBuilt 1978 · S/N 32-7840186N2144AWhite James O · Bim, WVBuilt 1952 · S/N 22-582N2144NPaxton Matthew P · Ketchum, IDBuilt 1979 · S/N 28-7911096N2144THilds Marine Service Inc · Pasadena, MDBuilt 1971 · S/N 28-7105166N2144VAnson Air LLC · Sugar Land, TXBuilt 2003 · S/N 18281276N2144WHansen Kenneth L · Kimballton, IABuilt 1979 · S/N 28-7916331N21454Textron Aviation Inc · Wichita, KSBuilt 2003 · S/N 18281228N21455Drewett Edward A · Many, LABuilt 1974 · S/N 17263950N2145FSmith Jeffrey D · Hamilton, GAFirst renewal noticeBuilt 1972 · S/N AA5-0017N2145JSchool Of Missionary Aviation Technology · Ionia, MIBuilt 2003 · S/N 172S9418N2145MHanscom Afb Aero Club · Hanscom Afb, MAS/N 28R-7837069N2145NRaschio Ernesto G · Miami, FLBuilt 1979 · S/N 32-7940034N2145QErnstes William L · Greensburg, INBuilt 1974 · S/N 177RG0545N2146AZhukov Igor · Live Oak, FLBuilt 2003 · S/N 18281265N2146MPeterson Scott W · Garfield, KSBuilt 1946 · S/N 20931N2146QMcdonald Anthony Robert · Brookside, UTBuilt 1974 · S/N 177RG0546
Back to AD 81-18-04 R2