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 SCNA20160916156Channel · corrodedZEE CHANNEL AT RBL 29 FROM BS 992 - 1016 IS CORRODED. FOUND TO BE OUT OF LIMITS. LOCATED AND DRILLED A NEW ZEE CHANNEL. REMOVED AND INSTALLEDSDR SCNA20160916155Strap · corrodedAFT WET AREA FLOOR STRAP AT RBL 18 IS CORRODED AT AFT AT BS 1016 FLOORBEAM. REMOVED COCRROSION, NDT VERIFIED ORIG. THICKNESS .071" REMAINING = .056" LOSS OF .015", FOUND TO BE OUT OF LIMITS. REMOVED, LOCATED AND DRILLED NEW STRAP.SDR SCNA20160916154Floor Support · crackedCRACKED FLOOR SUPPORT BETWEEN BS 295.5 - 312, RBL 15. REMOVED & REPLACED THE DAMAGED FLOOR SUPPORT.SDR SCNA20160916153Floor Support · crackedCRACKED FLOOR SUPPORT BETWEEN BS 277 - 294.5 AT BL 0. REMOVED AND REPLACED THE FLOOR SUPPORT.SDR SCNA20160916152Seat Track · corrodedSEAT TRACK AT BS 807, LBL 48 HAS CORROSION. REMOVED CORROSION ON THE SEAT TRACK.SDR SCNA20160916151Seat Track · corrodedSEAT TRACK AT BS 836, RBL 45 HAS CORROSION. REMOVED CORROSION.SDR SCNA20160916150Seat Track · corrodedSEAT TRACK AT BS 804, RBL 45 HAS CORROSION. REMOVED CORROSION.SDR SCNA20160916149Seat Track · corrodedSEAT TRACK AT BS 648, RBL 45 HAS CORROSION. REMOVED CORROSION.SDR SCNA20160916148Seat Track · corrodedSEAT TRACK AT BS 663, RBL 45 HAS CORROSION. REMOVED CORROSION.SDR SCNA20160916147Seat Track · corrodedSEAT TRACK AT BS 647, RBL 24 HAS CORROSION. REMOVED THE CORROSION ON THE SEAT TRACK.SDR SCNA20160916146Seat Track · corrodedSEAT TRACK AT BS 679 LBL 24 HAS CORROSION. REMOVED THE CORROSION FROM THE SEAT TRACK.SDR SCNA20160916145Seat Track · corrodedSEAT TRACK AT BS 682, LBL 45 CORRODED. REMOVED CORROSION ON THE SEAT TRACK.SDR SCNA20160916144Seat Track · corrodedSEAT TRACK AT LBL 45, BS 647 HAS CORROSION. REMOVED CORROSION ON THE SEAT TRACK.SDR SCNA20160916143Battery Pack · inoperativeEMERGENCY LIGHT BATTERY PACKS INOPERATIVE. BASE CHARGER FOR BATTER PACK REMOVED AND REPLACED. OPS CHECK ACCOMPLISHED. OPS CHECKED GOOD. REPLACED THE BATERY PACK. TESTED GOOD.SDR SCNA20160323036Charger · inoperativeR 1 DOOR EMERGENCY LIGHT INOPERATIVE. R & R BATTERY CHARGER. OK FOR SERVICE.SDR SCNA20160201026Skin · damagedFOUND HOLE ON BOTTOM FLEX SKIN ON NR 7 SLAT. DAMAGE IS LOCATED APPROXIMATELY 58" INBD OF OUT EDGE OF SLAT. RT BEHIND PANEL 624DB. REMOVED DAMAGED AREA AND STOPPED DRILLED 1 CRACK.SDR SCNA20151207175Unknown · crackedCRACKED INBD AND OTBD FLANGE FS 727B, RBL 45.5. CUTOUT DAMAGE, HFECD FLAP PEENED, FABRICATED PARTS AND INSTALLED.SDR SCNA20151207174Link · crackedINBD CONNECTING LINK FOR LT RAM AIR DOOR FOUND TO BE CRACKED. R & R LT RAM AIR AFT DOOR LINK.SDR SCNA20151207173Skin · crackedA CRACK WAS NOTED AT THE 2ND HOLE FROM THE TOP, AFT ROW, AND IN THE SKIN ONLY. REAMED HOLE IAW EA FS 540, LT STR 22L.SDR SCNA20150807120Wire · looseFIRST 5 FLOOR TRACK EMERGENCY LIGHTS ARE NOT WORKING DURING TEST. FOUND 1 LOOSE WIRE AT RECEPTACLE. RESECURED WIRE.SDR SCNA20150217047Light · inoperativeBS 360 EMERGENCY LIGHTS INOPERATIVE. R & R THE LIGHT ASSY.SDR SCNA20150126011Light · damagedEMERGENCY TRACK LIGHT AT SEAT 24C DAMAGED. INSTALLED NEW LIGHT ASSY & LENS. REPAIRED BROKEN WIRING.SDR SCNA20141110168Lamp · inoperativeFLOOR LIGHTING AT ROW 22 NOT WORKING. REPLACED THE LAMP.SDR SCNA20141013141Cover · missingLEFT OVERWING EMERGENCY EXIT COVER MISSING. REPLACED LIGHT ASSY.SDR SCNA20140903111Cover · missingFLOOR EMERGENCY LIGHT AT ROW 24 IS MISSING COVER. ATTACHED EMERGENCY LIGHT COVER.SDR SCNA20140205006Bulb · inoperativeFORWARD LEFT EMERGENCY SLIDE LIGHT DEFECTIVE. R & R BULB.SDR SCNA20131122192Connector · disconnectedEMERGENCY LIGHT CONNECTOR DISCONNECTED. CONNECTED CONNECTOR, OPS CHECKED GOOD.SDR SCNA20131122228Window Frame · damagedFLIGHT DECK LT WINDOW FRAME NR 3 CRACKED AND OUT OF LIMITS AND REQUIRES REPLACEMENT. R & R FLIGHT DECK LT NR 3 WINDOW FRAME.SDR SCNA20131122227Floorbeam · corrodedTRANSVERSE FLOORBEAM AT STA 947.5 UPPER SURFACE CORRODED BETWEEN LBL 24.75 AND RBL 24.75. REPAIRED FLOOR UPPER CORD AT STA 947.50.SDR SCNA20131122226Seat Track · chafedRIGHT OTBD SEAT TRACK HAS SEVERAL CHAFE MARKS BETWEEN FS 727 TO FS 727B IN CABIN. REMOVED CHAFE FROM RT OTBD SEAT TRACK. R & R SEAT TRACK AT RBL 45.50 FROM STA 727B-887.SDR SCNA20131122224Threshold · corrodedAFT CARGO BAY CORROSION AT DOOR THRESHOLD WEB. R & R WEB.SDR SCNA20131122225Support · corrodedFLOOR TO SIDEWALL SUPPORT HAS SURFACE CORROSION IN AFT PIT FROM FS STA 767C TO FS 727C. R & R FLOORBOARD TO SIDEWALL SUPPORT IN AFT PIT FROM STA 767C TO FS 727C.SDR SCNA20131122223Angle · corrodedCANTILEVER FLOOR OTBD RT SHEAR WEB UPPER LONGITUDINAL ZEE ANGLE CORRODED AT STA 989, OTBD OF RBL 27.95. FABRICATED NEW ZEE ANGLE. ZEE ANGLE REMOVED AND INSTALLED.SDR SCNA20131122222Shear Web · corrodedCANTILEVER FLOOR OTBD RT SHEAR WEB CORRODED AT STA 986.5. ORDERED NEW WEB AND DRILLED UP WEB. REMOVED AND INSTALLED.SDR SCNA20131122220Intercostal · corrodedFOUND CORROSION AROUND NUTPLATE HOLES ON INTERCOSTAL BS 747 TO 767, RBL 23. R & R INTERCOSTAL.SDR SCNA20131122219Floor Support · corrodedFLOOR SUPPORT AT BS 887 IN AFT CARGO BAY CORRODED. R & R FLOOR SUPPORT.SDR SCNA20131122221Floor Panel · damagedAFT CARGO NR 1 FLOOR PANEL HAS BARE METAL ON LOWER ATTACH AREAS AND LIGHT CORROSION ON UPPER SURFACE ATTACH AREAS. FABRICATED NEW FLOOR PANEL.SDR SCNA20131122203Floor Panel · damagedAFT WET AREA FLOOR PANEL LT BS 917-946 UNDER LAV HAS CORRODED INSERTS AND PEELING FIBERS. REPAIRED FLOOR PANEL.SDR SCNA20131122202Floor Panel · damagedAFT WET AREA FLOOR PANEL CTR BS 946-986 HAS CORRODED INSERTS AND PEELING FIBERS. REPAIRED FLOOR PANEL.SDR SCNA20131122201Floor Panel · damagedAFT WET AREA FLOOR PANEL RT INBD STA 887-946 HAS CORRODED, DAMAGED INSERTS AND PEELING FIBERS. REPAIRED FLOOR PANEL.SDR SCNA20131122200Floor Panel · damagedAFT WET AREA FLOOR PANEL RT OTBD BS 887-946 HAS DAMAGED AND CORRODED INSERTS AND PEELING FIBERS. REPAIRED FLOOR PANEL.SDR SCNA20131122199Floor Panel · damagedAFT WET AREA FLOOR PANEL LT BS 986-1016 HAS CORRODED INSERTS. DAMAGED INSERTS, POTTED INSERTS NOT FLUSH WITH TO OF PANEL, AND EDGE DAMAGE NEAR GALLEY MOUNT CUTOUTS. REPAIRED FLOOR PANEL.SDR SCNA20131122198Floor Panel · damagedAFT WET AREA FLOOR PANEL RT BS 986-1016 HAS CORRODED INSERTS. DAMAGED INSERTS. POTTED INSERTS NOT FLUSH WITH OTP OF FLOOR PANEL, AND EDGE DAMAGE TO FLOOR PANEL NEAR GALLEY MOUNT CUTOUTS. REPAIRED FLOOR PANEL.SDR SCNA20131122197Floor Panel · damagedAFT WET AREA FLOOR PANEL CTR BS 887-947 HAS PEELING FIBERS AND CORRODED INSERTS. REPAIRED FLOOR PANEL.SDR SCNA20131122196Floor Panel · damagedAFT WET AREA FLOOR PANEL LT BS 1016 TO AFT PRESSURE BULKHEAD HAS PEELING FIBERS AND CORROSIVE RESIDUE ON BOTTOM SIDE OF PANEL. REPAIRED FLOOR PANEL .SDR SCNA20131122195Floor Panel · damagedAFT WET AREA FLOOR PANEL RT BS 1016 TO AFT PRESSURE BULKHEAD HAS PEELING FIBERS AND TOOL DAMAGE. REPAIRED FLOOR PANEL.SDR SCNA20131122214Floor Panel · damagedFWD WET AREA FLOOR PANEL "K" HAS CORRODED INSERTS AND PEELING FIBERS. REPAIRED FLOOR PANEL.SDR SCNA20131122213Floor Panel · damagedFWD WET AREA FLOOR PANEL "J" HAS CORRODED INSERTS AND PEELING FIBERS. REPAIRED FLOOR PANEL.SDR SCNA20131122212Floor Panel · damagedFWD WET AREA FLOOR PANEL "I" HAS CORRODED INSERTS AND PEELING FIBERS AND DIRTY POTTED INSERTS. REPAIRED FLOOR PANEL.SDR SCNA20131122211Floor Panel · damagedFWD WET AREA FLOOR PANEL "H" HAS CORRODED INSERTS AND PEELING FIBERS. REPAIRED FLOOR PANEL.
Back to N710SY, cancelled Aug 21, 2021