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.

N55HUKaihai Corp · Wilmington, DEBuilt 1999 · S/N 2046N55HYBlackdog Holding Inc · Pleasant Valley, NYBuilt 2013 · S/N 3200N55JAOberman Mark · Camarillo, CABuilt 1971 · S/N 295N55JELakes Area Aviation LLC · Little Falls, MNS/N 23-772N55JJPrivitt Bret · Fort Worth, TXBuilt 1974 · S/N 311-75N55KEMiller Charles A · Walla Walla, WABuilt 1990 · S/N 20081N55KHDietle Kurt · Valley Springs, CABuilt 1979 · S/N R18201104N55KLNewman John D · Clyo, GAS/N 968-1N55KMHeberling Michael J · Fort Worth, TXBuilt 2006 · S/N 40178N55KRBaird Keith W · Marianna, FLBuilt 1975 · S/N 17702344N55LDDouble R Airways LLC · Largo, FLBuilt 1998 · S/N 3246101N55LGWard Randy · Port Saint Lucie, FLS/N 17256728N55LULetourneau University · Longview, TXBuilt 2017 · S/N 172S12063N55MAGodwin Gerald R · Kountze, TXBuilt 2005 · S/N 2316N55MDMcclure David F · Camp Hill, PABuilt 1976 · S/N 28-7790103N55MJBarodge Equipment Leasing Inc · Fairmount, INBuilt 1980 · S/N 32R-8013068N55MPCommanche LLC · Slatington, PAS/N 177RG0668N55NDMeyer William M · Chicago, ILBuilt 1976 · S/N 606HN55NPN55np LLC · Broomfield, COS/N 700010N55PBHorizon Dreams LLC · Homer, GABuilt 1962 · S/N 27-2184N55PGGonzalez Pota H · Seguin, TXBuilt 1968 · S/N 17257793N55PHElectrical Design Consultants Group LLC · Pepper Pike, OHBuilt 2002 · S/N 0145N55PKGlasheen Sean T · Bethel, AKBuilt 2019 · S/N CC18-0096N55PMOrgis Brian E · Houston, TXBuilt 1987 · S/N 1558N55PNKnot Mach LLC · Mchenry, ILBuilt 1974 · S/N 28-7415251N55PTDejulia Thomas A · Seward, AKBuilt 1953 · S/N 18-2675N55PVHeli Munnik LLC · Springfield, MOBuilt 2005 · S/N 10815N55PZVayda Douglas L · Crescent City, FLBuilt 2004 · S/N 9971CCN55QQWilliams John · Tuttle, OKBuilt 2005 · S/N 4807N55RCSmith Matthew E · Creston, IABuilt 1989 · S/N 288N55RDSchober David · Union Bridge, MDBuilt 1966 · S/N 30-1307N55RKSaunders Christopher D · Lehighton, PABuilt 1998 · S/N TD 2020N55RYTwenty Nine Ninety Two LLC · Edina, MNBuilt 2015 · S/N 18282371N55STriple R Aviation LLC · Cleburne, TXBuilt 1965 · S/N TD-631N55SFRegistered aircraftBuilt 1979 · S/N R18201016N55SHTiedeman Craig L · Seven Bays, WABuilt 1998 · S/N 55-483103N55TBKennedy Michael Allen · Oxnard, CABuilt 1966 · S/N 28-21634N55TGPrzyborowski James J · Colchester, CTBuilt 1981 · S/N 7375CN55TTDirty Side Down LLC · Downers Grove, ILBuilt 1976 · S/N TT-1N55TWBeyer Arthur J · Cheektowaga, NYBuilt 1976 · S/N 248N55TXSan Diego Air & Space Museum · San Diego, CABuilt 1986 · S/N 551N55UBEuroaviation Inc Trustee · KematenBuilt 1956 · S/N 18-4264N55VLDarian Alexander L · Brightwaters, NYBuilt 1979 · S/N AA5B1065N55WAHudgens Terry L · Blockton, IABuilt 1972 · S/N 216N55WCHagan Jeremy D · Madrid, NEBuilt 1975 · S/N AA5B-0216N55WMBankston Jeffery · Rice, TXBuilt 1978 · S/N R18200757N55WWGeantil Thomas G · San Diego, CABuilt 1975 · S/N 002N55XFCeb Enterprises LLC · Petal, MSBuilt 1972 · S/N 28-7325132N55XLBusiness Development Systems LLC · Seaford, VABuilt 2002 · S/N 3RX027N56000Wings Over Texas Holdings LLC · Denton, TXBuilt 1973 · S/N 34-7350270
Back to AD 81-18-04 R2