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.

N2781RBurley Robert L · Alliance, OHBuilt 1969 · S/N 28R-35272N278NDRegistered aircraftBuilt 2002 · S/N 2844069N279NDSowela Technical Community College · Lake Charles, LABuilt 2000 · S/N 2844034N279SRMetro Aircraft Co · Bloomington, MNBuilt 1979 · S/N 28R-7918130N27GSMazzola Michael · Baton Rouge, LABuilt 1977 · S/N 28R-7737160N2801RSummers Clinton D · Maysville, NCBuilt 1969 · S/N 28R-35288N2802TRandolph Clint · Bullhead City, AZBuilt 1972 · S/N 28R-7235134N2807RHayzan Aviation LLC · Wilmington, DEBuilt 1969 · S/N 28R-35294N280DABouffard Marcel · Flowery Branch, GABuilt 1977 · S/N 28R-7737154N280NDPlane Nonsense Inc · Middletown, DEBuilt 1998 · S/N 2844014N2810TBoudreau Robert D · Rusk, TXBuilt 1972 · S/N 28R-7235137N2811MSale Reported · Rio Grande City, TXSale reportedBuilt 1977 · S/N 28R-7837101N2811RLantz Raymond J · Huntington Beach, CABuilt 1969 · S/N 28R-35296N2816RBipes Anthony G · Forest Lake, MNS/N 28R-35297N2817RHunt Loren M · Nevada, MOBuilt 1969 · S/N 28R-35298N2819FMacair LLC · Kennesaw, GABuilt 1979 · S/N 28R-7918156N281CAFarrugia Joe · Cleveland, TXBuilt 1979 · S/N 28R-7918121N281NDPlane Nonsense Inc · Middletown, DEBuilt 1998 · S/N 2844015N2823TAircraft Restoration LLC · Valparaiso, INBuilt 1972 · S/N 28R-7235140N2824DSchaible John A · Moneta, VAFirst renewal noticeBuilt 1979 · S/N 28R-7918159N2824YForbes Aviation LLC · Boise, IDBuilt 1979 · S/N 28R-7918161N2825TBeatty Daniel H · Bronx, NYS/N 28R-7235122N2826TKochersberger Kevin B · Blacksburg, VABuilt 1972 · S/N 28R-7235016N282NDMoore Aviation Inc · Beaver Falls, PABuilt 2000 · S/N 2844024N2831TMesiemore Roger · Lake Wylie, SCBuilt 1972 · S/N 28R-7235141N2832TKirtland Air Force Base Aero Club · Kirtland Afb, NMBuilt 1972 · S/N 28R-7235142N2837UCamous Alain E · Sunrise, FLS/N 28R-7918166N283PAGeorge'S Aviation Services Inc · Honolulu, HIBuilt 2001 · S/N 2844059N2841RMoses Aviation Services LLC · Uvalde, TXBuilt 1969 · S/N 28R-35305N2842TStacey Daryl · Belton, TXBuilt 1979 · S/N 28R-7918169N2842YRocky Road Aviation LLC · Ruskin, FLBuilt 1979 · S/N 28R-7918170N2844ML C C West LLC · Freehold, NJBuilt 1977 · S/N 28R-7837102N2844RBower Robert W · Scottsdale, AZBuilt 1969 · S/N 28R-35306N2846YDasher Richard Allan · Keystone Heights, FLS/N 28R-7918171N2848MPumarol Rafael · Homestead, FLBuilt 1977 · S/N 28R-7837103N2849TBlue Raven Aviation · Shady Cove, ORS/N 28R-7235145N2850TKolu Pilots Flying Club LLC · Columbus, NEBuilt 1972 · S/N 28R-7235146N2853JSanvoisin Fabio · Las Vegas, NVBuilt 1979 · S/N 28R-7918174N2853NBosque Raul E · Ocala, FLBuilt 1979 · S/N 28R-7918176N2853SCastle Joseph E · Marietta, OHBuilt 1979 · S/N 28R-7918177N2857XWalton Wade · Downingtown, PABuilt 1979 · S/N 28R-7918179N2858KRalston Jared S · Kyle, TXBuilt 1979 · S/N 28R-7918192N285AAGoldrock Aviation LLC · Princeton, NJBuilt 1974 · S/N 28R-7435156N285MGGeorgia Aviation Authority · Eastman, GAFirst renewal noticeBuilt 2017 · S/N 2844167N2861TDesert Sky Flight Group Inc · Tucson, AZBuilt 1972 · S/N 28R-7235147N2862TReed Thomas F · Maize, KSS/N 28R-7235148N2865RCarmel Aviation Inc · Boise, IDBuilt 1969 · S/N 28R-35308N2866RCw Arborists Ltd · Sagaponack, NYBuilt 1969 · S/N 28R-35309N2869TBoone Susan J · Bastrop, TXBuilt 1972 · S/N 28R-7235149N286HGGeorgia Aviation Authority · Eastman, GABuilt 2001 · S/N 2844041
Back to AD 81-11-02 R1