OpenAirDocs.org
AD 58-02-03

Registered aircraft · 117

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-02-03')
    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-02-03')
  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.

N10195Deuchar Hillary · Brookings, ORS/N 562N10196Porter Kelton B · Homer, AKBuilt 1960 · S/N 340N1023GContinental Title Trust LLC Trustee · Wichita, KSBuilt 1953 · S/N 51-16307N103JAJoann Air Inc · Mulberry, FLS/N 782N1042CRmi Air LLC · Ocilla, GAS/N 846N1048PAviation Solution Experts LLC · St Marys, IAS/N 635N105HHHaddock Flying Service Inc · Salters, SCS/N 1307N106HHHaddock Flying Service Inc · Salters, SCS/N 1375N10728Jstream Lc · Sheridan, WYBuilt 1956 · S/N 798N112BKFordyce Joel M · Gaston, ORBuilt 1957 · S/N 862N11CUPockrus Pat B · Mineral Wells, TXBuilt 1957 · S/N 983N1348PCarey James D · Winterset, IAS/N 892N1348XPockrus Pat B · Mineral Wells, TXBuilt 1957 · S/N 901N1348ZPockrus Pat B · Mineral Wells, TXBuilt 1958 · S/N 1043N156PTWiger 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 346N172SMSedeyn Thomas Sr · Salem, NJBuilt 1950 · S/N 317N17MQPan Bar Aviation Inc · Pittsburgh, PAS/N 787N212WInternational Air Services Inc Trustee · Carson City, NVS/N 237N222TEFranke Darren · Yorktown, TXBuilt 1955 · S/N 802N225REMoonshadow Aviation Inc · Wilmington, DES/N DLW3N239SBSale Reported · Cottage Grove, ORSale reported, pending cancellationBuilt 1956 · S/N 800N245CHansen Christopher H · Durhamville, NYBuilt 1953 · S/N 324N263SSMadden Russell E · Graford, TXS/N 265N26PEMshr Helicopter Service LLC · Chehalis, WAS/N 1327N26USPlane Fun Inc Tr Trustee · Snellville, GABuilt 1957 · S/N 823N2770Lil Dawg Aviation · Wilmington, DES/N 1250N28801Knutson Wayne R · Tioga, NDS/N 1218N307AJSwashbuckle Air LLC · Anchorage, AKBuilt 1952 · S/N 426N3269FYellowjacket Aviation LLC · Wenatchee, WABuilt 1976 · S/N 1144N330MLacy Glenn M · Bedford, VAS/N 287N33616Sale Reported · Lakeland, FLSale reportedBuilt 1955 · S/N 720N374HDreyer Elwain C · Cardington, OHS/N 1374N38763International Air Services Inc Trustee · Carson City, NVS/N 497N38767Pockrus Pat B · Mineral Wells, TXS/N 1037N3877LJarrell Stephen L · Edgewood, NMBuilt 1954 · S/N 674N410NRHaynes Cory W · Heyburn, IDBuilt 1961 · S/N 2244N41319Aspinwall W Frank · Kingsland, GAS/N 433N4254AJames David R · Wayne, MIBuilt 1950 · S/N 229N469DWBishop Thomas W · Decatur, TXBuilt 1956 · S/N 869N47063Geco Inc · Wilmington, DEBuilt 1962 · S/N 1422N47077Knutson Flying Service Inc · Tioga, NDBuilt 1957 · S/N 947N47242Pockrus Pat B · Mineral Wells, TXBuilt 1952 · S/N 491N4733CTaz Air Service Inc · Middletown, DES/N 260N4785CBorszich Claude C Jr · Phoenix, AZBuilt 1952 · S/N 312N493BNStimart Rene D Trustee · Harshaw, WIBuilt 1962 · S/N 1321N4977EWyllie Ashton R J Trustee · Thornton, NHBuilt 1951 · S/N 254N49983Pockrus Pat B · Mineral Wells, TXS/N 850
Back to AD 58-02-03