Lockheed 1049H-82 airworthiness directives

Aircraft by year built · 14

1954Registered nowDeregistered2026

Aircraft by the year they were built: 14 aircraft
1954	1
1956	2
1957	6
1958	4
1959	1

Airworthiness directives that may apply · 28

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

1961In forceSuperseded2026

ADs by the year they took effect: 18 ADs
1961	3
1962	2
1963	2
1964	3
1965	2
1967	1
1971	1
1993	1
1996	1
2023	1
2026	1

Airframe · Lockheed 1049H-82

AD 2026-13-02NavigationEffective Jul 1, 2026 AD 2023-10-02Indicating/Recording System, NavigationEffective May 26, 2023 · Supersedes AD 2021-23-12 AD 93-14-12Crewmember Protective Breathing Equipment UnitsEffective Sep 2, 1993

See all 29 ADs

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 ('5262121'))
  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 ('5262121'))
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.

Registered aircraft · 1

N6937CSuper Connie LLC · Jacksonville, FLBuilt 1959 · S/N 4830

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 ('5262121')
  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 ('5262121')
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.

STCs approved for this model · 10

STC SA01967WI (2 OF3)Use of GAMI G100UL High Octane Unleaded AvgasGeneral Aviation Modifications Inc.STC SA1413WEInstallation of an Edo Model 345 Loran System.Flying Tiger Line Inc STC SA1414WEInstallation of a Collins 621A-3 ATC transponder system.Flying Tiger Line Inc STC SA1843WEInstallation of RCA AVQ-50 weather radar with McMillan 7161X radome and Collins 37P-4 glide slope antenna.Flying Tiger Line Inc STC SA4-896Incorporate F.T.L. engineering order no 4517-8 dated 8/10/59 to provide for the use of solid cargo loading in the 1049-H aircraftFlying Tiger Line Inc STC SA629WEInstallation of a single Collins Model 860E-1.Flying Tiger Line Inc STC SA715WEInstallation of single Collins Model 860E-1 Distance Measuring Equipment System.Flying Tiger Line Inc STC SA718WEInterior installation.Flying Tiger Line Inc STC ST00340WIApproval for operation with the right rear door removed and left rear door open.SAVE A CONNIE, Inc STC ST489SOInstallation of cargo restraining bulkhead.Aeronautical Engineers, Inc

Query with SQL

duckdb -csv -c "SELECT s.stc_number, s.description, s.holder, s.status, s.status_date
  FROM 'https://openairdocs.org/data/latest/faa_stc.parquet' s
  WHERE s.stc_number IN (SELECT stc_number FROM 'https://openairdocs.org/data/latest/faa_stc_model.parquet' WHERE model_key = '1049H82')
  ORDER BY s.status = 'Current' 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
FROM 'https://openairdocs.org/data/latest/faa_stc.parquet' s
WHERE s.stc_number IN (SELECT stc_number FROM 'https://openairdocs.org/data/latest/faa_stc_model.parquet' WHERE model_key = '1049H82')
ORDER BY s.status = 'Current' 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.

NTSB investigations · 3

Aircraft matched to this model through the registry, by N-number and event date.

NTSB DCA80AA020Accident · 3 fatalClosedLockheed 1049H · Columbus, INJun 22, 1980 · N74CA · Destroyed NTSB OAK67O0061Accident · No injuriesClosedLockheed 1049H · Da Nang, VMFeb 10, 1967 · N6924C · Substantial damage NTSB UNK63X0102Accident · 4 fatalClosedLockheed 1049H · San Francisco, CAFeb 3, 1963 · N9740Z · Destroyed

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 ('5262121') 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 ('5262121')
  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 ('5262121')
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 · 1

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

Incident 19960727027239ILkheed 1049H82 · St Paul, MNNarrative: on July 27, 1996 at 1830 gmt, a Lockheed 1049H super constellation, was being piloted by PIC christopher j. clark ii-atp #000210440, and SIC richard c. mcmahon-atp#001131794. During landing, the aircraft veered off the runway to the left and…Jul 27, 1996 · N6937C · Minor damage

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 ('5262121')
  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 ('5262121')
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 · 1

SDR 96ZZZX4134Valve · defectiveDURING LANDING AFTER FLY-BY DEMONSTRATION, ACFT VEERED OFF THE RUNWAY TO THE LEFT AND COMPLETED ROLL-OUT IN THE GRASS. AIRCRAFT WAS ABLE TO TAXI TO DISPLAY/TIE-DOWN AREA WITHOUT FURTHER INCIDENT. FIELD INVESTIGATION REVEALED THE NOSE GEAR STEERING VALVE PRESEJul 27, 1996 · N6937C · Lkheed 1049H82 · Landing Gear Steering System

Query with SQL

duckdb -csv -c "SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy
  FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet'
  WHERE aircraft_model_key = '1049H82'
  ORDER BY difficulty_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 sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy
FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet'
WHERE aircraft_model_key = '1049H82'
ORDER BY difficulty_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.