Service difficulty report · Skin · Aerosp ATR42300

Difficulty date
February 21, 2012
Submitted
February 21, 2012
Operation
Air carrier
Aircraft
N908FX
Make and model
Aerosp ATR42300
Aircraft serial
023
Aircraft time
32,460 hours, 43,685 cycles
Part
Skin
Part number
S53671201200
Condition
Damaged
Location
Zone 200
Stage of operation
IN
How discovered
V
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

HEAVY CHECK, FOUND OPEN HOLES BENEATH AFT CARGO DOOR FWD AND AFT UPPER HINGE HALVES BETWEEN FRAMES 37 AND 39 AND BETWEEN STRINGERS 5L AND 6L. FOUND WHILE ACCOMPLISHING M7 SB ATR42-53-030 & EO 5344-05) REPAIRED PER M7 DRAWING, PERFORMED STEP 1 THRU 6 OF DRAWING 42-470000 SFO-3.

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

More about the Aerosp ATR 42-300