OpenAirDocs.org
AD 58-26-01

Registered aircraft · 98

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

N100HTMitchell Brian N · Scottsdale, AZBuilt 2010 · S/N 2N101MFUsda Forest Service Fepp · Trenton, NJBuilt 1957 · S/N 1953N1023VPeterson Chester L · Willis, TXS/N 2021N10BUKitzmiller Douglas A · Punta Gorda, FLBuilt 1953 · S/N 666N10RNExecutive Jet A LLC · Danbury, CTBuilt 1948 · S/N 2229N12220Dixon Craig S · Rimrock, AZBuilt 1958 · S/N 2267N130VJ Bird Air Service LLC · Cheyenne, WYBuilt 1958 · S/N 2230N13298Lidija LLC · Grass Valley, CAS/N 1346N147SMMazar Stephen M · Flushing, MIBuilt 1956 · S/N 1461N15395Magnum Aviation LLC · Goff, KSS/N 2408N17SSDodson Larry A · Lone Oak, TXBuilt 1957 · S/N 1982N18807Swing Wing Inc · Veedersburg, INBuilt 1975 · S/N YH49N200KVPeavy Magnus Delacy IV · Crawfordville, FLBuilt 1960 · S/N 2258N210BL & L Delivery Ltd · Romulus, MIBuilt 1975 · S/N 76N2292BMy Way LLC · Missoula, MTBuilt 1957 · S/N 1972N2490BExperimental Acft Assoc Inc · Oshkosh, WIBuilt 1956 · S/N 1516N2507X4 Star Aviation Inc · Jefferson City, MOS/N 6073N250894 Star Aviation Inc · Jefferson City, MOS/N 6078N2508K4 Star Aviation Inc · Jefferson City, MOS/N 6076N2509F4 Star Aviation Inc · Jefferson City, MOS/N 6080N262MVCavanaugh Charters Inc · Addison, TXBuilt 1958 · S/N 2232N2806BHeliflight Leasing LLC · Bulverde, TXBuilt 1956 · S/N 1490N2807BSuess Robert D · San Jose, CABuilt 1956 · S/N 1495N2817BNew Air Inc · Pocahontas, IABuilt 1956 · S/N 1500N2822BEnglish Air Service LLC · Georgetown, TXBuilt 1956 · S/N 1470N2823BGulf Helicopters LLC · Santa Fe, TXBuilt 1956 · S/N 1471N2838BBlessed Beginnings Broadcasting Inc · Warsaw, INBuilt 1957 · S/N 1424N2861BScotts Helicopter Service Inc · Le Sueur, MNBuilt 1958 · S/N 1436N2870BBell Homer K · Hillsboro, OHBuilt 1957 · S/N 1975N2890BBolton Air Co · Niles, MIBuilt 1957 · S/N 1565N2895BA And S Helicopters Inc · Cahokia, ILBuilt 1957 · S/N 1572N2899BClassic Rotors Museum · Ramona, CAS/N 1999N300JGBamford Virginia J · Woodside, CAS/N 2026N3105GClassic Rotors Museum · Ramona, CABuilt 1958 · S/N 1875N3358FPietron Chad D · Larimore, NDBuilt 1976 · S/N 2497N368GRBetsi Bell Inc · Jacksonville, ARS/N 1258N3755JSpinney Jeffrey James · Flushing, MIBuilt 1958 · S/N 1537N405HHGuardian Aviation LLC · Lakeland, FLS/N 2417N440TGScotts Helicopter Service Inc · Lesueur, MNBuilt 1959 · S/N 2245N4423Matthews Kenneth R · Santo, TXBuilt 1967 · S/N 295N4427PPike Mark D · Victorville, CABuilt 1958 · S/N 2227N444EHJohafe Aviation LLC · Wilmington, DEBuilt 1959 · S/N 2421N4550WNewton Property Leasing LLC · Greene, IABuilt 1960 · S/N 2460N470SBMidwest Choppers LLC · Colman, SDS/N 2254N471BHRocky Mount LLC · Kalispell, MTBuilt 1960 · S/N 2558N4771ZScotts Helicopter Service Inc · Le Sueur, MNS/N 2236N4774CScotts Helicopter Service Inc · Le Sueur, MNS/N 2237N47CSTropicalproperties LLC · Lewes, DEBuilt 1958 · S/N 2255N47GQMccoy Robert M · Barksdale, TXS/N 2196N47HSJames David R · Wayne, MIBuilt 1956 · S/N 883
Back to AD 58-26-01