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.

N33085Salsbery Scott E · Brush Prairie, WAS/N 28R-7535118N33095Kollmansberger James K · Fond Du Lac, WIBuilt 1975 · S/N 28R-7535120N33096United States Air Force Owner · Offutt Afb, NEBuilt 1975 · S/N 28R-7535121N3310PLopes Gaston A · Dallas, TXBuilt 1973 · S/N 28R-7435121N33110Grandview Aviation LLC · Bethel Park, PAS/N 28R-7535122N33123Maccorkle Leon · Round Pond, MEBuilt 1975 · S/N 28R-7535123N33129Cloud 9 Flying Club Inc · Cedar Rapids, IABuilt 1975 · S/N 28R-7535124N33142Cogan Christopher · Warner Robins, GABuilt 1975 · S/N 28R-7535126N33151Thayer Victoria · Ontario, CABuilt 1975 · S/N 28R-7535127N331ACTango Thirty One Aero Clube Inc · Mckinney, TXBuilt 1980 · S/N 28R-8018061N3326MMcray Brett H · Sugar Land, TXBuilt 1977 · S/N 28R-7837111N3327MNearhoof Jeremy R · The Woodlands, TXBuilt 1977 · S/N 28R-7837112N33301Jensuz LLC · Agoura Hills, CABuilt 1975 · S/N 28R-7535130N33348Air Venture Inc · Hagerstown, MDBuilt 1975 · S/N 28R-7535136N33349Stroud Jerry · Hope, ARBuilt 1975 · S/N 28R-7535137N33361Petit Raymond T Trustee · Westerville, OHBuilt 1975 · S/N 28R-7535087N33372N33372 LLC · New Bern, NCBuilt 1975 · S/N 28R-7535139N33379Unruh David E · Cadiz, KYBuilt 1975 · S/N 28R-7535141N33399Begin Nelson · N Berwick, MEBuilt 1975 · S/N 28R-7535142N333PGAty Aviation Inc · Watertown, SDBuilt 1977 · S/N 28R-7737114N33420Rooney George A III · Colts Neck, NJBuilt 1975 · S/N 28R-7535148N33485Bruner Timothy R · Laurel, MDBuilt 1975 · S/N 28R-7535154N33491Love Steven J · Rio, ILBuilt 1975 · S/N 28R-7535155N33530Lapointe Curtiss James · Powell, TNBuilt 1975 · S/N 28R-7535157N33566Roebke Karen L Trustee · Gilbert, AZBuilt 1975 · S/N 28R-7535161N33567R Merritt Investments Inc · Jonesville, MIBuilt 1975 · S/N 28R-7535162N33599A & Aviation LLC · Pinellas Park, FLBuilt 1975 · S/N 28R-7535165N33642Smith Gary E · Des Moines, IABuilt 1975 · S/N 28R-7535166N33663Brown Tony Mac II · Bowling Green, KYBuilt 1975 · S/N 28R-7535171N33668Northeast Cubs LLC · Wilmington, DEBuilt 1975 · S/N 28R-7535172N33684Coletti John · Grant Park, ILBuilt 1975 · S/N 28R-7535174N33685Leighty Brian D · Dighton, KSS/N 28R-7535179N33698Briggs Michael L · Howell, MIBuilt 1975 · S/N 28R-7535181N33720Westerhold Wayne · Cary, NCS/N 28R-7535182N33733Swink Cory A · Gold Hill, NCBuilt 1975 · S/N 28R-7535184N33750Geek Air LLC · Wilmington, NCBuilt 1975 · S/N 28R-7535187N33759Flight Time Club LLC · Searcy, ARFirst renewal noticeBuilt 1975 · S/N 28R-7535188N33770Bassett Christopher D · Robbinsville, NCS/N 28R-7535191N33795Coco Phillip J · Middletown, CTBuilt 1975 · S/N 28R-7535194N33804Klintrin Collectibles LLC · Downers Grove, ILBuilt 1975 · S/N 28R-7535195N33815Hyde Leasing LLC · Water Valley, MSBuilt 1975 · S/N 28R-7535199N33816Hettinger John E · Sterling, COBuilt 1975 · S/N 28R-7535200N33849Sanzaro Aero LLC · Bunnell, FLBuilt 1975 · S/N 28R-7535206N33863N318bm LLC · Monroe, LABuilt 1975 · S/N 28R-7535208N338672 F LLC · Valentine, NEBuilt 1975 · S/N 28R-7535209N338PAFl Ventures I LLC · Winter Park, FLBuilt 2002 · S/N 2844076N339DALink Aviation LLC · Eau Claire, WIBuilt 2002 · S/N 2844077N33CLBills Jacqueline Trustee · Willard, MOBuilt 1979 · S/N 28R-7918067N33ESDuncan Ernest Michael · Dripping Springs, TXBuilt 1976 · S/N 28R-7635461N33KVWild Blue Aero LLC · O Fallon, ILBuilt 1979 · S/N 28R-7918185
Back to AD 81-11-02 R1