N658SW, cancelled Mar 15, 2018
Service difficulty reports · 512
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 = 'N658SW' AND deregistration_id = 'N658SW-2018-03-15' 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 = 'N658SW' AND deregistration_id = 'N658SW-2018-03-15' 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 SWAA2013042515211Slide · low pressureL1 DOOR EMERGENCY EVAC SLIDE PRESSURE LOW. REMOVED AND REPLACED SLIDE IAW MT.SDR SWAA2015050639352Skin · crackedLEFT WING NR 2 SLAT TE LOWER SKIN CRACKED AT LOWER LIP FASTENERS. REPAIRED SKIN IAW SRM.SDR SWAA2013042415140Slat · delaminatedLEFT WING NR 1 SLAT UPPER INBD T/E DELAMINATED. REMOVED AND REPLACED NR 1 SLAT PER AMM.SDR SWAA2013042415139Gate · crackedAFT ENTRY DOOR UPPER GATE CRACKED AT FWD LOWER FASTENER. REMOVED AND REPLACED AFT ENTRY DOOR IAW M/M.SDR SWAA2013041814996Light · inoperativeL2 DOOR EMERGENCY LIGHT INOP. RELAMPED LIGHT PER AMM.SDR SWAA2013041614894Wire · brokenFWD ENTRY CEILING PANEL ABOVE FWD ENTRY DOOR CUTOUT WIRE BROKEN. REPAIRED WIRE PER SWPM AND WDM.SDR SWAA2013041614893Crease Beam · crackedCREASE BEAM WEB CRACKED BETWEEN BS 559 AND BS 578, LBL 66. REMOVED AND REPLACED WEB PER DWG & SRM.SDR SWAA2013040914597Shear Tie · corrodedSHEAR TIE CORRODED AT BS 986.5, BETWEEN STR 19R TO STR 20R. REMOVED & REPLACED SHEAR TIE IAW SRM & DWG.SDR SWAA2013041114758Fuse · brokenFORWARD ENTRY LIGHT ASSY, LEFT EMERGENCY EXIT LIGHT CHARGER FUSES BROKEN. REMOVED AND REPLACED FUSES PER WDM.SDR SWAA2013040314443Frame · crackedFRAME CRACKED AT BS 947.5, STR 19L. REMOVED AND REPLACED FRAME IAW SRM.SDR SWAA2013040314442Frame · crackedFRAME CRACKED AT BS 947.5, STR 19R. REMOVED AND REPLACED FRAME SECTION IAW DWG.SDR SWAA2013040214392Fitting · crackedINTERCOSTAL CLIP CRACKED AT BS 500A, STR 26L. REMOVED AND REPLACED CLIP PER SRM & DWG.SDR SWAA2013040214388Shear Tie · corrodedSHEAR TIE CORRODED AT BS 500, BETWEEN STRINGER 27R TO STRINGER 28R. REMOVED AND REPLACED SHEAR TIE IAW DWG & SRM.SDR SWAA2013040214387Support Angle · crackedCHANNEL SUPPORT ANGLE CRACKED AT BS 500C, STR 27L. REMOVED AND REPLACED ANGLE IAW SRM.SDR SWAA2013040314441Support Angle · crackedINTERIOR FLOORBEAM WEB SUPPORT ANGLE CRACKED AT BS 328, RBL 33. REMOVED & REPLACED ANGLE IAW SRM.SDR SWAA2013040414483Angle · crackedSUPPORT WEB ANGLE CRACKED AT BS 787, STR 27R. REMOVED AND REPLACED ANGLE IAW DWG.SDR SWAA2013041214790Panel · delaminatedPANEL 2469X DELAMINATED. REMOVED AND REPLACED PANEL IAW SRM AND DRAWING.SDR SWAA2013041214789Panel · delaminatedPANEL 2472X DELAMINATED. REMOVED AND REPLACED PANEL IAW SRM AND DRAWING.SDR SWAA2013032814225Support Bracket · crackedLEFT WING FIXED LEADING EDGE SUPPORT BRACKET CRACKED OVER FWD END OF ACCESS PANEL 6304. REMOVED AND REPLACED BRACKET IAW SRM.SDR SWAA2013041114757Bulkhead · corrodedFUSELAGE BULKHEAD CHORD CORRODED AT BS. 227.8, BL 0. REPAIRED CHORD PER ER AND EA.SDR SWAA2013040914631Control Cable · frayedRIGHT WING I/B MID FLAP AFT FLAP BOOM CABLES FRAYED. REMOVED & REPLACED CABLES IAW AMM.SDR SWAA2013040914622Frame · crackedFRAME CRACKED AT BS 328, BETWEEN STRINGER 20R AND 21R. REPAIRED FRAME PER ER & EA.SDR SWAA2013040914590Structure · corrodedVERTICAL CHORD CORRODED AT BS 227.8, BL 0. REMOVED & REPLACED CHORD IAW SRM & DWG.SDR SWAA2013032113930Strap · crackedFLOORBEAM STABILIZER STRAP CRACKED AT BS 344, LBL 9. REMOVED AND REPLACED STRAP PER SRM.SDR SWAA2013041714957Skin · crackedSKIN CRACKED AT BS 962, WL 211. REPAIRED SKIN IAW EA & ER.SDR SWAA2013040914621Floor Support · crackedLONGITUDINAL FLOORBEAM WEB CRACKED AT BS 708, BBL .07. REPAIRED WEB PER EA.SDR SWAA2013040314440Attach Fitting · crackedINTERCOSTAL ATTACH CLIP CRACKED AT BS 380, STR 26L. REMOVED AND REPLACED CLIP IAW DWG & SRM.SDR SWAA2013040214386Target · crackedRIGHT WING NR 5 SLAT I/B AUX TRACK POSITION SENSOR TARGET CRACKED. REMOVED AND REPLACED NR 5 SLAT IAW AMM.SDR SWAA2013040214385Seal · delaminatedLEFT WING 0 SPOILER I/B HINGE, I/B HORSE SHOE SEAL DELAMINATED. REMOVED AND REPLACED SEAL IAW AMM.SDR SWAA2013040214384Beam · crackedLEFT WING LOWER T/E BEAM CRACKED AT AILERON O/B CENTER HINGE ATTACH POINT. REMOVED AND REPLACED AILERON PER SRM.SDR SWAA2013032814224Beam · crackedLONGITUDINAL BEAM CRACKED BETWEEN BS 708 TO BS 711, BBL 0.07. REPAIRED BEAM IAW EA.SDR SWAA2013032814223Support Angle · crackedRIGHT WING NR 2 PYLON O/B UPPER T/E SUPPORT ANGLE CRACKED AT AFT END. REMOVED AND REPLACED ANGLE IAW SRM.SDR SWAA2013032614149Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 500A, STR 18R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA2013032614119Support Angle · crackedRIGHT WING I/B NO-STEP PANEL LOWER O/B SUPPORT ANGLE CRACKED IN RADIUS. REPAIRED ANGLE IAW EA.SDR SWAA2013032614118Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 500B, STR 18R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA2013032514045Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 480, STR 24L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA2013032514044Bear Strap · crackedL2 DOOR BEAR STRAP SKIN CRACKED AT BS 989, STR 7L. REMOVED AND REPLACED SKIN PER SRM.SDR SWAA2013032514043Web · crackedWEB CRACKED AT BS 417, STR 18R. REMOVED AND REPLACED WEB PER SRM AND DWG.SDR SWAA2013032514042Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 420, STR 22R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA2013032113929Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 500B, STR 24R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA2013032113928Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 400, STR 21R. REMOVED CLIP PER SRM.SDR SWAA2013032113918Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 400, STR 24L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA2013032113917Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 380, STR 22L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA2013032113916Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 500B, STR 21R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA2013041814995Sill · corrodedMOP SILL CORRODED BETWEEN BS 947 TO BS 990. REMOVED & REPLACED MOPSILL IAW SRM.SDR SWAA2013041614892Door Frame · corrodedR2 DOOR AFT FRAME CORRODED AT BS 992.8, WL 209. REPAIRED FRAME IAW EA.SDR SWAA2013041214816Skin · corrodedBILGE SKIN INNER SURFACE CORRODED AT BS 537, STR 27L. REPAIRED SKIN PER ATS ER AND EA.SDR SWAA2013041214808Intercostal · corrodedINTERCOSTAL WEB CORRODED BETWEEN BS 351 TO BS 355, STR 7L. REPAIRED WEB IAW ER & EA.SDR SWAA2013041214788Floorbeam · corrodedFLOORBEAM UPPER CHORD CORRODED AT BS 987, BETWEEN RBL 5 TO RBL. REPAIRED CHORD IAW ER & EA.SDR SWAA2013041214787Floorbeam · corrodedFLOORBEAM UPPER CHORD CORRODED AT BS 947, LBL 3. REPAIRED CHORD IAW ER & EA.
Back to N658SW, cancelled Mar 15, 2018