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.

N5424PHerreid William L Jr · Prairie Du Chien, WIBuilt 1958 · S/N 24-478N5424QBeltzville Aero LLC · Lehighton, PABuilt 1973 · S/N 17261787N5424SNeely Benson W · Florence, MSBuilt 1971 · S/N 28-7125119N5424VSorbi Aviation Inc · El Cajon, CABuilt 1980 · S/N 172RG0528N5424ZGavlik Joseph A II · Lincoln, RIBuilt 1961 · S/N 22-9198N54257Meridian Airport Authority · Meridian, MSBuilt 1981 · S/N 17274932N5425LHamilton Paul DBA · Fresno, TXBuilt 1973 · S/N AA5-0325N5425MWong Alex · Hillsborough, CABuilt 1978 · S/N M-2026N5425SBunn James W · New Port Richey, FLBuilt 1980 · S/N R18201570N5425WIrmen Walter Michael Jr · Arlington Heights, ILS/N 28-497N5425YWilson Leif L · Tok, AKBuilt 1964 · S/N 18-8177N5426Vieira Mark · Turlock, CABuilt 2014 · S/N 1001N54266Low Country Skyways LLC · Wilmington, DEBuilt 1989 · S/N 5-18-42N5426FPressley Aviation LLC · New London, NCBuilt 1976 · S/N 28-7715132N5426JMedia Stew LLC · Carson City, NVS/N 17273789N5426MWorthington Aras · Anchorage, AKS/N 001N5426PTromble Tim L · Story, WYBuilt 1958 · S/N 24-480N5426QLen Emery Photography LLC · Springfield, VTBuilt 1973 · S/N 17261789N54273Swanson Gary A · Fort Bragg, CABuilt 1981 · S/N 17274938N5427FRebel Aviation Inc · Liberty, MOBuilt 1976 · S/N 28-7715133N5427ZRegistration Pending · Dothan, ALRegistration pendingBuilt 1961 · S/N 22-9201N54283Sale Reported · Lewistown, MTSale reportedBuilt 1975 · S/N 18-7509130N54285Monahan Richard J Jr · Budd Lake, NJBuilt 1981 · S/N 17274945N54288Chandler Air Service Inc · Chandler, AZBuilt 1981 · S/N 17274946N5428FSchold Maury W · Stafford Springs, CTBuilt 1977 · S/N 28-7790118N5428LMacair Aviation LLC · Xenia, OHBuilt 1980 · S/N 15284313N5428WBon Investment Holdings LLC · Zephyrhills, FLBuilt 1962 · S/N 28-500N54290Laguna Verde Leasing Inc · Wilmington, DEBuilt 1981 · S/N 17274948N54291Flight School Of Gwinnett Inc · Lawrenceville, GABuilt 1981 · S/N 17274949N54296Honcho Aircraft LLC · Crosby, TXBuilt 1981 · S/N 17274950N5429FQuick Kenneth C Jr · Burke, VABuilt 1976 · S/N 28-7790119N5429LGardner T Larry · Dickson, TNS/N AA5-0502N5429PSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1958 · S/N 24-483N5429WLafontaine Generator Exchange Inc · La Fontaine, INBuilt 1962 · S/N 28-501N542APa28 Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843762N542CWCentral Washington University · Ellensburg, WABuilt 2018 · S/N 2881051N542EClegg Edward T · Standish, MEBuilt 2008 · S/N 82179N542ECWang Warner Weihsu · Vienna, WVBuilt 2005 · S/N 18281691N542EREmbry Riddle Aeronautical University Inc · Prescott, AZBuilt 2022 · S/N 172S12872N542EZLesher Caleb J · Cottonwood, CAS/N 80N542FCooper Nina · Lake Elmo, MNBuilt 2022 · S/N 542N542FLHaffey George F · Fernandina Beach, FLBuilt 1971 · S/N 28-7125374N542GAtlantic Helicopters International Inc · Lewes, DENon-citizen corporation, flight hours not reportedBuilt 1994 · S/N 2459MN542HGraham Jack D · Hamilton, TXBuilt 1976 · S/N 343N542HFPars Avn Corp · Wilmington, DEBuilt 1974 · S/N 28R-7435310N542JJAlf Ix LLC · Chicago, ILBuilt 2022 · S/N 4496542N542JPGrauer Keaton · Marysville, KSBuilt 1968 · S/N 28R-30772N542JVBeaubien Matthew L · Sacramento, CABuilt 1999 · S/N 1450N542KAtp Aircraft 3 LLC · Wilmington, DEBuilt 2017 · S/N 2843866N542KSKent State University · Stow, OHBuilt 2025 · S/N 172S13367
Back to AD 81-18-04 R2