OpenAirDocs.org
AD 2000-24-21

Registered aircraft · 225

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

N100LMHaddock Flying Service Inc · Salters, SCS/N 1583N10195Deuchar Hillary · Brookings, ORS/N 562N10196Porter Kelton B · Homer, AKBuilt 1960 · S/N 340N1023GContinental Title Trust LLC Trustee · Wichita, KSBuilt 1953 · S/N 51-16307N102BBNester Randal K · Seguin, TXBuilt 1959 · S/N 1107N103JAJoann Air Inc · Mulberry, FLS/N 782N1042CRmi Air LLC · Ocilla, GAS/N 846N1048PAviation Solution Experts LLC · St Marys, IAS/N 635N104HHHaddock Flying Service Inc · Salters, SCBuilt 1960 · S/N 2062N105HHHaddock Flying Service Inc · Salters, SCS/N 1307N106HHHaddock Flying Service Inc · Salters, SCS/N 1375N10728Henricks C John · Lebanon, ORBuilt 1956 · S/N 798N112BKFordyce Joel M · Gaston, ORBuilt 1957 · S/N 862N1151LClassic Helicopters LLC · Choteau, MTBuilt 1960 · S/N 1233N119NRSlikker Flying Service Inc · Buttonwillow, CABuilt 1966 · S/N 1472N11CUPockrus Pat B · Mineral Wells, TXBuilt 1957 · S/N 983N129HAHiller Aircraft Corp · Firebaugh, CABuilt 1975 · S/N HA3029N12UHJstream Lc · Sheridan, WYBuilt 1962 · S/N 1395N130HAC&C Helicopters Inc · Kuna, IDS/N HA3030N132HASky Copters Inc · Westmoreland, KSBuilt 1975 · S/N HA3032N133HAHanson Leasing Inc · Bad Axe, MIBuilt 1976 · S/N HA3033N133WHFour Creeks Aviation Inc · Visalia, CABuilt 1973 · S/N 1788N1348PCarey James D · Winterset, IAS/N 892N1348XPockrus Pat B · Mineral Wells, TXBuilt 1957 · S/N 901N1348ZPockrus Pat B · Mineral Wells, TXBuilt 1958 · S/N 1043N1349ALyle Daniel · Westmoreland, KSS/N 2035N139HAKnutson Flying Service Inc · Tioga, NDBuilt 1976 · S/N HA3039N144HABank Of Utah Trustee · Salt Lake City, UTBuilt 1976 · S/N HA3044N14637Fort Wolters Helicopter Inc · Mineral Wells, TXBuilt 1993 · S/N 1577N146ETFour Creeks Aviation Inc · Visalia, CABuilt 1976 · S/N HA3046N14MQFort W0lters Helicopter Inc · Mineral Wells, TXBuilt 1961 · S/N 1474N1512EFort Wolters Helicopters · Mineral Wells, TXBuilt 1965 · S/N 1792N1523TBartlett Robert E · Cleveland, TXBuilt 1964 · S/N 1740N156PTWiger Theodore L · Falcon Heights, MNBuilt 1956 · S/N 851N162DLLewkowicz Augusto D · Fort Lauderdale, FLS/N 224N162MCosta James Joseph · Tulare, CABuilt 1962 · S/N 238N16643Koch Kasey E · Bigfork, MTBuilt 1952 · S/N 346N16NRParagon Helicopter Services LLC · Claremore, OKBuilt 1964 · S/N 1755N172SMSedeyn Thomas Sr · Salem, NJBuilt 1950 · S/N 317N173SJAnthony Ghidossi Chemical LLC · Marysville, WABuilt 1981 · S/N 5170N175HAShearer John · The Dalles, ORBuilt 1978 · S/N HA3075N17MQPan Bar Aviation Inc · Pittsburgh, PAS/N 787N180HAAmbrosini Helicopters Inc · Fresno, CABuilt 1980 · S/N HA3080N196FTContinental Title Trust LLC Trustee · Wichita, KSBuilt 1962 · S/N 1364N2068VFort Wolters Helicopter Inc · Mineral Wells, TXS/N 5107N212WInternational Air Services Inc Trustee · Carson City, NVS/N 237N222TEFranke Darren · Yorktown, TXBuilt 1955 · S/N 802N225REMoonshadow Aviation Inc · Wilmington, DES/N DLW3N2275MBorszich Claude C Jr · Phoenix, AZBuilt 1961 · S/N 1305N22SPParagon Helicopter Services LLC · Claremore, OKBuilt 1959 · S/N 1214
Back to AD 2000-24-21