OpenAirDocs.org
AD 82-06-11 R1

Registered aircraft · 2,375

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:82-06-11-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:82-06-11-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.

N2978RLong 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-35368N2982MBergeron John E · Shenandoah, TXBuilt 1977 · S/N 28R-7803158N2986RArmstrong 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 2844181N29FZTrn Aviation LLC · Mcallen, TXBuilt 1977 · S/N 28R7703052N29RMRedstone 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-7737129N2CLSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1980 · S/N 28R-8131054N2DWSquare One Enterprises Corp · Hot Springs, ARBuilt 1973 · S/N 28R-7335368N30024Druid Aire LLC · Wilmington, DEBuilt 1978 · S/N 28R-7837311N3005NRoaring Fork Aviation LLC · Snowmass Village, COBuilt 1979 · S/N 28R-7931055N3005QParadox Designs Inc · Las Vegas, NVBuilt 1979 · S/N 28R-7931024N300KRWisconsin Aviation-Four Lakes Inc · Madison, WIBuilt 1976 · S/N 28R-7635210N300PAAero Maintenance Inc · Vancouver, WABuilt 1974 · S/N 28R-7435206N3010YPn4 Aviation Holdings LLC · Bishop, CABuilt 1979 · S/N 28R-7931151N3013WBrant 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-7918023N3026WAsplund Jonas · Grand, MNBuilt 1979 · S/N 28R-7931126N3029WLong Stephen D · Ontario, ORBuilt 1979 · S/N 28R-7931128N3030MIn 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-7918028N3033MPhil-Flyers Club Inc · Amarillo, TXBuilt 1977 · S/N 28R-7803160N3035KClippert Royal C · Clarkston, MIBuilt 1978 · S/N 28R-7931030N3037KHeartland Airplanes LLC · Olathe, KSBuilt 1978 · S/N 28R-7931031N3039KKola-Air LLC · Lewes, DEBuilt 1978 · S/N 28R-7931034N303PPDuke Raymond E · Columbia Station, OHBuilt 1975 · S/N 28R-7535129N3049RRls Rental Co DBA · Joplin, MOBuilt 1969 · S/N 28R-35603N3052QBinning Marlin R · Grand River, IABuilt 1979 · S/N 28R-7931073N3056SMagic Shuttle Bus Air Tours LLC · Traverse City, MIBuilt 1979 · S/N 28R-7918058N3057NWhite Brian M · Lindenhurst, NYBuilt 1979 · S/N 28R-7931057N3057RZavadil Clinton J · Sidney, IABuilt 1970 · S/N 28R-35618N3057ZLessaris Thomas P · Huntersville, NCBuilt 1979 · S/N 28R-7918122N3058TN3058t LLC · Cheyenne, WYBuilt 1979 · S/N 28R-7918062N3059RTimes Arrow LLC · Highland, MDBuilt 1969 · S/N 28R-35620
Back to AD 82-06-11 R1