OpenAirDocs.org
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.

N33085Salsbery Scott E · Brush Prairie, WAS/N 28R-7535118N3308ARegistered aircraftBuilt 1953 · S/N 22-1580N3308KHowell Harley L Jr · Colville, WABuilt 1946 · S/N 1301N3308ZWeber Daniel Troy · Port Charlotte, FLS/N 22-7239N33092Shepherd Edward H · Grass Valley, CABuilt 1975 · S/N 28-7525153N33095Kollmansberger James K · Fond Du Lac, WIBuilt 1975 · S/N 28R-7535120N33096United States Air Force Owner · Offutt Afb, NEBuilt 1975 · S/N 28R-7535121N3309CScott Parker H · Bulverde, TXBuilt 1978 · S/N R18200270N3309JMomentum Foundation · Tullahoma, TNS/N 15066009N3309MWillford George A · Waterville, OHBuilt 1947 · S/N 12-2042N3309ZRubbert Randy C · Reynolds, NDBuilt 1959 · S/N 22-7241N330ARegistered aircraftBuilt 1954 · S/N 22-1939N330ALDemuri Daniel J · Woods Cross, UTBuilt 1990 · S/N 3030N330CPCharlie Pop Flyers Inc · Jacksonville, FLBuilt 1969 · S/N 30-1884N330CTRobinson Paul J · Saint Joseph, MOBuilt 1974 · S/N 17702158N330DDUtah State University · Logan, UTBuilt 2002 · S/N 3401N330DGAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1991 · S/N 766N330FTSuwannee Arrow LLC · Clearwater, FLBuilt 1982 · S/N 28-8216209N330HLSwift David A Trustee · Springfield, MOS/N 24941N330HPBigman Elliot S · Todd, NCS/N 01N330JBHavens Aviation LLC · Blacklick, OHBuilt 1997 · S/N S1755N330JDGreen Erik M · Mastic Beach, NYBuilt 1998 · S/N 18280267N330JGCultra LLC · Naples, FLS/N 24-3042N330JHHoover Jerrald J · Yelm, WABuilt 1999 · S/N 1058N330JKAldrich Gregory C · Sarasota, FLBuilt 2010 · S/N 009N330KGBeats Driving LLC · Falling Waters, WVBuilt 2007 · S/N 40050N330KRCherry Hill Aviation Inc · Freetown, INBuilt 1956 · S/N 22-4152N330LSDawson Douglas · Fernley, NVBuilt 2000 · S/N 001N330MEUnique Educational Experiences · Signal Hill, CABuilt 2000 · S/N 172S8462N330MFWroblewski Peter Ross · Lompoc, CABuilt 2003 · S/N 0033N330MMHobbs Phillip E · Saint Augustine, FLBuilt 1983 · S/N 444N330MSCanyon Airmotive LLC · Frisco, TXBuilt 1995 · S/N 750-95N330PCaldaso Inc · Peachtree City, GABuilt 1978 · S/N 32-7840164N330PMPractical Education LLC · New York, NYBuilt 2008 · S/N 172S10809N330RLBlue Mountain Flyers · Palmerton, PABuilt 2002 · S/N 2210N330SMSa Aerosports LLC · Kalispell, MTBuilt 2004 · S/N 005N330SXDb Aero Inc · Wilmington, DEBuilt 1995 · S/N JONAS-0007N330TVan Hatten Derek R N · Anchorage, AKS/N 18-2444N330TAAdvanced Aerobatics LLC · Ocala, FLBuilt 2002 · S/N 003N330TFMartin Earl · Seneca Falls, NYBuilt 1996 · S/N 3246032N330WLLee William L · Jonesborough, TNBuilt 2015 · S/N 011N33107Florida Coastal Flying Club LLC · Titusville, FLBuilt 1975 · S/N 28-7525154N3310AKonrad Robert M · Centennial, COS/N 22-1587N3310BHilgendorf Ross E · Welcome, MNBuilt 1954 · S/N 22-2125N3310MToepper Richard B · Port Ludlow, WABuilt 1947 · S/N 12-2041N3310PLopes Gaston A · Dallas, TXBuilt 1973 · S/N 28R-7435121N3310WBig Wing Energy LLC · Decatur, ARBuilt 1965 · S/N 32-148N33110Grandview Aviation LLC · Bethel Park, PAS/N 28R-7535122N3311ARitchie John A Jr · Gold Hill, NCBuilt 1953 · S/N 22-1586N3311BJackson Tal H · Spearman, TXBuilt 1954 · S/N 22-2126
Back to AD 81-18-04 R2