N710SY, cancelled Aug 21, 2021
Service difficulty reports · 119
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 = 'N710SY' AND deregistration_id = 'N710SY-2021-08-21' 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 = 'N710SY' AND deregistration_id = 'N710SY-2021-08-21' 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 SCNA20131122210Floor Panel · damagedFWD WET AREA FLOOR PANEL "G" HAS CORRODED INSERTS AND PEELING FIBERS. REPAIRED FLOOR PANEL.SDR SCNA20131122209Floor Panel · damagedFWD WET AREA FLOOR PANEL "F" HAS CORRODED INSERTS, PEELING FIBERS, AND BAD POTTED INSERTS. REPAIRED FLOOR PANEL.SDR SCNA20131122208Floor Panel · damagedFWD WET AREA FLOOR PANEL "E" HAS CORRODED INSERTS AND PEELING FIBERS. REPAIRED FLOOR PANEL.SDR SCNA20131122207Floor Panel · damagedFWD WET AREA FLOOR PANEL "D" HAS PEELING FIBERS AND CORRODED INSERTS. REPAIRED FLOOR PANEL.SDR SCNA20131122206Floor Panel · damagedFORWARD WET AREA, FLOOR PANEL "C" HAS EDGE DAMAGE AND CORRODED INSERTS. REPAIRED FLOOR PANEL.SDR SCNA20131122205Floor Panel · damagedFWD WET AREA FLOOR PANEL "B" HAS CORRODED INSERTS AND PEELING FIBERS. REPAIRED FLOOR PANEL.SDR SCNA20131122204Floor Panel · damagedFWD WET AREA FLOOR PANEL "A" HAS CORRODED INSERTS, SURFACE DAMAGE TO LOWER SIDE, AND EDGE DAMAGE. REPAIRED FLOOR PANEL.SDR SCNA20131123229Rib · crackedVERTICAL STAB L/E PANEL 322B ASSY HAS THREE INTERNAL RIBS CRACKED, RIBS 6, 7, 8 FROM TOP DOWN. REPAIRED AND INSTALLED NR 6 VERT STAB INTERNAL RIB. INSTALLED NR 7, NR 8 VERT STAB INTERNAL RIBS.SDR SCNA20131122218Skin · chafedRT WING SLATS NR 5 ARE CHAFED ON AFT LOWER SURFACE. REPAIRED SLAT NR 5 AFT LOWER SURFACE AREAS.SDR SCNA20131122217Skin · chafedRT WING NR 8 SLAT CHAFED ON AFT LOWER SURFACE. REPAIRED RT NR 8 SLAT CHAFE ON LOWER SURFACE.SDR SCNA20131122216Skin · chafedRT WING SLAT NR 7 CHAFED ON AFT LOWER SURFACE. REPAIRED SLAT.SDR SCNA20131122215Angle · corrodedCANTILEVER FLOOR OTBD LT SHEAR WEB UPPER TRANSVERSE ZEE ANGLE CORRODED AT STA 992.8, OTBD OF LBL 27.95. R & R SECTION 47 CANTILEVER FLOOR OTBD LT SHEAR WEB UPPER TRANSVERSE ZEE ANGLE.SDR SCNA20131122194Floor Panel · corrodedAFT CARGO NR 3 FLOOR PANEL HAS LIGHT CORROSION ON BOTTOM & TOP ATTACH AREAS. FABRICATED FLOOR PANEL.SDR SCNA20131122193Floor Panel · corrodedAFT CARGO NR 2 FLOOR PANEL HAS LIGHT CORROSION ON LOWER SURFACE ATTACH AREAS. FABRICATED AND TREATED FLOOR PANEL.SDR SCNA20131001142Cover · dislodgedEXIT ROW 13 PLASTIC EXIT SIGN OFF THE WALL. INSTALLED ROW 13 EXIT SIGN COVER.SDR SCNA2012092712Channel · corrodedFOUND SEVERAL SPOTS OF HEAVY CORROSION IN AFT PIT ZEE CHANNEL SIDEPLATE, LEFT SIDE, FROM FACTOR SPLICE AT STA 727B+10 TO FACTORY SPLICE AT STA 817.SDR SCNA10009Light · brokenEMERGENCY ESCAPE PATH LIGHT ASSY. BROKEN ROW 8. R & R LIGHT ASSY IAW AMM 33-51-12-96-802. OPS CHECKS NORMAL.SDR SCNA10010Light · inoperativeEXTERIOR EMERGENCY LIGHT INOP LEFT SIDE, AFT OF WING. RELAMPED LIGHT, OPS CHECKED NORMAL.SDR SCNA09017Light · inoperativeDURING A FUNCTIONAL CHECK MAINTENANCE DISCOVERED THE AFT PASSENGER DOOR EMERGENCY LIGHT INOP. MAINTENANCE REPLACED THE LAMP AND THE OPERATIONAL CHECK IS NORMAL.
Back to N710SY, cancelled Aug 21, 2021