Aerostar International S-49A airworthiness directives

Aircraft by year built · 13

1995Registered nowDeregistered2026

Aircraft by the year they were built: 13 aircraft
1995	4
1996	4
1997	3
1999	1
2000	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 S-49A

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 ('7484050'))
  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 ('7484050'))
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 S-49A

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 ('7484050'))
  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 ('7484050'))
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 · 14

N40976Kuller Timothy D · Mesa, AZS/N S49A-3209 N52098Fournier Douglas J J · Abilene, TXBuilt 1999 · S/N S49A-3214 N5287JHicks Albert B Jr · Griffin, GAS/N S49A-3216 N62CTBrossett Gary M · Columbus, GAS/N S49A-3210 N7099HMichigan Hot Air Adventures · Howell, MIBuilt 1995 · S/N S49A-3198 N7099UUrbanovsky Michael R · Statesboro, GAS/N S49A-3199 N7134SNilz Patrick S · Marana, AZBuilt 1995 · S/N S49A-3202 N71459Hanson Gregory K · De Witt, IABuilt 1996 · S/N S49A-3203 N7146CLesmeister Michael A · Rochester, MNS/N S49A-3204 N7158ZLighter Than Air America · Boise, IDBuilt 1996 · S/N S49A-3206 N7169SAir Hound Adventures LLC · Davenport, FLS/N S49A-3207 N7174RWicked Balloons Inc · Worcester, MAS/N S49A-3208 N9066NTscc Services LLC · Frisco, TXBuilt 1997 · S/N S49A-3211 N9142NJones Janell · Grass Valley, CAS/N S49A-3213

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 ('7484050')
  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 ('7484050')
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

No NTSB investigations matched to aircraft with this modelMatched through the registry by N-number, so foreign aircraft and some older cases aren’t counted.

FAA incident reports

No reports matched to aircraft of this modelMatched through the registry by N-number, so foreign aircraft and some older reports aren’t counted.

Service difficulty reports

No reports name this modelGeneral aviation reporting is voluntary.

STCs that may be installed · 8

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 SB09657RCInstallation of Aircraft Position LightsAlbuquerque Balloon Center, Inc.STC SB04407ATInstallation of the DBI-III OmegaBalloonacy, Ltd. LLC STC SB03363CHReplace the Aerostar basket, burner & fuel tanks; with Lindstrand basket, burner & fuel tanksCameron Balloons US STC SB917GLAddition of a refueling adapter to the main fuel line.LTA Aviation Inc STC SB00713LAInstallation of one additional 10 gallon propane tank.John Terry STC SB00407LAInstallation of foam padded tank covers.John Terry STC SA5469NMInstallation of position light.Great American Balloon Co Inc

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 ('7484050') 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 ('7484050')
    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 ('7484050')
  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 · 12

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-52437Skirt S49ASuperiAire Technologies · PMA PQ1047SW · Replaces P/N 52437 · Sep 10, 2014 P/N SAT-52486Skirt Dipper ELS/ELSS, S49A/S51H/S53ASuperiAire Technologies · PMA PQ1047SW · Replaces P/N 52486 · Sep 10, 2014 P/N SAT-53089Skirt Dipper S49A/S51A/S53A CW/RWSWSuperiAire Technologies · PMA PQ1047SW · Replaces P/N 53089 · Sep 10, 2014 P/N SAT-52940Deflation Panel S49A/S51A ParachuteSuperiAire Technologies · PMA PQ1047SW · Replaces P/N 52940 · Sep 10, 2014 ARP52873Cable Set, 4PT, S-49A/S-51A/S-53A, A-Blk Steel [CW]Balloonacy ltd LLC · PMA PQ4173CE · Replaces 52873 · Jul 7, 2013 ARP52872Cable Set, 4PT, S-49A/ S-51A/S-53A, A-Blk Kevlar [CW]Balloonacy ltd LLC · PMA PQ4173CE · Replaces 52872 · Jul 7, 2013 ARP52824-6Cable Pair A, 4 point, S49A/S51A/S53A, Caribiner/Kevlar SuspBalloonacy ltd LLC · PMA PQ4173CE · Replaces 52824-6 · Jan 24, 2013 All parts noted on John Terry Master Drawing List TAB00110 Gallon Propane TankTerry Associates · Modification part · Nov 6, 2000 All parts noted on John Terry Master Drawing List TCC 001 as listed on Approved Model List SB00408LATank CoverTerry Associates · Modification part · Nov 6, 2000 All parts noted on MDL TCC 001 as listed on AML No. SB00408LATank CoverTerry Associates - Aerostatic Engineering · Modification part · Sep 2, 1997 RP113Replacement PanelCustom Nine Designs Inc · Replaces D-52049 Gores 1-16 Station 8-68.5 · Oct 5, 1994 Dwg 100-01Refueling AdaptorBalloons Unlimited of Wis Inc · Modification part · Dec 12, 1993

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-49A'])) > 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-49A'])) > 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 RAVEN S49A89 registered aircraftRegistry code 7484049

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 = 'S49A' AND m.code NOT IN ('7484050')
  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 = 'S49A' AND m.code NOT IN ('7484050')
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.