SDR 96UAL900277

Service difficulty report · Slide Packboard · Boeing 747422

Difficulty date: April 24, 1996
Submitted: March 26, 2000
Operation: Air carrier
Aircraft: N173UA
Make and model: Boeing 747422
Aircraft serial: 24380
Engine: Pwa PW4056
System (JASC): 2565 · Escape Slide
Part: Slide Packboard
Part number: 7A1338104
Condition: Damaged
Location: Upper Ddeck
Component: Bf Goodrich · 7A1323107
Stage of operation: IN
Nature of condition: O
Precautionary procedure: K

As reported to the FAA. Reports are unverified, and codes are left as the FAA publishes them.

What was found

STRETCHED UPPER DECK EVACUATION SLIDE INADVERTANTLY DEPLOYED. DURING DEPLOYMENT, SLIDE PACKBOARD WAS DAMAGED. PACKBOARD DAMAGE. SLIDE REPLACED, AND REMOVED SLIDE WAS REPAIRED AND MODIFIED PER BFG S/B 25-266.

Service documents this report cites · 1

Manufacturers’ service documents named in its text, as OpenAirDocs read them: check each against the text. “Copy” marks those OpenAirDocs holds.

Goodrich SB 25-266

Query with SQL

SELECT d.issuer, d.type_label, d.number, c.revision, c.revision_date, c.cited_as, c.incorporated_by_reference, c.in_regulatory_text, 'https://openairdocs.org/service-documents/' || d.document_id AS page_url FROM 'https://openairdocs.org/data/latest/service_document_citation.parquet' c JOIN 'https://openairdocs.org/data/latest/service_document.parquet' d USING (document_id) WHERE c.record_type = 'faa_service_difficulty_report' AND c.record_id IN ('96UAL900277') AND d.issuer_kind <> 'authority' QUALIFY row_number() OVER (PARTITION BY c.document_id, c.revision_key ORDER BY c.record_date DESC) = 1 ORDER BY c.incorporated_by_reference DESC, c.in_regulatory_text DESC, d.document_id, c.revision_key

duckdb -csv -c "SELECT d.issuer, d.type_label, d.number, c.revision, c.revision_date, c.cited_as, c.incorporated_by_reference, c.in_regulatory_text,
    'https://openairdocs.org/service-documents/' || d.document_id AS page_url
  FROM 'https://openairdocs.org/data/latest/service_document_citation.parquet' c JOIN 'https://openairdocs.org/data/latest/service_document.parquet' d USING (document_id)
  WHERE c.record_type = 'faa_service_difficulty_report' AND c.record_id IN ('96UAL900277') AND d.issuer_kind <> 'authority'
  QUALIFY row_number() OVER (PARTITION BY c.document_id, c.revision_key ORDER BY c.record_date DESC) = 1
  ORDER BY c.incorporated_by_reference DESC, c.in_regulatory_text DESC, d.document_id, c.revision_key"

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.issuer, d.type_label, d.number, c.revision, c.revision_date, c.cited_as, c.incorporated_by_reference, c.in_regulatory_text,
  'https://openairdocs.org/service-documents/' || d.document_id AS page_url
FROM 'https://openairdocs.org/data/latest/service_document_citation.parquet' c JOIN 'https://openairdocs.org/data/latest/service_document.parquet' d USING (document_id)
WHERE c.record_type = 'faa_service_difficulty_report' AND c.record_id IN ('96UAL900277') AND d.issuer_kind <> 'authority'
QUALIFY row_number() OVER (PARTITION BY c.document_id, c.revision_key ORDER BY c.record_date DESC) = 1
ORDER BY c.incorporated_by_reference DESC, c.in_regulatory_text DESC, d.document_id, c.revision_key

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.