N641GT
Service difficulty reports · 1,011
Matched to this aircraft by N-number and event date, checked against the reported serial number, make and model. Newest first.
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 n_number = 'N641GT' AND registry_match = 'registration' 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 n_number = 'N641GT' AND registry_match = 'registration' 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.
SDR UIEA2011101900576Skin · dentedDURING ROUTINE C-CHECK, DISCOVERED DENTS/GOUGES ON THE LOWER SKIN PANEL AT MULTIPLE LOCATIONS, BETWEEN STRINGERS 5 AND 12, AND BETWEEN WS 250 AND WS 720. DAMAGED AREAS WERE BLENDED OUT. THE MAXIMUM BLEND DEPTH WAS 0.016" WHICH IS AT THE AREA COMMON TO STRINGSDR UIEA2011102100617Floor Panel · crackedFWD CARGO FOUND SMALL CRACK AT FLOOR PANEL. REMOVED DAMAGED CRACKED FLOOR PANEL, FABRICATED IAW SRM 53-30-53 AND INSTALLED.SDR UIEA2011102100624Floorbeam · corrodedCORROSION FOUND ON FLOORBEAM. REMOVED CORROSION. FOUND TO BE WITHIN LIMITS. TREATED AND PRIMED.SDR UIEA2011102100612Floorbeam · corrodedCORROSION ON FLOORBEAM BS 1480 LBL 32. REMOVED CORROSION, FOUND TO BE OUT OF LIMITS IAW REF SRM 53-00-51, REPAIRED IAW SRM 53-00-51.SDR UIEA2011092900533Skin · dentedDURING THE PRESENT C-CHECK, INSPECTION REVEALED A DENT ON THE UPPER SURFACE OF NR 3 SPOILER NEAR CENTER HINGE (FIG 1). DENT MEASURED 0.002" DEEP, 0.495" IN WIDTH AND WAS LOCATED 30" FROM THE INBD EDGE AND 19.75" FROM THE T/E. MX PERFORMED BOND TEST IAW NDTM SDR UIEA2011102100620Floorbeam · corrodedFOUND CORROSION ON FLOORBEAM. REMOVED CORROSION ON FLOORBEAM IAW SRM 51-10-02. FOUND TO BE IN LIMITS IAW 53-00-51.SDR UIEA2011102100613Floorbeam · corrodedFOUND CORROSION ON FLOORBEAM BS 1502 LBL 29. REMOVED CORROSION IAW SRM 51-11-00.SDR UIEA2011102100609Floorbeam · corrodedFOUND CORROSION ON FLOORBEAM BS 1502 LOWER FWD FLANGE FROM LBL 7 TO LBL 45. REPAIRED FLOORBEAM IAW RES -WI 2003850-22.SDR UIEA2011102100623Support · corrodedLT WING ACCESS PANEL SUPPORT AT WBL 289.45 HAS CORROSION. REMOVED CORROSION. FOUND TO BE WITHIN LIMITS. TREATED AND PRIME.SDR UIEA2011102100611Skin · dentedDENTS FOUND ON LOWER SKIN AT WS 210 WS 546, WS 616, WS 694 WS 720 AND WS 864. ALL DENTS WITHIN LIMITS IAW SRM 57-20-01. REWORKED AREAS IAW RES NR 2003862-27, REV 12 AND REV B PERFORMED. LEAK CHECKED.SDR UIEA2011102100622Keelbeam · corrodedCORROSION ON KEELBEAM. REMOVED CORROSION ON KEELBEAM IAW SRM 53-50-12 AND FOUND TO BE IN LIMITS AND SHOT PEENING AT KEELBEAM AREA REF SOPM 20-10-03. TREAT AND PRIMER, TOP COAT IAW SRM 51-20-01.
Back to N641GT