Aerostar International RAVEN S57-A airworthiness directives

Aircraft by year built · 115

1987Registered nowDeregistered2026

Aircraft by the year they were built: 115 aircraft
1987	20
1988	20
1989	19
1990	14
1991	6
1992	11
1993	7
1994	11
1995	6
1996	1

Airworthiness directives that may apply · 3

ADs whose products match this airframe model. Each AD’s applicability may narrow it by serial number, part number or configuration.

1991In forceSuperseded2026

ADs by the year they took effect: 3 ADs
1991	1
1993	1
2013	1

Airframe · Aerostar International RAVEN S57-A

AD 2013-03-10HardwareEffective Mar 19, 2013 AD 93-16-13Fuel HoseEffective Oct 15, 1993 AD 90-25-09Suspension CablesEffective Jan 14, 1991

Query with SQL

duckdb -csv -c "SELECT d.ad_number, d.status, d.subject, d.effective_date
  FROM 'https://openairdocs.org/data/latest/faa_directive.parquet' d
  WHERE d.ad_id IN (SELECT ad_id FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE aircraft_model_code IN ('7485057'))
  ORDER BY coalesce(d.effective_date, d.publication_date, d.issue_date) DESC, d.ad_number DESC"

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.

SELECT d.ad_number, d.status, d.subject, d.effective_date
FROM 'https://openairdocs.org/data/latest/faa_directive.parquet' d
WHERE d.ad_id IN (SELECT ad_id FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE aircraft_model_code IN ('7485057'))
ORDER BY coalesce(d.effective_date, d.publication_date, d.issue_date) DESC, d.ad_number DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

Information bulletins that may apply · 1

Airframe · Aerostar International RAVEN S57-A

SAIB CE-11-44Fuel: Cylinder Strap InstallationIssued Jul 13, 2011

Query with SQL

