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.

N5824WBowman William K · Morrison, TNBuilt 1965 · S/N 28-2107N58250Gulick Stephen P · Burlington, VTBuilt 1985 · S/N 50N5825LMahurin Devin · Mountain Grove, MOBuilt 1972 · S/N AA5-0025N5825PRobles Carlos J · San Jose, CABuilt 1959 · S/N 24-906N5825QHobgood Joel A · Sharpsburg, GABuilt 1965 · S/N 778N5825TTeshima Mark William · Clovis, NMS/N 28-1595N5825UGantz Clayton B · Forestville, CABuilt 1970 · S/N 28-26656N5825WIndian Trucking Company Inc · Destin, FLBuilt 1965 · S/N 28-2113N5826LGibson Bobby S · Clearwater, FLBuilt 1972 · S/N AA5-0026N5826QN5826q LLC · Sheridan, WYBuilt 1965 · S/N 3122N5826UHill Christopher L · Milner, GABuilt 1969 · S/N 28-26657N5827DNurge Richard · Gilroy, CAS/N 22-4502N5827PTwo Seven Papa LLC · Pueblo, COBuilt 1959 · S/N 24-908N5827QPromises LLC · Pompano Beach, FLBuilt 1965 · S/N 859N58281Lueck Thomas J · Cedar Rapids, IABuilt 1978 · S/N 1180734N5828DSchulz Lucas H · New Boston, MIBuilt 1956 · S/N 22-4503N5828QGreater Cincinnati Aero Club LLC · Alexandria, KYBuilt 1965 · S/N 3123N58294Nance James Aaron · Woodbridge, VABuilt 1979 · S/N 18-7909055N5829QHenery L Bodmer Inc · Kenmare, NDBuilt 1965 · S/N 780N5829UFarrell Mark O · Pittsburgh, PABuilt 1969 · S/N 28-26660N582BBAftab Younus · Pleasanton, CABuilt 1984 · S/N BLACKWOOD 0001N582BLSolera Aviation LLC · Bozeman, MTBuilt 2025 · S/N 2881959N582LPCape Island Aviation LLC · Millville, NJBuilt 2004 · S/N 172S9582N582MHuffman Prairie LLC · Claymont, DEBuilt 1991 · S/N 1608N582MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2004 · S/N 40.398N582NDChristiansen Aviation LLC · Wilmington, DEBuilt 2008 · S/N 4496261N582TCBreak For It Aviation LLC · Draper, UTBuilt 2005 · S/N 18281550N5830CKueber Jake T · Anchorage, AKBuilt 1962 · S/N 18-7778N5830WWard Orval G · Bentonville, ARBuilt 1965 · S/N 28-2148N5830YMost Gordon G · Thedford, NEFirst renewal noticeS/N 18-8411N58319Schweizer Rsg LLC · Fort Worth, TXBuilt 1979 · S/N 390761N5831HJenrich Scott J · Lake Stevens, WABuilt 1949 · S/N 16-448N5831LCooks Aviation LLC · Conover, NCBuilt 1972 · S/N AA5-0231N5831QCueva Arturo A · Los Angeles, CABuilt 1965 · S/N 781N5831WSonafrank Eric J · Somerset, INBuilt 1965 · S/N 28-2149N5832HForcey Charles F · Westville, INBuilt 1949 · S/N 16-450N5832JAerial Advertising Services · Livermore, CAS/N 17273842N5832LPlesea Lucian · Redlands, CABuilt 1972 · S/N AA5-0232N5832PBrooks William L · Vienna, VABuilt 1959 · S/N 24-913N5832QHli Aviation LLC · Red Banks, MSBuilt 1965 · S/N 3125N5832UBecker Randall T · Santa Rosa, CABuilt 1970 · S/N 28-26663N5833DBixler Scott E · Rising Fawn, GABuilt 1956 · S/N 22-4509N5833HSchipul Melissa J · New Milford, CTBuilt 1949 · S/N 16-446N5833JAlbatross Air Inc · Beaver, WVBuilt 1980 · S/N 17273843N5833PCochran Keith W · Long Beach, CAS/N 24-914N5833QDyer Albert L · New Smyrna Beach, FLBuilt 1965 · S/N 782N5833WJts Aircraft LLC · Rock Hill, SCBuilt 1965 · S/N 28-2159N5833YMyob Group LLC · Ocala, FLS/N 27-2982N5833ZGrossman Larry R · White Pigeon, MIBuilt 1963 · S/N 22-9664N5834HPierce Gilbert H · Germantown, TNBuilt 1949 · S/N 16-453
Back to AD 81-18-04 R2