OpenAirDocs.org
AD 81-18-04 R2

Registered aircraft · 81,720

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.

N222HHitchcock Duane B · Burlington, COBuilt 1997 · S/N 222N222HERound Engine Aero · Nashville, MIBuilt 1978 · S/N 17271191N222HFFarrior Hugh · New Port Richey, FLBuilt 2024 · S/N 0247N222HLDouble K Flying LLC · Scottsboro, ALBuilt 1961 · S/N 24-2670N222HPHarrison Walter E · Taylor, TXBuilt 1982 · S/N R18201881N222HUPlane Nutz LLC · Sugar City, IDBuilt 2003 · S/N 2238N222HYWarner Robins Air Service Inc · Cochran, GABuilt 2006 · S/N 2335N222JAJeff Abrams LLC · Ocala, FLBuilt 2000 · S/N 3062N222JGNoyes Jeffery A · Bridgeport, TXBuilt 1959 · S/N TD-215N222KKBymers Gary E · Waunakee, WIS/N 222N222KLLohmueller Kurt M · Powder Springs, GABuilt 2005 · S/N 21308N222KMKomoroski Edward J · Frenchtown, NJBuilt 1990 · S/N 337N222KRSharon Carl G · Brookshire, TXBuilt 1979 · S/N 24-0773N222KSTriple Two Inc · Wilmington, DEBuilt 1976 · S/N 28-7790270N222LKCoulter Lance A · Meeker, COBuilt 2009 · S/N 40262N222LYLava Tech LLC · St George, UTBuilt 2010 · S/N 91629N222MJHonore Breen Aviation LLC · Allegan, MIS/N 12-1905N222MNMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881532N222MTJw182 LLC · Kalispell, MTBuilt 1998 · S/N 18280108N222NARodriguez Lukas · River Oaks, TXBuilt 1974 · S/N 28-7415226N222NDPlane Nonsense Inc · Middletown, DEBuilt 2001 · S/N 2842111N222NLLawson Lonnie B II · Linden, PABuilt 2001 · S/N 25137N222NYCivil Air Patrol · Maxwell Afb, ALBuilt 1985 · S/N 17276473N222PCSmith Dustin L · Corinth, MSBuilt 1987 · S/N 1N222PFStokes Brian L · Boulder City, NVBuilt 1979 · S/N R18201308N222PJSchroeder James L · Rapid City, SDBuilt 1973 · S/N 28-7305259N222PWWelch Michael C · El Dorado Hills, CABuilt 1990 · S/N 155N222RACaptain Rick LLC · Miami Lakes, FLBuilt 1973 · S/N 28R-7435127N222RJAmbrose James · Dyersburg, TNBuilt 1977 · S/N 22-1438N222RKMiller Bruce · Plano, TXBuilt 1974 · S/N 448-74N222RVWyatt Jacob A · Ogallala, NEBuilt 1992 · S/N 2305N222SPRobinson Avery Clark · Phoenix, AZBuilt 1965 · S/N 701N222TJSimmons Scott C · Pleasant Prairie, WIBuilt 1979 · S/N 28-7911314N222TMJtm Ranches Equipment LLC · Dallas, TXBuilt 1981 · S/N 18-8109081N222TRHarper David E · Stillwater, MNBuilt 1946 · S/N 108-322N222UClukey David Alan · Bryant Pond, MEFirst renewal noticeBuilt 1957 · S/N 23-912N222UKCantine Steven L · Kotzebue, AKBuilt 1991 · S/N 2210N222USTicoair LLC · Wilmington, DEBuilt 1979 · S/N 17273491N222VBGalaxy Aviation LLC · Nantucket, MAS/N 10009N222VWCool Beans LLC · Newtown, PAS/N 18280085N222WAWiseman Aviation Inc · Flagstaff, AZS/N R18201443N222WGWalker Scott Aviation LLC · Woodward, OKBuilt 1978 · S/N M-2092N222XMSchlasinger Larry DBA · Chetek, WIBuilt 1998 · S/N 18280119N222XPMarshall Greg J · Alexandria, VABuilt 2021 · S/N 102N2230TWhite Pelican LLC · Union City, TNBuilt 1971 · S/N 28-7105189N2230XPoff Matthew W · Miramar Beach, FLBuilt 1979 · S/N 28-7990374N2231EState Of Iowa · Des Moines, IABuilt 2007 · S/N 18281924N2231FSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2007 · S/N 18281925N2231JWares Auto Sales Inc · Traverse City, MIBuilt 1978 · S/N 32R-7985053N2231KBishop Elijah Ar · Ukiah, CABuilt 1947 · S/N 4958
Back to AD 81-18-04 R2