AD 83-22-06

Registered aircraft · 11,722

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:83-22-06')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:83-22-06')
  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.

N115CFFlying C Leasing · Wilmington, DES/N 15283557N115SSSoutheastern Oklahoma State University · Durant, OKBuilt 1979 · S/N 15283679N1163FMid-Tenn Aero Club Inc · Franklin, TNBuilt 1979 · S/N 17272962N1166VClark John A · Windsor, CABuilt 1976 · S/N R1722130N1167VBoard David N · Woodsfield, OHBuilt 1976 · S/N R1722131N1168VGood Guys Flying Club LLC · Colorado Springs, COBuilt 1976 · S/N R1722132N1169QRohde Allen G · Eagle River, AKBuilt 1977 · S/N 18503466N116AHRegistered aircraftBuilt 1981 · S/N 18267966N116FPRandall David J · Balsam Lake, WIBuilt 1978 · S/N 17271241N116HRRedpaw Aviation Ltd · Upper Arlington, OHBuilt 1986 · S/N 18268579N116SUBoolean Flight Sciences LLC · Mercer Island, WAS/N 18266668N1170VPadgett Keith A · Bow, WABuilt 1976 · S/N R1722134N117ABHellickson Brad · Corona, CAS/N 17271253N117JBGenerations Flying Club LLC · Washington, MOBuilt 1978 · S/N 17270644N117PBLadue Scott B · Fate, TXBuilt 1981 · S/N 172RG0897N117PHR & R Leasing LLC · Fargo, NDBuilt 1977 · S/N 18265492N117RCMaresh Jeremiah · Redding, CAS/N 172RG0034N117TTMustang LLC · Wilsonville, ORFirst renewal noticeBuilt 1978 · S/N 18266432N117WTFly Whiskey Tango LLC · Scottsdale, AZBuilt 1984 · S/N 17276264N1185FClements Michael R · Gig Harbor, WABuilt 1979 · S/N 17272963N1188NLll Aviation LLC · Durango, COBuilt 1978 · S/N R18200538N11896Mcginty Flying Service LLC · Jones, LABuilt 1977 · S/N 18052921N118ARegistration Pending · Shasta, CARegistration pendingBuilt 1977 · S/N 18503339N118HRDieschbourg Thomas Arthur · Glenview, ILBuilt 1983 · S/N 18268332N118PCCarenbauer Paul J · Hernando, FLBuilt 1976 · S/N 17268427N118SCLeathers Charles M · Silverthorne, COBuilt 1981 · S/N 18268069N118SGWilt Jared · Gardners, PABuilt 1977 · S/N R18200115N1193FVoss Douglas D · Grand Island, NEBuilt 1979 · S/N 17272964N1196DAerobat Aoa LLC · Wilmington, DES/N A1520764N1197FSchumacher Bradley M · Lewiston, IDBuilt 1975 · S/N 18502763N1197VVentry Solutions Inc · Hauser, IDBuilt 1976 · S/N R1722137N119DCDuque Helen · Orlando, FLS/N 17267722N119DSDeltasierra LLC · Staunton, VABuilt 1979 · S/N 18503735N119FRJeffery & Weiss Holdings LLC · Long Beach, CAS/N 17276535N11ATChan Roger J · Anchorage, AKBuilt 1974 · S/N 18502547N11CSilicz Nicholas J · Shafter, CABuilt 1975 · S/N 18502713N11CEMelcher Pierre S · New Braunfels, TXBuilt 1974 · S/N 18502512N11DHRegistered aircraftBuilt 1978 · S/N 18052974N11MBYoungstown Warren Development Partners · Youngstown, OHBuilt 1979 · S/N 17272769N11VYPritt Brian C · San Luis Obispo, CABuilt 1979 · S/N 18267086N11YJCrawley Frederick J · Virginia City, NVS/N 182-66498N1200USowers Harry D · S Bloomingvle, OHBuilt 1978 · S/N 17272035N1201FRed Door Aviation LLC · Dover, DEBuilt 1979 · S/N 17272966N1203FRawson Aviation LLC · Collinsville, OKBuilt 1979 · S/N 17272968N1204FMoroney Aviation LLC · Chugiak, AKBuilt 1975 · S/N 18502767N1206FHarrah Daniel R · Juneau, AKBuilt 1975 · S/N 18502769N1208FYukon Air Service Inc · Fairbanks, AKBuilt 1975 · S/N 18502771N1211FGarner Greg A · Renton, WABuilt 1975 · S/N 18502774N1213FFlight Answers LLC · Miami Lakes, FLBuilt 1979 · S/N 17272972N1216VKingdom Air Corps Inc · Sutton, AKBuilt 1976 · S/N R1722143
Back to AD 83-22-06