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.

N12150Baker Daniel Ray · Jacksonville, FLBuilt 1973 · S/N 17261845N12153Wertz Richard L · Huron, SDBuilt 1973 · S/N 17261848N1215JRinggold Rolf E · Circle Pines, MNBuilt 1974 · S/N 215N1215LMagrini Shawn P · Salem, OHBuilt 1996 · S/N 1552N1215PTucker Robert B · Melba, IDFirst renewal noticeBuilt 1955 · S/N 23-234N1215UCarbon Six LLC · San Diego, CAS/N 17266912N1215XCella Joseph · Sewell, NJBuilt 1963 · S/N 2618N12161Cessna 12161 LLC · Santa Rosa, CABuilt 1973 · S/N 17261851N12168Boardman Thomas M · Greenwich, NYBuilt 1973 · S/N 17261855N12169Hammond Donald L · Palmer, AKS/N 17261856N1216LLynch Steven J · Harrisville, RIBuilt 1975 · S/N 719N1216TOlsen Christopher D · Bothell, WABuilt 1972 · S/N 28R-7235238N1217Pendley Rory G · Torrance, CABuilt 1955 · S/N 23-237N1217070 Leasing LLC · Englewood, COBuilt 1973 · S/N 17261857N12176Cardinal Wings Aviation LLC · Buckner, KYBuilt 1973 · S/N 17261860N1217CMacpherson David Ross · Cantonment, FLS/N 22-1019N1217EJohnston Jason · Chugiak, AKS/N 255-77N1217MRawashdeh Osamah A · Rochester Hills, MIBuilt 1973 · S/N 177RG0400N1217PHarrison Jeffrey · Benton, ARS/N 61P-0395-135N1217TSauer Roger A · Glenburn, NDBuilt 1972 · S/N 28R-7235239N1217XRanger Aviation Enterprises Inc · San Angelo, TXBuilt 1963 · S/N 187N12180Wings Over Texas Holdings LLC · Denton, TXBuilt 1973 · S/N 17261864N12181Great Landings Aircraft LLC · Arlington, INS/N 17261865N12187Lowcountry Flight LLC · Johns Island, SCBuilt 1973 · S/N 17261870N12188Chantreau Philippe · Vancouver, WABuilt 1973 · S/N 17261871N12189Ozark Aviation LLC · Fayetteville, ARBuilt 1973 · S/N 17261872N1218EShibakov Alexander Y · Gainesboro, TNBuilt 1977 · S/N 324-77N1218GBarth George E · Port Orange, FLBuilt 2012 · S/N 25085N1218JWeeks Wesley J · Iowa Park, TXS/N 218N1218SSkyvibe Leasing LLC · Aurora, ORBuilt 2012 · S/N 172S11161N1218XSmith II Richard D · Luthersville, GABuilt 1963 · S/N 2621N12192Jet & Rotor Aviation LLC · Sacramento, CABuilt 1973 · S/N 17261873N12194Miller Yochonon · Lakewood, NJBuilt 1973 · S/N 17261875N12196Jdr Services LLC · West Plains, MOBuilt 1973 · S/N 17261877N12197K Airmotive LLC · Saint Helens, ORBuilt 1973 · S/N 17261878N1219AFeltman Joshua C · Kenai, AKS/N 18-834N1219GRegistered aircraftBuilt 2007 · S/N 18281886N1219TLrh Equipment LLC · Pendleton, ORBuilt 1972 · S/N 34-7250265N1219USouth Bay Flight Training Center · Carolina, PRBuilt 1976 · S/N 17266916N121AWhidby Richard L · Aynor, SCBuilt 1992 · S/N 2045N121AHSoul Shine LLC · Nashville, TNBuilt 2004 · S/N 10548N121ARGold Mountain LLC · Kalispell, MTBuilt 1979 · S/N 53N121AVPreece William F · Cheshire, CTBuilt 1984 · S/N 28-8490078N121BAPapst David · Freeland, MIS/N 22-9815N121BBFearon Terrence J · Whitehouse Station, NJBuilt 1963 · S/N 18-7908N121BPFord Kevin L · Peachtree City, GABuilt 1968 · S/N 015N121CJCharlie Juliet Aerospace LLC · Naugatuck, CTBuilt 2005 · S/N 40.466N121CPCivil Air Patrol · Maxwell Afb, ALBuilt 2026 · S/N 172S13480N121CRMaxson Lee V · Mesa, AZS/N 418N121CWAerostar Training Services LLC · Kissimmee, FLBuilt 2001 · S/N 172S8975
Back to AD 81-18-04 R2