OpenAirDocs.org
AD 81-11-02 R1

Registered aircraft · 1,752

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-11-02-R1')
    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-11-02-R1')
  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.

N31906Bosveld Bobby J · Markesan, WIBuilt 1978 · S/N 28R-7837254N31950Kasparie Ronald · Quincy, ILBuilt 1978 · S/N 28R-7837259N31970Benefield John H Jr · Cedartown, GABuilt 1978 · S/N 28R-7837260N31TLT M L Aircraft Inc · Narrowsburg, NYS/N 28R-7235314N31VUJav Enterprises LLC · Broomfield, COBuilt 2018 · S/N 2844179N32020N32020 LLC · Springfield, MOBuilt 1974 · S/N 28R-7535015N32047Sat Aircraft LLC · Clermont, FLBuilt 1974 · S/N 28R-7535018N32129Weaver Arnold G · Sandusky, MIS/N 28R-7535028N32172International Aviation Group LLC · Lake Wales, FLBuilt 1974 · S/N 28R-7535030N32196Overstreet Bradley · Greenville, SCBuilt 1974 · S/N 28R-7535034N32294Cloud Dancer Aviation Inc · Deland, FLBuilt 1974 · S/N 28R-7535041N32344Cunningham James L · Oshkosh, WIBuilt 1974 · S/N 28R-7535046N32357Malone Bernard G · Frenchtown, NJBuilt 1974 · S/N 28R-7535047N32379Erkert Jason A · Phoenix, AZBuilt 1974 · S/N 28R-7535049N32393Mcnamee James R · Cocoa, FLBuilt 1974 · S/N 28R-7535050N323BGElectric Cowboy Aviation LLC · Okeechobee, FLS/N 28R-7435210N323MGRstv Inc · Dubuque, IABuilt 1976 · S/N 28R-7635256N32427Mcfadden Robert K · Port Orange, FLBuilt 1974 · S/N 28R-7535054N32444Jtz Aviation LLC · Wilmington, DEBuilt 1974 · S/N 28R-7535057N32469Dufresne Justin Barth · Temple City, CABuilt 1974 · S/N 28R-7535059N32481Flyboy Fantasy Inc · South Lake Tahoe, CABuilt 1974 · S/N 28R-7535061N32483Showah Jason M · Brentwood, TNBuilt 1974 · S/N 28R-7535062N32492Doyle Dylan D · Cerrillos, NMBuilt 1974 · S/N 28R-7535063N32521Proflite Of Alaska LLC · Fairbanks, AKS/N 28R-7535065N32524Barth Tom L · Manhattan, KSBuilt 1974 · S/N 28R-7535067N32552Garys Fork Auto Service LLC · Hydes, MDBuilt 1974 · S/N 28R-7535068N32613Gray Matthew C · Enterprise, ALBuilt 1974 · S/N 28R-7535072N32622Region Flyers LLC · Valparaiso, INBuilt 1974 · S/N 28R-7535073N32665White Richard L Trustee · Los Altos, CABuilt 1974 · S/N 28R-7535076N32680Neumann Peter G · Cape Coral, FLBuilt 1974 · S/N 28R-7535077N32693Oconner Brian E · Santa Cruz, CAS/N 28R-7535078N32727Denton Christopher G · Youngsville, NCS/N 28R-7535082N32747Aaof Investments LLC · Fort Mc Coy, FLBuilt 1974 · S/N 28R-7535084N32749Ryszka Aviation LLC · Heber City, UTBuilt 1974 · S/N 28R-7535085N32773Dalba Andrew Naim · Anaheim, CABuilt 1974 · S/N 28R-7535088N32783Frederick Michael A · Cleves, OHBuilt 1974 · S/N 28R-7535089N32784Denicola Frank J · Visalia, CABuilt 1974 · S/N 28R-7535090N32820Turner Douglas A · Sacramento, CABuilt 1974 · S/N 28R-7535093N32831Jochen Nathan D · Sevierville, TNBuilt 1974 · S/N 28R-7535094N32861New Hope Equipment Sales Inc · Ardmore, OKBuilt 1974 · S/N 28R-7535096N32870Pineland Flying LLC · Valdosta, GABuilt 1974 · S/N 28R-7535097N328MASs Aviation LLC · Wichita, KSFirst renewal noticeBuilt 1974 · S/N 28R-7435035N328NCHenderson Anthony B · Hoschton, GABuilt 1977 · S/N 28R-7737164N32978Klippel Charlie L · Huntington Beach, CABuilt 1975 · S/N 28R-7535103N32994Lima Golf Bravo LLC · Chandler, AZBuilt 1975 · S/N 28R-7535104N32PDAsp Victor · Shoreline, WABuilt 1973 · S/N 28R-7435091N33006Hawks Travis · Mount Vernon, MOS/N 28R-7535105N33031Jerpbak Mark J · El Dorado Hills, CABuilt 1975 · S/N 28R-7535108N33047Meise Justin · Hopewell Junction, NYBuilt 1975 · S/N 28R-7535111N33075Portugues Aviation LLC · Canovanas, PRS/N 28R-7535116
Back to AD 81-11-02 R1