SDR COEA9572001

Service difficulty report · Fitting · Fokker F27MK500

Difficulty date: April 27, 1995
Submitted: March 26, 2000
Operation: Air carrier
Aircraft: N720FE
Make and model: Fokker F27MK500
Aircraft serial: 10464
System (JASC): 5320 · Fuselage Miscellaneous Structure
Part: Fitting
Part number: 5215012401
Condition: Cracked
Location: Bs 7961
Part time: 45,887 hours
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

DURING THE ACCOMPLISHMENT OF ROUTINE D-CHECK WORKCARD 00-153, THE FOLLOWING WAS FOUND, FUSELAGE FRAME STATION 7961, CENTER WING STATION 1040 LEFT, REF F27 IPC 53-40-01, FIG 01, PG 1. FUSELAGE FRAME P/N 5215-012-401. THE CENTER WING FWD ATTACH FITTING P/N 5215-012-401 WAS FOUND TO HAVE SURFACE LEVEL 1 CORROSION AT THE FOUR O'CLOCK POSITION OF HOLE CIRCUMFERENCE. CORROSION WAS REMOVED BY REAMING HOLE TO OVERSIZE. REPAIRED CRACK BY SPOT FACING THE FWD SIDE OF THE FITTING WITH INSTALLATION OF NEW .015 BUSHING PER FOKKER F27 SB 57-51 AND FILLER PER FOKKER RLD APPROVED INSTRUCTIONS. (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.

Fokker SB F27 57-51

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

More about the Fokker F.27MK 500