OpenAirDocs.org
AD 81-18-04 R2

Registered aircraft · 81,700

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.

N1040ZDonnelly Jeff E · Pembroke, MABuilt 2006 · S/N 3232062N10410Clark George A · Worcester, MABuilt 1975 · S/N 17702321N1041AWinkelman Donald L · Anchorage, AKBuilt 1951 · S/N 18-619N1041HCentury Flight Systems Inc · Mineral Wells, TXBuilt 1977 · S/N 32R-7780125N1041QSwaz Aviation LLC · Mesa, AZBuilt 1977 · S/N 28-7716081N1041SN1041s LLC · Key West, FLBuilt 1977 · S/N 17268658N1041URegistered aircraftBuilt 1981 · S/N E3B-469N1041XGyllensten Scott · Guilford, CTBuilt 1975 · S/N 28-7505199N10420Kinney Powell Mcvay · Coppell, TXBuilt 1975 · S/N 17702324N10421Registered aircraftBuilt 1997 · S/N 21017CN1042APetrie Michael · Chugiak, AKBuilt 1951 · S/N 18-616N1042DCarson Roger K · Anthem, AZBuilt 2016 · S/N 80189N1042EPerez Alexander · Palmer, AKBuilt 1977 · S/N 1207-77N1042JJac LLC · Denham Springs, LAS/N 21024CN1042LHale Cynthia G · Upper Black Eddy, PAS/N 14087CN1042PMcalpine David B · Fort Worth, TXBuilt 1986 · S/N 64-18123N1042SPiper Cameron · Winchester, VABuilt 1977 · S/N 172-68662N1042UShackleford Developments Of Sc LLC · Mount Pleasant, SCBuilt 1971 · S/N 34-7250026N1042XN1042x LLC · Papillion, NEBuilt 1975 · S/N 28R-7535223N1042ZMatthews Casey B · Belmont, NCBuilt 1997 · S/N 28004CN10438Czerwonka David E · Rumford, RIBuilt 1997 · S/N 21031CN1043JLanmon Herman Jr · Hamilton, TXBuilt 1974 · S/N 127N1043KShadowens Jackie R · Sapulpa, OKBuilt 1954 · S/N 18-3919N1043QRegistered aircraftBuilt 1977 · S/N 28R-7737025N1043SAmerican Aviator LLC · Newark, DEBuilt 1977 · S/N 172-68679N1043UClinton Arlys L · Fair Oaks, CABuilt 1946 · S/N 81N1043XAustin Security Corp · Battleboro, NCBuilt 1975 · S/N 28R-7535224N10446Schell Brothers II LLC · Rehoboth Beach, DEBuilt 1973 · S/N 172-62515N1044FNottorf Eric W · Keller, TXBuilt 1995 · S/N 20046CN1044JNagasaka Bruce J · Weiser, IDBuilt 1973 · S/N 44N1044LFitch Mark · Anchorage, AKBuilt 1996 · S/N 25009CN1044NMaule Flight Inc · Moultrie, GABuilt 1996 · S/N 25006CN1045Paragon Airplane Leasing Co · Fort Myers, FLBuilt 2024 · S/N 28020177N10457Six Ten Ventures LLC · Cedar Hill, TXBuilt 2003 · S/N 20608194N1045ALange Bryan C · Harrison, NEBuilt 1951 · S/N 18-622N1045BBigger Val J · Las Cruces, NMBuilt 2023 · S/N VBKD-1N1045JFenn Matthew A · Liberal, KSBuilt 1996 · S/N 004N1045LBernard Robert J · Millbury, MABuilt 1974 · S/N 638N1045RKersting Thomas J · Volga, SDBuilt 1998 · S/N 21042CN1045YRovers Bradley S · Chazy, NYBuilt 2005 · S/N 18281571N1046BOglesby Jonathan D · Okmulgee, OKBuilt 1958 · S/N 1273N1046ERisk Indemnification Professionals LLC · Boston, MABuilt 1977 · S/N 296-77N1046XFarnham Aviation Services LLC · Ames, IABuilt 1975 · S/N 28-7525266N1046ZAvery Robert K · Fort Worth, TXBuilt 1970 · S/N WLB-1N10470Leary Dan P · Girdwood, AKBuilt 1951 · S/N 18-895N10475Lissow William M · New Port Richey, FLBuilt 1967 · S/N 67-18368N1047JFirst Flight Investments LLC · Bartow, FLBuilt 1973 · S/N 47N1047MChristiansen Aviation LLC · Wilmington, DEBuilt 2007 · S/N 2842286N1047NMccormick William R · Louisville, KYBuilt 1998 · S/N 28005CN1047UStueve'S Certified Organic Dairy · Oakdale, CABuilt 1998 · S/N 23043C
Back to AD 81-18-04 R2