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.

N6924PLauderback Lee L · Fort Collins, COBuilt 1960 · S/N 24-2058N6924QPag Air LLC · Concord Township, OHBuilt 1967 · S/N MA-283N6924USchleisman Terry J · St George, UTBuilt 1964 · S/N 294N6924VBramer Aviation LLC · Middleburg, PABuilt 1975 · S/N 22-1304N6924WAlpha 3 LLC · Troy, KSBuilt 1965 · S/N 28-21098N6925NFollrath Rick C · Ludington, MIBuilt 1968 · S/N 680144N6925UDurocher Michael G · New Hudson, MIS/N 295N6925VMay Michael S · Axtell, NES/N 22-1305N6926DGibson Christopher R · Natchez, MSBuilt 1957 · S/N 22-4854N6926HJust Plane Adventures Inc · Crystal Lake, ILFirst renewal noticeBuilt 1975 · S/N 17265648N6926KRed Wolf Aviation LLC · Venice, FLBuilt 1950 · S/N 20-28N6926NTurtle Mountain Air LLC · Bottineau, NDBuilt 1968 · S/N 680183N6926PSkyways Group LLC · Greensboro, NCS/N 24-2060N6926UCreed Stephen R · Fort Worth, TXBuilt 1964 · S/N 296N6926WCola Air LLC · Irmo, SCBuilt 1965 · S/N 28-21101N6927JClear2fly Aerospace LLC · Daytona Beach, FLBuilt 1976 · S/N 28-7625257N6927KLord Mary E · Kalama, WABuilt 1950 · S/N 20-29N6927NFlying High LLC · Gore, VABuilt 1968 · S/N 680145N6927QIowa Military Aviation Heritage Museum · Ankeny, IABuilt 1967 · S/N MA-286N6927UJones Robert Y · Alba, TXS/N 297N6928DRegistration Pending · West Yellowstone, MTRegistration pendingBuilt 1957 · S/N 22-4856N6928HMaya Air Services LLC · Lee, NHBuilt 1983 · S/N ME-405N6928NToysformud LLC · Missoula, MTBuilt 1968 · S/N 680184N6928POwen Colin Jc · College Station, TXBuilt 1960 · S/N 24-2062N6928VSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1975 · S/N 20-1181N6928WHammons Daniel G · Vadnais Heights, MNBuilt 1965 · S/N 28-21289N69290Kflyin LLC · Colorado Springs, COBuilt 1967 · S/N MC-1N6929DJohnson Timothy D · Chapel Hill, NCBuilt 1957 · S/N 22-4857N6929JMhz5620 LLC · Fitchburg, WIBuilt 1998 · S/N 18280158N6929UEisenhardt Scott · Milwaukee, WIBuilt 1964 · S/N 299N6929VHerzog Property Management LLC · Fergus Falls, MNBuilt 1975 · S/N 20-1182N692ACMarshall Carol A · Lees Summit, MOBuilt 2012 · S/N 24350N692ASJgm Aviation LLC · Spring, TXBuilt 2001 · S/N 260006N692CFG&M Aircraft Inc · Wheat Ridge, COS/N 44-7995024N692CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 172S11541N692HMReagan Jason E · Sevierville, TNBuilt 1997 · S/N 22892N692LHChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 2881217N692MADevine James W · Columbus, OHS/N 17700652N692SEmley Steven Allen · Port Angeles, WABuilt 1992 · S/N 28N692SKWings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 15282577N692SPSmith Holdings Inc · Wilmington, DEBuilt 1999 · S/N 172S8102N6930JSkypark Aero Club Inc · Troy, OHBuilt 1976 · S/N 28-7690432N6930VMatisko Michael J · Newburgh, INBuilt 1975 · S/N 20-1183N6930WFlat Out Aviation LLC · Mercer, MOS/N 28-21105N6931DThomas Isaac F · Portland, ORBuilt 1957 · S/N 22-4859N6931JMissouri Valley Flying Club Inc · Culbertson, MTBuilt 1976 · S/N 28-7690433N6931KValiair Limited Co Trustee · Casper, WYBuilt 1950 · S/N 20-35N6931UMascagni Jerry Scott · Greenville, MSBuilt 1964 · S/N 301N6932BHauser Nathan · Newark, DEBuilt 1956 · S/N 22-4210N6932FBruns Luke J · Flower Mound, TXBuilt 1976 · S/N 28-7790174
Back to AD 81-18-04 R2