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.

N761UAFirst Wings LLC · Sayre, PAS/N A1520986N761WWilliams Richard G J · Labelle, FLBuilt 1976 · S/N 60N761YEUnique Educational Experiences Inc · Signal Hill, CABuilt 1981 · S/N A1520997N7620FRed 5 LLC · Kalispell, MTFirst renewal noticeBuilt 1976 · S/N 28-7790195N7620GDc Aero LLC · Ramona, CABuilt 1970 · S/N 17259320N7620HMckinney Leonard F · Anchorage, AKBuilt 1946 · S/N 12-496N7620KBarnes Thomas M · Pittsboro, NCBuilt 1950 · S/N 20-437N7620PSopwith James T · Sacramento, CABuilt 1961 · S/N 18-7737N7621EGrey Matter Inc · Valley Springs, CAS/N 24-2168N7621FMeier Scott F · Jupiter, FLBuilt 1976 · S/N 32-7700006N7621GCrewdawg Aviation LLC · Concord, NCBuilt 1970 · S/N 17259321N7621PMckusick Eileen D · Winooski, VTBuilt 1961 · S/N 24-2832N7621SSmith Michael D · King George, VABuilt 1976 · S/N 244-76N7621WAlexander Steven W · Kansas City, MOBuilt 1965 · S/N 28-2913N7622GBell Sky Pilots Inc · Reedley, CABuilt 1970 · S/N 17259322N7622HEngler Eric M · Cass City, MIBuilt 1946 · S/N 12-516N7622JSkylink Aviation Inc · Florissant, MOBuilt 1968 · S/N 28R-31017N7622KCooper Kristopher A · Hamersville, OHBuilt 1950 · S/N 20-440N7622LHowe Jamie W · Boynton Beach, FLS/N 395N7622PGriffin Robert L Jr · Washington, NCS/N 24-2833N7622WBarnett Donald R · Atoka, TNBuilt 1964 · S/N 28-1586N7623DBaker Donald A · Macedon, NYBuilt 1957 · S/N 22-5327N7623GPlane Sane Aero LLC · Cary, NCBuilt 1970 · S/N 17259323N7623HCowan Drew Paul · Anchorage, AKBuilt 1946 · S/N 12-498N7623JWhite Jeffrey M · Carlsbad, CAS/N 28R-31018N7623RAdamiak Jeffrey · Mount Laurel, NJS/N M-1246N7623SKrejchik Daniel J · Portage, WIS/N 925-76N7623VGove Richard · Riverside, CAFirst renewal noticeBuilt 1976 · S/N 177RG0892N7623WMidwest Heavy Construction LLC · Pleasant Hill, MOBuilt 1964 · S/N 28-1587N7624GAeroflight Flying Club Inc · Jackson, TNBuilt 1970 · S/N 17259324N7624JBriggano LLC · Mount Pleasant, SCBuilt 1969 · S/N 28R-31102N7624SHovey Gregg Beecher · San Diego, CABuilt 1976 · S/N 207-76N7624WHartley Douglas R · Florence, ALBuilt 1964 · S/N 28-1589N7625FHarbaugh Steven J · Riverside, CAS/N 28-7725091N7625HCook Susan R · Carl Junction, MOBuilt 1946 · S/N 12-500N7625JHuebscher Attila · Flemington, NJBuilt 1968 · S/N 28R-31020N7625MMccowan Kenneth L · Kansas City, KSBuilt 2008 · S/N 5816N7625PVfr2imc LLC · Elko, NVBuilt 1961 · S/N 24-2836N7625SN4457s LLC · Southport, NCBuilt 1976 · S/N 330-76N7625WWings Up LLC · Manteno, ILBuilt 1965 · S/N 28-2914N7626FJamestown Jet Center Inc · Jamestown, NDBuilt 1976 · S/N 28-7715214N7626KTopp Audrey · Reno, NVS/N 20-443N7626LLester Androcles J · Ester, AKBuilt 1969 · S/N 399N7626PZervos Fredric W · Orland Park, ILBuilt 1961 · S/N 24-2548N7626RBasinger Weston P · Alexandria, VABuilt 1969 · S/N MA-348N7626WStiles Kenneth R · Ozawkie, KSBuilt 1964 · S/N 28-1591N7626YAdamson Matthew C · Sherwood, ARFirst renewal noticeS/N 30-700N7627DVanhouse Daniel W · Topeka, KSBuilt 1969 · S/N 28R-35055N7627FLo Co Holdings LLC · Loudon, TNS/N 28-7715215N7627KEngwis Douglas R · Rhodes, MIS/N 20-445
Back to AD 81-18-04 R2