duckdb -csv -c "SELECT s.saib_number, any_value(s.title) AS title, max(s.issue_date) AS issue_date, any_value(s.status) AS status
  FROM 'https://openairdocs.org/data/latest/faa_saib.parquet' s
  WHERE s.saib_id IN (SELECT saib_id FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_saib.parquet' WHERE aircraft_model_code IN ('7485057'))
  GROUP BY s.saib_number ORDER BY issue_date DESC"

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.

SELECT s.saib_number, any_value(s.title) AS title, max(s.issue_date) AS issue_date, any_value(s.status) AS status
FROM 'https://openairdocs.org/data/latest/faa_saib.parquet' s
WHERE s.saib_id IN (SELECT saib_id FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_saib.parquet' WHERE aircraft_model_code IN ('7485057'))
GROUP BY s.saib_number ORDER BY issue_date DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

Registered aircraft · 38

N155KSproul Keith A · North Brunswick, NJBuilt 1994 · S/N S57A-3161 N35844Krause Shawn L · Zachary, LAS/N S57A-3095 N3584GBalloonacy LLC · Fayetteville, GABuilt 1990 · S/N S57A-3094

See all 38 registered aircraft

Query with SQL

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN ('7485057')
  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.

SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN ('7485057')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB investigations · 9

Aircraft matched to this model through the registry, by N-number and event date, checked against the reported serial number, make and model.

Defining event, 2008 on

Cabin safety event1 case

Of 1 case NTSB coded with a defining event. All defining events

In the probable cause, 2008 on

Findings NTSB made part of the probable cause. A case can have several. All findings

First occurrence, 1982 to 2007

Of 7 cases with NTSB’s older coding, defined in its coding manual.

NTSB CEN10CA257Accident · Serious injuriesData collectionFinal reportAerostar International S57A · Hilliard, OHThe passenger’s inadequate brace for the balloon landing, resulting in injury.May 15, 2010 · N9002Z · No damage NTSB DEN06LA002Accident · No injuriesLimited investigationFinal reportAerostar S57-A · Albuquerque, NMthe pilot's improper in flight planning decision to takeoff and land (splash and dash) in close proximity to trees. Contributing factors are the trees and the water.Oct 8, 2005 · N3635U · Substantial damage NTSB FTW02LA014Accident · Serious injuriesLimited investigationFinal reportAerostar Raven S57-A · Albuquerque, NMinadvertent flight into adverse (high wind) weather conditions, which resulted in an inflight collision with objects while landing. A contributing factor was the high wind weather condition.Oct 13, 2001 · N3636Z · Substantial damage NTSB MIA00LA179Accident · No injuriesLimited investigationFinal reportAerostar S57-A · Windermere, FLan in-flight collision with a tree. A factor in this accident was high wind conditions.May 26, 2000 · N6341V · Substantial damage NTSB CHI00LA023Accident · Serious injuriesLimited investigationFinal reportAerostar Raven S57-A · Imperial, MOthe passenger's failure to follow instructions on how to properly brace for the landing.Nov 7, 1999 · N9130F · No damage NTSB CHI96LA043Accident · Serious injuriesLimited investigationFinal reportAerostar Raven S57-A · Stark, KSthe pilot's failure to follow emergency procedures. A factor was the weather condition.Nov 25, 1995 · N7019G · No damage NTSB CHI91LA244Accident · No injuriesLimited investigationFinal reportAerostar Raven 557A · Indianola, IAFailure of the pilot to maintain altitude. Factors associated with the accident are complacency and diverted attention.Aug 4, 1991 · N3621X · Substantial damage NTSB DEN91LA100Accident · Minor injuriesLimited investigationFinal reportAerostar S57-A · Avon, COThe pilot's failure to maintain a visual lookout. A factor was: the pilot's attention being diverted.Jul 14, 1991 · N57053 · Substantial damage NTSB FTW80IA013Incident · No injuriesClosedAerospatle AS350D · Mansfield, TXNov 14, 1979 · N3596Z · No damage

Query with SQL

SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey WHERE a.aircraft_model_code IN ('7485057') ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

duckdb -csv -c "SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url
  FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
  WHERE a.aircraft_model_code IN ('7485057')
  ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"

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.

SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url
FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.aircraft_model_code IN ('7485057')
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

FAA incident reports · 16

Matched to this model through the registry, by N-number and event date, checked against the reported make and model.

Incident 20171007016359IAerostar International Raven S57-A · Albuquerque, NMOn 07 October 2017, a lta balllon, N155K, an Aerostar International Inc/raven S57-A, attempted to land in an Albuquerque police department parking lot (GPS coordinates: N35.136714, W106.636541). The balloon first touched down on the roof of an unoccupied,…Oct 7, 2017 · N155K · No damage Accident 20100515034259AAerostar IN Raven S57-A · Hilliard, OHOn may 15, 2010, timmy f. hampton, certificate number 2808053, was the pilot of the balloon, N9002Z. He stated that he met with the passengers at 1815 local time. The passengers were [privacy data omitted], and [privacy data omitted]. The launch was…May 15, 2010 · N9002Z · No damage Incident 20070518016649IRaven S57A · Baltimore, MD(-23) On 5/18/2007, at approximately 8:00 pm, the pilot [privacy data omitted] was in the process of taking his balloon down during a balloon glow at the Baltimore inner harbour when he experienced a strong down draft. The balloon broke loose from one of its…May 18, 2007 · N6588L · Minor damage

See all 16 incident reports

Query with SQL

duckdb -csv -c "SELECT report_number, event_date, event_type, city, state, aircraft_make, aircraft_model, aircraft_damage, fatal_injuries, n_number
  FROM 'https://openairdocs.org/data/latest/faa_incident_report.parquet'
  WHERE aircraft_model_code IN ('7485057')
  ORDER BY event_date DESC, report_number DESC"

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.

SELECT report_number, event_date, event_type, city, state, aircraft_make, aircraft_model, aircraft_damage, fatal_injuries, n_number
FROM 'https://openairdocs.org/data/latest/faa_incident_report.parquet'
WHERE aircraft_model_code IN ('7485057')
ORDER BY event_date DESC, report_number DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

Service difficulty reports

No reports name this modelGeneral aviation reporting is voluntary.

STCs that may be installed · 17

Approved for this model: the STC’s model list names it on its data sheet, or a series that includes it. The registry doesn’t record which STCs an aircraft has.

STC SB10564SCInstallation of Night Position LightsHighland Balloon Repair, CRS NHMD682X STC SB01030CHReplace Aerostar Basket/BurnerFuel Tanks with a Cameron Balloons Ltd. (Thunder & Colt) Basket/Burner/Fuel TanksBalloonacy LLC STC SB146CHReplace Aerostar Basket/Burner with a Cameron Basket/BurnerBalloonacy LLC

See all 17 STCs

Query with SQL

SELECT s.stc_number, s.description, s.holder, s.status, s.status_date, m.matched_model FROM ( SELECT stc_number, min(matched_model) AS matched_model FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_stc.parquet' WHERE aircraft_model_code IN ('7485057') GROUP BY stc_number ) m JOIN 'https://openairdocs.org/data/latest/faa_stc.parquet' s USING (stc_number) ORDER BY s.status = 'Current' DESC, s.status_date DESC, s.stc_number

duckdb -csv -c "SELECT s.stc_number, s.description, s.holder, s.status, s.status_date, m.matched_model
  FROM (
    SELECT stc_number, min(matched_model) AS matched_model
    FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_stc.parquet'
    WHERE aircraft_model_code IN ('7485057')
    GROUP BY stc_number
  ) m JOIN 'https://openairdocs.org/data/latest/faa_stc.parquet' s USING (stc_number)
  ORDER BY s.status = 'Current' DESC, s.status_date DESC, s.stc_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.

SELECT s.stc_number, s.description, s.holder, s.status, s.status_date, m.matched_model
FROM (
  SELECT stc_number, min(matched_model) AS matched_model
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_stc.parquet'
  WHERE aircraft_model_code IN ('7485057')
  GROUP BY stc_number
) m JOIN 'https://openairdocs.org/data/latest/faa_stc.parquet' s USING (stc_number)
ORDER BY s.status = 'Current' DESC, s.status_date DESC, s.stc_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

PMA parts · 17

Current parts manufacturer approvals (PMA): parts the FAA has approved companies to make as replacements or modifications. Each record lists its models as free text; OpenAirDocs matched them to this model on its data sheet, so check the FAA record before relying on it. Newest first.

P/N SAT-52544Skirt Dipper S55A/S57A/S60ASuperiAire Technologies · PMA PQ1047SW · Replaces P/N 52544 · Sep 10, 2014 P/N SAT-52954Deflation Panel S55A/S57A/S60A AerochuteSuperiAire Technologies · PMA PQ1047SW · Replaces P/N 52954 · Sep 10, 2014 P/N SAT-52943Deflation Panel S55A/S57A/S60A ParachuteSuperiAire Technologies · PMA PQ1047SW · Replaces P/N 52943 · Sep 10, 2014

See all 17 PMA parts

Query with SQL

duckdb -csv -c "SELECT drs_guid, part_number, part_name, holder, pma_number, replaces_part, supplement_date, tcds_models
  FROM 'https://openairdocs.org/data/latest/faa_type_certificate_pma.parquet'
  WHERE tcds_number IN ('A15CE')
    AND len(list_intersect(tcds_models, ['S-57A'])) > 0
  ORDER BY supplement_date DESC, drs_guid DESC"

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.

SELECT drs_guid, part_number, part_name, holder, pma_number, replaces_part, supplement_date, tcds_models
FROM 'https://openairdocs.org/data/latest/faa_type_certificate_pma.parquet'
WHERE tcds_number IN ('A15CE')
  AND len(list_intersect(tcds_models, ['S-57A'])) > 0
ORDER BY supplement_date DESC, drs_guid DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

The same model under other registry codes

Amateur-built copies and renamed makers get their own codes.

Aerostar International S-57A38 registered aircraftRegistry code 7485001 Fricke Barbara A/Cuneo Peter J S-57A1 registered aircraftRegistry code 05640VJ

Query with SQL

duckdb -csv -c "SELECT m.code, m.manufacturer, m.model, count(g.n_number) AS aircraft
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g ON g.aircraft_model_code = m.code
  WHERE m.match_key = 'S57A' AND m.code NOT IN ('7485057')
  GROUP BY ALL
  ORDER BY aircraft DESC
  LIMIT 12"

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.

SELECT m.code, m.manufacturer, m.model, count(g.n_number) AS aircraft
FROM 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g ON g.aircraft_model_code = m.code
WHERE m.match_key = 'S57A' AND m.code NOT IN ('7485057')
GROUP BY ALL
ORDER BY aircraft DESC
LIMIT 12

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.