OpenAirDocs.org
AD 81-11-02 R1

Registered aircraft · 1,753

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.

N927KRCandace A Larned Enterprises Inc · Long Beach, CABuilt 1973 · S/N 28R-7335156N9290CMym Air LLC · Pattison, TXBuilt 1978 · S/N 28R-7837184N9290KArrow Leaseback LLC · Danbury, CTBuilt 1976 · S/N 28R-7635231N92DADelory Dana E · Shoreacres, TXBuilt 1992 · S/N 28-37057N92UATaylor Aviation Inc · Montgomery, NYBuilt 1992 · S/N 2837058N9301NAnderson Robert · Tonopah, AZBuilt 1969 · S/N 28R-35001N930RJN147sb LLC · Cortland, NYBuilt 1970 · S/N 28R-35754N9310NApproach Partners LLC · Franklinton, NCBuilt 1969 · S/N 28R-35010N9311NAmendt Joseph J III · Plymouth, MNBuilt 1969 · S/N 28R-35011N9315NDiir County Flying Inc · Sturgeon Bay, WIS/N 28R-35015N931FSM & M Aviation Services Ltd · Rock Falls, ILS/N 28R-7918230N9320NEagle Aviation Inc · Tucson, AZBuilt 1969 · S/N 28R-35020N9321CBas Part Sales LLC · Greeley, COBuilt 1978 · S/N 28R-7837191N9321NRegistration Pending · Shreveport, LARegistration pendingBuilt 1969 · S/N 28R-35021N9328KSantoro Alexandre Jose · Mountain View, CABuilt 1976 · S/N 28R-7635232N9329NWang Huafei · Cupertino, CABuilt 1969 · S/N 28R-35029N9332NSloan Donald W · Dover, DEFirst renewal noticeBuilt 1969 · S/N 28R-35032N9333NGlendale Community College · Glendale, CABuilt 1969 · S/N 28R-35033N9334NRoberson Ronald M · High Ridge, MOBuilt 1969 · S/N 28R-35040N9337NHoward Robert L · Jacksonville, NCBuilt 1969 · S/N 28R-35037N9338NForker Thomas S · Williamsport, PABuilt 1969 · S/N 28R-35038N9340N9340n LLC · Broken Arrow, OKBuilt 1969 · S/N 28R-35041N9347NDavis Braeden L · Blanchard, OKBuilt 1969 · S/N 28R-35048N9348NPletcher Gayle L · Topeka, KSBuilt 1969 · S/N 28R-35049N9349NStutzman Gary A · Watsontown, PAS/N 28R-35050N9350KPanjab Aviation · Las Vegas, NVBuilt 1976 · S/N 28R-7635233N9351NHess Garrett J · Fullerton, CABuilt 1969 · S/N 28R-35054N9354NThurnau Daniel E · Kingston, ILBuilt 1969 · S/N 28R-35058N9359NMorristown Flying Service Inc · Talbott, TNBuilt 1969 · S/N 28R-35066N9362CThanheiser Heige · Lincoln, NEBuilt 1978 · S/N 28R-7837193N9362NPool Busters LLC · Lake Bluff, ILBuilt 1969 · S/N 28R-35069N9363NWeiman William R · Howell, MIBuilt 1969 · S/N 28R-35070N9368NSocal Resorts LLC · Big Bear Lake, CABuilt 1969 · S/N 28R-35076N9370NWings Over Texas Holdings LLC · Denton, TXBuilt 1969 · S/N 28R-35078N9371NTial Aviation Inc · Wilmington, DEBuilt 1969 · S/N 28R-35079N9372NAndys Auto Sales LLC · Caroline, WIBuilt 1969 · S/N 28R-35080N9373NNelson Charles D · Wibaux, MTS/N 28R-35081N9375NProffitt Albert E III · Warwick, RIBuilt 1969 · S/N 28R-35084N9377CLiggett Services Inc · Fort Washington, PABuilt 1978 · S/N 28R-7837195N9379NWinick Evan · Allentown, PABuilt 1969 · S/N 28R-35088N937DCCaledonian Aviation LLC · Raleigh, NCBuilt 1976 · S/N 28R-7635180N9382NGarapati Prasad S · Mount Airy, MDBuilt 1969 · S/N 28R-35091N9383NHall John G · Morrilton, ARBuilt 1969 · S/N 28R-35092N9386NMays David J · Lincolnton, NCBuilt 1969 · S/N 28R-35096N9390NDenison Flying Club LLC · Denison, IABuilt 1969 · S/N 28R-35100N9392NWilder Bradley Alton · Cypress, TXBuilt 1969 · S/N 28R-35102N9394NWeller James Alan · Barnesville, GABuilt 1969 · S/N 28R-35104N9398NCraige Danny D Trustee · Durant, OKBuilt 1969 · S/N 28R-35109N9399NYankcub LLC · North Charleston, SCBuilt 1969 · S/N 28R-35110N93TJSale Reported · Crystal, MNSale reportedBuilt 1969 · S/N 28R-35026
Back to AD 81-11-02 R1