N352SW, cancelled Jan 2, 2019
Service difficulty reports · 356
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 = 'N352SW' AND deregistration_id = 'N352SW-2019-01-02' 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 = 'N352SW' AND deregistration_id = 'N352SW-2019-01-02' 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 SWAA2014100832758Gusset · crackedFORWARD CARGO COMPARTMENT GUSSET CRACKED AT BS 500D STRINGER 19L. R & R GUSSET IAW SRM & DWG.SDR SWAA2014100832757Gusset · crackedFORWARD CARGO COMPARTMENT GUSSET CRACKED AT BS 500D STRINGER 19R. R & R GUSSET IAW SRM & DWG.SDR SWAA2014100632643Plate · crackedLEFT HORIZONTAL STABILIZER ACCESS PANEL 9126 PLATE CRACKED. R & R PLATE IAW SRM.SDR SWAA2014100632642Support Angle · crackedFORWARD CARGO COMPARTMENT SUPPORT ZEE CRACKED AT BS 480+16 STRINGER 26L. REPAIRED SUPPORT ZEE IAW SRM.SDR SWAA2014100232522Channel · crackedSTRINGER SPLICE CHANNEL CRACKED AT BS 360 STRINGER 14L. R & R CHANNEL IAW SRM & DWG.SDR SWAA2014100232521Frame · crackedFRAME CRACKED AT BS 847 BETWEEN STRINGER 1 TO 2L. REPAIRED FRAME IAW SRM.SDR SWAA2014100232520Channel · crackedSTRINGER SPLICE CHANNEL CRACKED AT BS 360 STRINGER 14L. R & R CHANNEL IAW SRM & DWG.SDR SWAA2014100232519Stringer · crackedSTRINGER CRACKED AT BS 380 STRINGER 15R. REPAIRED STRINGER IAW SRM.SDR SWAA2014093032431Stringer Splice · crackedSTRINGER SPLICE CRACKED AT BS 907 STRINGER 4R. R & R SPLICE IAW SRM & DWG.SDR SWAA2014093032430Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 348.2 STRINGER 16L. R & R ANGLE IAW SRM & DWG.SDR SWAA2014093032429Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 348.2 STRINGER 16L. R & R ANGLE IAW SRM & DWG.SDR SWAA2014092432249Intercostal · crackedINTERCOSTAL CRACKED AT BS 540, BETWEEN BL 0 & LBL 24.5. R & R INTERCOSTAL IAW SRM & DWG.SDR SWAA2014092232153Tie Clip · crackedTIE CLIP CRACKED AT BS 400 STRINGER 8L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014101032850Frame · crackedFUSELAGE FRAME CRACKED AT STATION 706 STRINGER 11R. REPAIRED FRAME IAW EA.SDR SWAA2014100932813Floor Support · crackedLONGITUDINAL FLOORBEAM LOWER WEB CRACKED AT BS 717 LBL 0.07. REPAIRED WEB IAW EA.SDR SWAA2014100232518Web · crackedWEB CRACKED AT BS 639 AT STRINGER 15L. R & R WEB IAW SRM & DWG.SDR SWAA2014101032517Seat Track · crackedSEAT TRACK CRACKED AT BS 727B LBL 44.5. REPAIRED SEAT TRACK IAW SRM.SDR SWAA2014092232152Tie Clip · crackedTIE CLIP CRACKED AT BS 663.75 STRINGER 10R. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014100732709Angle · crackedLEFT WING INBD & OTBD ANGLE CRACKED OF STABILIZING LINKS BETWEEN THE MLG BEAM & THE REAR SPAR. R & R ANGLE IAW SRM & DWG.SDR SWAA2014100932812Floor Support · crackedLONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 675 LBL 24.82. REPAIRED CHORD IAW EA.SDR SWAA2014100932811Floor Support · crackedLONGITUDINAL FLOORBEAM WEB CRACKED AT BS 707 LBL 24.5. REPAIRED WEB IAW EA.SDR SWAA2014100932810Floor Support · crackedLONGITUDINAL FLOORBEAM WEB CRACKED AT BS 715.5 LBL 0.07. REPAIRED WEB IAW EA.SDR SWAA2014100932809Floor Support · crackedLONGITUDINAL FLOORBEAM WEB CRACKED AT BS 710.5 LBL 0.07. REPAIRED WEB IAW EA NO.SDR SWAA2014100932808Floor Support · crackedLONGITUDINAL FLOORBEAM WEB CRACKED AT BS 709.5 BETWEEN BBL 0.07. REPAIRED WEB IAW EA.SDR SWAA2014100632641Light · crackedLEFT EEPLS CRACKED AT ROW 11. R & R EEPLS IAW AMM.SDR SWAA2014100632633Light · crackedRIGHT EEPLS CRACKED BETWEEN ROW 3 TO ROW 14. R & R EEPLS IAW AMM.SDR SWAA2014091531932Cover · disconnectedAFT GALLEY EMER EXIT COVER DISCONNECTED. RECONNECTED COVER IAW MM.SDR SWAA2014100932807Skin · crackedFUSELAGE SKIN CRACKED AT BS 420+13 STRINGER 1. REPAIRED SKIN IAW EA.SDR SWAA2014100932806Floor Support · crackedLONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 727B LBL 45.5. REPAIRED CHORD IAW EA.SDR SWAA2014100932805Frame · crackedFRAME CHORD CRACKED AT BS 727 STRINGER 18A RT. REPAIRED CHORD IAW EA.SDR SWAA2014100932804Frame · crackedFRAME CHORD CRACKED AT BS 727 STRINGER 18A LT. REPAIRED CHORD IAW EA.SDR SWAA2014100232516Angle · crackedTAIL CONE ANGLE CRACKED AT UPPER SURFACE FAIRING APU EXHAUST AREA. R & R ANGLE IAW SRM & DWG.SDR SWAA2014082731289Skin · delaminatedLEFT WING NR 2 SLAT UPPER SURFACE TE AT INBD AUXILIARY TRACK DELAMINATED. R & R NR 2 SLAT IAW MM.SDR SWAA2014082631214Skin · delaminatedLEFT WING NR 3 SLAT UPPER SURFACE TE INBD CORNER DELAMINATED. R & R NR 3 SLAT IAW MM.SDR SWAA2014082531103Battery Pack · dischargedRIGHT CABIN OVERHEAD BIN BULLNOSE EMER EXIT LIGHT INOPERATIVE AT ROW 8. R & R BATTERY PACK IAW MM.SDR SWAA2014082531124Skin · delaminatedLEFT WING NR 1 SLAT UPPER SURFACE TE CORNER DELAMINATED. R & R NR 1 SLAT IAW MM.SDR SWAA2014082531123Lens · looseRIGHT EMER EXIT LIGHT LENS LOOSE. SECURED LENS IAW AMM.SDR SWAA2014082531111Skin · delaminatedLEFT WING NR 3 SLAT UPPER SURFACE TE INBD CORNER DELAMINATED. R & R NR 3 SLAT IAW MM.SDR SWAA2014082531110Battery Pack · dischargedLEFT CABIN OVERHEAD BIN BULLNOSE EMER EXIT LIGHTS INOPERATIVE BETWEEN ROW 6 TO 10. R & R BATTERY PACK IAW MM.SDR SWAA2014062729447Spindle · corrodedRIGHT WING OTBD FLAP NR 8 CARRIAGE SPINDLE CORRODED. R & R SPINDLE ASSEMBLY IAW MM.SDR SWAA2013092320363Boot · out of positionDIVERSION AT FL350 THE CABIN ALT WARNING HORN SOUNDED CABIN ALT APPROXIMATELY 11K EMERGENCY DESCENT - CABIN ALT NEVER EXCEEDED 12K'. HOT AIR SUPPLY DUCT BOOT IN RT A/C BAY FORWARD WALL PARTIALLY OFF FLANGE, LEAKED. R & R LT SUPPLY DUCT CHECK VALVE IAW MM.SDR SWAA2013061016930Actuator · shearedRIGHT WING NR 5 GROUND SPOILER INBD ACTUATOR ROD END SHEARED. R & R ACTUATOR IAW MM.SDR SWAA2013052116294Skin · crackedSKIN ON VERTICAL CHEM-MILL CRACKED AT BS 360, STR 2L. REPAIRED SKIN IAW SRM.SDR SWAA2013051315884Lens · missingFORWARD ENTRY DOOR LIGHTED EMERGENCY EXIT SIGN MISSING LENS. INSTALLED LENS IAW AMM.SDR SWAA2013032814227Cover · looseRIGHT OVERWING EMERGENCY EXIT SIGN LOOSE. SECURED COVER IAW MM.SDR SWAA2013031913779Skin · crackedFUSELAGE SKIN CRACKED BS 259.5, STR 23L. REPAIRED SKIN PER SRM.SDR SWAA2013020712414Door Frame · cracked2 VERTICAL CRACKS ALMOST A JOINING TOTALING 2.875 LONG ON THE FWD GALLEY SERVICE DOOR FRAME OPENING, JUST ABOVE THE FWD UPPER DOOR STOP (MARKED IN RED). VERIFIED BY HFEC PER NDT PART 6 51-00-00 PROCED 23. REPAIRED PER SRM 51-10-02 AND 51-40-0.SDR SWAA2012111909585Fitting · corrodedCARGO COMPARTMENT STA 927 BETWEEN STR 27L AND 27R CORRODED ON FRAME FOOT. REMOVED AND REPLACED IAW FRAME SRM AND BAC DWG.SDR SWAA2012112609741Angle · crackedSTA 727 CHORD CRACKED BETWEEN LT AND RT KEEL BEAMS AT BL-0 VIEWED PANEL 1508L. REMOVED AND REPLACED PANELS IAW BAC DWG & SRM.SDR SWAA2012112609740Stiffener · severedTRANSFERRED FROM LOG PAGE 8588983, STA 663 AT RBL 6.5 VERTICAL STIFFENER IS SEVERED. REMOVED AND REPLACED STIFFENER IAW BAC DWG 65-45402 AND EA 1-357-7686 REV -, REO G15673 REV IR. FACT AS A RESULT OF POST REPAIR INSPECTION.
Back to N352SW, cancelled Jan 2, 2019