SDR AALA991864

Service difficulty report · Frame · Boeing 727223

Difficulty date
December 6, 1999
Submitted
March 26, 2000
Operation
Air carrier
Aircraft
N864AA
Make and model
Boeing 727223
Aircraft serial
21369
Part
Frame
Condition
Cracked
Location
Bs 783.95
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

TUL - STATION 783.95 RIGHT FRAME CRACKED LT BOTTOM INBOARD AFT SIDE RADIUS APPROX RBL 65 AT 6 INCHES BELOW FLOOR CRACK 1.5 INCH LONG. REPAIRED CRACKED FRAME PER SB 727-53-0197. (M)

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.

Query with SQL
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 ('AALA991864') 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.