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.

N2943DSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1979 · S/N 28R7918231N2945RHuestis Gary M · Blackfoot, IDBuilt 1969 · S/N 28R-35339N294FSBoard Of Trustees Of Southern Illinois University · Murphysboro, ILBuilt 2018 · S/N 2844177N2950RRebecca Aviatrix LLC · Columbus, INS/N 28R-35340N2952RTowers Roland M · Shady Shores, TXBuilt 1969 · S/N 28R-35344N2954QClark Ronald Joe · Scottsdale, AZBuilt 1979 · S/N 28R-7918234N29566International Air Services Inc Trustee · Carson City, NVBuilt 1979 · S/N 28R-7918146N295FSBoard Of Trustees Of Southern Illinois University · Murphysboro, ILBuilt 2018 · S/N 2844178N2960LLucas Danny O · Ridgeland, SCBuilt 1979 · S/N 28R-7918236N2962RHurn Enterpises LLC · Grand Beach, MIS/N 28R-35347N2962WB&R Aircraft LLC · Wadsworth, OHBuilt 1979 · S/N 28R-7918239N2962YGutierrez Juan · Sarasota, FLS/N 28R-7918240N29638Seal Seismic Service LLC · Oklahoma City, OKS/N 28R-7918155N2966RTobin Michael A · Plain City, OHBuilt 1969 · S/N 28R-35351N296DMDewitt Gary S · Anacortes, WAS/N 28R-7635033N296MGGeorgia Aviation Authority · Eastman, GABuilt 2017 · S/N 2844168N2970RNorwood Norman · Sheridan, WYBuilt 1969 · S/N 28R-35354N2972RDahl Steven B · Medway, MABuilt 1969 · S/N 28R-35357N2973RQuinones Roland · Mckinney, TXS/N 28R-35358N2977RRegistered aircraftBuilt 1969 · S/N 28R-35363N2978RLong Jeffrey K · Bethel Springs, TNBuilt 1969 · S/N 28R-35365N2979RBecker Joshua · Warrington, PABuilt 1969 · S/N 28R-35366N2980RSlagle Noah J · Griffin, GABuilt 1969 · S/N 28R-35368N2986RArmstrong Dustin L · Hobbs, NMS/N 28R-35375N2988RSpilman Kathleen M · Mandan, NDBuilt 1970 · S/N 28R-35671N2992RSolrei Inc · West Palm Beach, FLS/N 28R-35382N2993RSell Carl N · Spanaway, WABuilt 1969 · S/N 28R-35384N2994R2994r Aircraft Leasing LLC · Spanish Fork, UTBuilt 1969 · S/N 28R-35386N2995RAbj Aviation LLC · Montgomery, OHBuilt 1969 · S/N 28R-35387N2999RMatthews Flying Club LLC · Ogden, UTBuilt 1969 · S/N 28R-35391N299MGGeorgia Aviation Authority · Eastman, GABuilt 2018 · S/N 2844181N29RMRedstone Arsenal Flying Activity · Redstone Arsenal, ALBuilt 1975 · S/N 28R-7535269N29SPPurpera Daryl G · Pride, LAS/N 28R-35695N2BYMostello Andrew · Harvard, MABuilt 1977 · S/N 28R-7737129N2DWSquare One Enterprises Corp · Hot Springs, ARBuilt 1973 · S/N 28R-7335368N30024Druid Aire LLC · Wilmington, DEBuilt 1978 · S/N 28R-7837311N300KRWisconsin Aviation-Four Lakes Inc · Madison, WIBuilt 1976 · S/N 28R-7635210N300PAAero Maintenance Inc · Vancouver, WABuilt 1974 · S/N 28R-7435206N3013WBrant Lee A · Penngrove, CAS/N 28R-7918085N3016WBramble And Schaffer Aviation LLC · Raleigh, NCBuilt 1979 · S/N 28R-7918086N3020WDague John · Monroe, INS/N 28R-7918087N3021KKj Cessna LLC · Waxahachie, TXS/N 28R-7918020N3022UJackson Thomas S · Dunnsville, VAS/N 28R-7918072N3023KVx Parts LLC · Portsmouth, NHBuilt 1978 · S/N 28R-7918022N3025KWojteczko Jason A · Derby, KSBuilt 1978 · S/N 28R-7918023N3030MIn Line Aviation LLC · Greensburg, PABuilt 1977 · S/N 28R-7837109N3031KCrowder John K · Rutherfordton, NCBuilt 1979 · S/N 28R-7918027N30325N30325 LLC · Lakeland, FLBuilt 1978 · S/N 28R-7837313N3032KDamian Richard Eugene · Sioux Falls, SDBuilt 1979 · S/N 28R-7918028N303PPDuke Raymond E · Columbia Station, OHBuilt 1975 · S/N 28R-7535129
Back to AD 81-11-02 R1