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.

N2865RCarmel 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-7235149N2869XCalifornia In Nice Inc · San Jose, CAS/N 28R-7931231N286HGGeorgia Aviation Authority · Eastman, GABuilt 2001 · S/N 2844041N286NDMorris Randall Sanford Hartnett · Fort Worth, TXBuilt 2000 · S/N 2844035N2870ARodriguez Rafael Corrales · Miami, FLBuilt 1979 · S/N 28R-7931232N2870LDewire Mark · Wilmington, NCS/N 28R-7931234N2873LShelton Brad · Wildwood, MOBuilt 1979 · S/N 28R-7918188N2873RMitchell Daniel E · Lubbock, TXBuilt 1969 · S/N 28R-35312N2875RLyons Corey · Vinton, OHS/N 28R-35315N2876RTorley Air Service LLC · Colorado Springs, COBuilt 1969 · S/N 28R-35316N2878MCamous Alain E · Sunrise, FLBuilt 1977 · S/N 28R-7803152N2878NRace Ralph D · Brookland, ARS/N 28R-7918194N2878ULundstroem Ulf · Fort Pierce, FLS/N 28R-7918195N2878YBright Sky Aviation Inc · Wilmington, DENon-citizen corporation, flight hours not reportedS/N 28R-7931235N2879CAero Jackson LLC · Bradenton, FLBuilt 1979 · S/N 28R-7931237N2879PHarrison T Mark · Los Angeles, CAS/N 28R-7931238N2879WEvenson Paul S · Grant, MNBuilt 1979 · S/N 28R-7931239N2879YDawson Ronald Dwight Sr · Garland, TXBuilt 1987 · S/N 28R-7931240N287NDSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2000 · S/N 2844036N2880TVuppala Kavya · Springtown, TXBuilt 1972 · S/N 28R-7235151N2881MJones James N · Missoula, MTBuilt 1977 · S/N 28R-7803153N2882RPostlewait Logging Co · Port Allegany, PABuilt 1969 · S/N 28R-35317N2885RArrow Flight LLC · Springfield, VABuilt 1969 · S/N 28R-35318N2887DTwelve Bits LLC · Fort Lauderdale, FLBuilt 1979 · S/N 28R-7918197N2887QAvalon Global Aviation Inc · Lakeland, FLS/N 28R-7918199N2888TValenstein Glenn L · Howards Grove, WIBuilt 1972 · S/N 28R-7235153N2889TRegistered aircraftBuilt 1972 · S/N 28R-7235154N2895CZeira Eldad M · Encinitas, CABuilt 1979 · S/N 28R-7918203N2895DSaylor Edward T III · Mesa, AZS/N 28R-7918204N2895LSam001 LLC · Miami Beach, FLBuilt 1979 · S/N 28R-7918205N2895NSebion Michael I · Westby, WIBuilt 1979 · S/N 28R-7918206N2895TSr Patel LLC · Meadville, PABuilt 1972 · S/N 28R-7235156N2896GCutting Edge Technologies Inc · Golden, COS/N 28R-7931248N2896PN2896p LLC · Wickliffe, OHS/N 28R-7931249N2896RHuseman Adam · Clarinda, IABuilt 1969 · S/N 28R-35322N289NDLoyd Fred Wayne · Rossville, GABuilt 2000 · S/N 2844039N289PAGenn Tx LLC · Farmersville, TXBuilt 2002 · S/N 2844065N28LEGlenn Scott A · Overland Park, KSBuilt 1976 · S/N 28R-7635253N28MCWood Virgil Jay · Sandy, UTS/N 28R-7931271N28SWShiftta LLC · Ramrod Key, FLBuilt 1979 · S/N 28R-7931308N28UPStoddard Donald W · Great Falls, MTBuilt 1973 · S/N 28R7335386N29021Kough Brian R · Plant City, FLBuilt 1979 · S/N 28R-7918133N29027Cb Aerosports Inc · Charlotte, NCS/N 28R-7931188N2903TDragonguard LLC · Lake City, FLBuilt 1979 · S/N 28R-7918209N2904AFlight Unlimited Inc · Riverview, MIBuilt 1979 · S/N 28R-7918212N2904CKempton Larry G Jr · Grand Junction, COS/N 28R-7931250N2907RFricks Cline Thomas Jr · Toccoa, GABuilt 1969 · S/N 28R-35324N2911PHayes Gregory S · Edinboro, PABuilt 1979 · S/N 28R-7918216
Back to AD 82-06-11 R1