OpenAirDocs.org
AD 79-13-01

Registered aircraft · 109

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:79-13-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:79-13-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.

N1026BBazler Jack A Trustee · Boulder, COBuilt 1956 · S/N LH-163N107WSByers Mike L · Vista, CABuilt 1959 · S/N GH-107N117WBHicks Jacob · Crozet, VABuilt 1960 · S/N DH-275N120RDDecesare George D · Danville, CABuilt 1956 · S/N DH-89N1235MRoan Christopher J · Jefferson, SDS/N DH-142N123TCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1962 · S/N DH-339N12FHR&B Leasing And Finance LLC · Fresno, CABuilt 1956 · S/N DH-63N134TBKbld LLC · Buchanan, MIS/N HH-126N1421GGomez Vecslir Martin L · Redwood City, CABuilt 1962 · S/N DH-333N144LHPaul John R · Hamilton, MTS/N RLH14N146RAerospatiale LLC · Selah, WAS/N HH-145N14VUBeechcraft Heritage Museum Inc · Tullahoma, TNBuilt 1962 · S/N DH-326N154LHPaul John R · Hamilton, MTS/N LH154N154NWoods John · Eagle River, AKBuilt 1955 · S/N CH-333N155PAllman Air LLC · Blackstone, VABuilt 1956 · S/N DH-76N15PCollins Jeffery S · Griffin, GABuilt 1956 · S/N DH-92N15PHBindon Phil E · Wasilla, AKBuilt 1958 · S/N RLH-20N1600GBrown David · Bell Buckle, TNBuilt 1959 · S/N DH-211N160LTodd Victor E · London Mills, ILBuilt 1958 · S/N DH-201N1959TPhantom Phlyers LLC · Pearland, TXBuilt 1959 · S/N DH-209N1961Buttram John R · Panama City, FLS/N DH318N1DUPittsburgh Institute Of Aeronautics · West Mifflin, PABuilt 1960 · S/N DH-262N207AFFlying Burros Air Trucking Co · Wilmington, DEBuilt 1955 · S/N CH-144N212GBailey Orin A · Homedale, IDBuilt 1955 · S/N CH-331N213DBall Frederick C · Harbor Springs, MIBuilt 1955 · S/N CH-192N220DSChagrin Valley Biplanes LLC · Chagrin Falls, OHBuilt 1960 · S/N DH-271N2240Twin Bonanza LLC · Meridian, IDBuilt 1956 · S/N DH-35N225BWRegistered aircraftBuilt 1961 · S/N DH-325N225TWWallitner Aviation And Restoration LLC · Port Orchard, WABuilt 1959 · S/N DH-219N227DSL & P Air LLC · Lees Summit, MOBuilt 1957 · S/N FH-74N234HWestphal Ronald R · Aurora, ILBuilt 1954 · S/N CH-133N2400ZDerr Douglas N · Woodlands, TXBuilt 1957 · S/N DH-137N261BWinnie Mae Inc · Tallahassee, FLBuilt 1957 · S/N DH-134N270Young Aviation LLC · Panama City, FLBuilt 1961 · S/N DH-308N2755GOnderdonk Allyn K · Mills River, NCBuilt 1957 · S/N 57-6043N28ECZefting Aviation LLC · Bellingham, WABuilt 1960 · S/N DH-285N295DEFly Direct LLC · La Porte, INBuilt 1956 · S/N DH-88N29YPeters Duane A · Anchorage, AKS/N EH-16N30AEKetting Case H · College Place, WABuilt 1962 · S/N JH-167N311DDSierra Aeronautics LLC · Gambier, OHBuilt 1960 · S/N DH-311N3274MPittsburgh Institute Of Aeronautics · West Mifflin, PAS/N 57-6061N3280ZPittsburgh Inst Of Aeronautics · W Mifflin, PAS/N 57-6080N333BQQualitair LLC Trustee · MichelstadtBuilt 1960 · S/N DH-250N3564BMach 4 Missions · Middleton, TNBuilt 1954 · S/N CH-114N356TRegistered aircraftBuilt 1960 · S/N DH-270N35MCWallace James W · Elkins, WVBuilt 1955 · S/N CH-177N360KRRyans Float Flying LLC · Oregon City, ORBuilt 1961 · S/N DH-320N3653BPlacebo Air LLC · Ridgecrest, CABuilt 1954 · S/N CH-128N3722BRui C LLC · Reddick, FLBuilt 1955 · S/N CH-152N3743BPittsburgh Institute Of Aeronautics · West Mifflin, PABuilt 1955 · S/N CH-169
Back to AD 79-13-01