N615SW, cancelled Jan 2, 2019
Service difficulty reports · 323
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 = 'N615SW' AND deregistration_id = 'N615SW-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 = 'N615SW' AND deregistration_id = 'N615SW-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 SWAA2015061640795Strap · crackedFORWARD CABIN FLOOR STRUCTURE STRAP CRACKED BETWEEN BS 294.5+10 TO 344+5, LBL 10. R & R STRAP IAW SRM & DWG.SDR SWAA2015061640794Strap · crackedFORWARD CABIN FLOOR STRUCTURE STRAP CRACKED BETWEEN BS 294.5+10 TO 344+5, BL 0. R & R STRAP IAW SRM & DWG.SDR SWAA2015061240652Channel · corrodedFOUND A CHANNEL CORRODED AT BS 727D+5, LBL 8.1. REPAIRED THE CHANNEL IAW EA.SDR SWAA2015070641309Angle · crackedFORWARD CARGO COMPARTMENT CLIP ANGLE CRACKED AT BS 400, STRINGER 26R. R & R CLIP ANGLE IAW SRM & DWG.SDR SWAA2015070641307Angle · crackedFORWARD CARGO COMPARTMENT CLIP ANGLE CRACKED AT BS 540, LBL 2. R & R CLIP ANGLE IAW SRM & DWG.SDR SWAA2015061940973Angle · crackedAFT CARGO COMPARTMENT ANGLE CRACKED BETWEEN BS 887 - 907, RBL 46. R & R ANGLE IAW SRM & DWG.SDR SWAA2015061940972Angle · crackedAFT CARGO COMPARTMENT ANGLE OF WEB CRACKED AT BS 947.5, BETWEEN STRINGER 24L - 25L. R & R ANGLE IAW SRM & DWG.SDR SWAA2015061740808Angle · crackedANGLE CRACKED BETWEEN BS 927 TO 947.5, BL 0. R & R ANGLE IAW SRM & DWG.SDR SWAA2015070941688Keelbeam · corrodedFORWARD CARGO COMPARTMENT KEEL BEAM CORRODED AT BS 500D+7.5, STRINGER 28L. REPAIRED KEEL BEAM IAW SRM & DWG.SDR SWAA2015070841536Floorbeam · crackedFLOORBEAM CRACKED AT BS 344, LBL 9. REPAIRED FLOORBEAM IAW SRM.SDR SWAA2015070841515Skin · crackedRIGHT WING FIXED LE UPPER SKIN CRACKED AT WBL 157. REPAIRED SKIN IAW EA.SDR SWAA2015070841538Frame · crackedFRAME CRACKED AT BS 440, STRINGER 24R. R & R FRAME IAW SRM & DWG.SDR SWAA2015070841537Web · crackedFORWARD CARGO COMPARTMENT WEB CRACKED AT BS 440, BETWEEN STRINGER 26R - 25R. R & R WEB IAW SRM & DWG.SDR SWAA2015061740807Floorbeam · crackedFLOORBEAM WEB CRACKED AT BS 639, RBL 45.5. REPAIRED WEB IAW SRM.SDR SWAA2015061640760Bracket · crackedRIGHT WING TE BRACKET CRACKED AT WS 531. REPLACED BRACKET IAW SRM & DWG.SDR SWAA2015061640752Support Fitting · crackedFORWARD CARGO COMPARTMENT SUPPORT CLIP CRACK AT BS 380, STRINGER 26R. R & R CLIP IAW SRM & DWG.SDR SWAA2015061640751Support Fitting · crackedFORWARD CARGO COMPARTMENT SUPPORT CLIP CRACK AT BS 380, STRINGER 26L. R & R CLIP IAW SRM & DWG.SDR SWAA2015071041789Floorbeam · corrodedFLOORBEAM UPPER CHORD FLANGE AT CORRODED AT BS 986.5, BETWEEN RBL 5 - 43. REPAIRED CHORD IAW EO & EA.SDR SWAA2015070641305Web · corrodedWEB CORRODED BETWEEN BS 847 - 867, STRINGER 17L. R & R WEB IAW SRM & DWG.SDR SWAA2015061040520Angle · corrodedFUSELAGE Z ANGLE CORRODED AT STATION 986.5+4, RBL 47, WL 207. R & R ANGLE IAW SRM.SDR SWAA2015071441910Skin · crackedR1 DOOR AFT LOWER CORNER SKIN CRACKED AT BS 312+15, STRINGER 17R. REPAIRED SKIN IAW EA.SDR SWAA2015071341834Skin · crackedR2 DOOR CUT OUT SKIN CRACKED AT BS 947.5+12, STRINGER 17R. REPAIRED SKIN IAW EA.SDR SWAA2015071041788Skin · crackedL2 DOOR SKIN CRACKED AT BS 947.5+12, STRINGER 17L, LOWER FWD CORNER. REPAIRED SKIN IAW SRM.SDR SWAA2015070941681Skin · crackedAFT ENTRY DOOR LOWER FWD CORNER, SKIN CRACKED BETWEEN BS 947.5 TO 967+10, BETWEEN STRINGER 16L TO 19L. REPAIRED SKIN IAW SRM.SDR SWAA2015060940516Floorbeam · crackedFLOORBEAM CRACKED AT STATION 698 - 717, LBL 24.8. REPAIRED BEAM IAW EA.SDR SWAA2015060940515Floorbeam · crackedFLOORBEAM CRACKED AT STATION 708, LBL 24.8. REPAIRED BEAM IAW EA.SDR SWAA2015071341833Skin · crackedR1 DOOR LOWER CORNER BEAR STRAP SKIN CRACKED AT BS 312+15.5", STRINGER 17R. REPAIRED SKIN IAW EA.SDR SWAA2015071341832Skin · crackedR2 DOOR SKIN LOWER FWD CORNER CUT OUT CRACKED AT BS 947.5+10", STRINGER 17R. REPAIRED SKIN IAW EA.SDR SWAA2015071041787Skin · crackedR1 DOOR EXTERNAL BEAR STRAP CUT OUT SKIN CRACKED AT BS 312+15, STRINGER 17R. REPAIRED SKIN IAW EA.SDR SWAA2015071041786Skin · crackedR1 DOOR FUSELAGE SKIN CRACKED AT BS 328, STRINGER 17R. REPAIRED SKIN IAW EO & EA.SDR SWAA2015070841535Skin · crackedLEFT UPPER CORNER OF WINDOW POST C - D SKIN LOCATED CRACKED AT BS 219.8. REPAIRED SKIN IAW SRM.SDR SWAA2015060840467Floor Support · crackedLONGITUDINAL FLOORBEAM CRACKED AT STATION 707, LBL 24.8. REPAIRED FLOORBEAM IAW EA.SDR SWAA2015071341831Spar · crackedRIGHT WING REAR SPAR UPPER CHORD CRACKED AT RSS 215.97+5.9", AFT SUPPORT FITTING. REPAIRED CHORD IAW EA.SDR SWAA2015071341830Spar · crackedLEFT WING REAR SPAR UPPER CHORD CRACKED AT RSS 215.97+5.9", AFT SUPPORT FITTING. REPAIRED CHORD IAW EA.SDR SWAA2015071041718Floor Support · crackedLONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 663.75+7, RBL 24.8. REPAIRED CHORD IAW EO & EA.SDR SWAA2015071041717Floor Support · crackedLONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 663.75+3, RBL 24.8. REPAIRED CHORD IAW EO & EA.SDR SWAA2015070941687Floor Support · crackedLONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 663.75, LBL 24.8. REPAIRED CHORD IAW EO & EA.SDR SWAA2015070941686Floor Support · crackedLONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 663.75+7, LBL 24.8. REPAIRED CHORD IAW EO & EA.SDR SWAA2015052740085Sign · unsecureFORWARD EXIT SIGN FELL OFF. R & R SIGN ASSEMBLY IAW AMM.SDR SWAA2015051839815Vsi · inoperativeDIVERSION & DECLARED EMER. FIRST OFFICER'S VSI BLANK. R & R VERTICAL SPEED INDICATOR IAW AMM.SDR SWAA2015051139550Lock · looseR1 DOOR AFT SLIDE LOCK LOOSE. SECURED LOCK ASSEMBLY IAW SIP.SDR SWAA2015033037934Pump · malfunctionedAIR TURN BACK, ENG SHUTDOWN & DECLARED EMER AT 36,000'. WHILE CROSS FEEDING NR 1 ENG FLAME OUT. R & R NR 1 ENG DRIVEN FUEL PUMP IAW MT.SDR SWAA2015030937251Lens · looseRIGHT BULLNOSE EMER LIGHT LENS LOOSE AT ROW 5. SECURED LENS IAW AMM.SDR SWAA2014120134542Lens · looseLEFT OVERWING EMER EXIT SIGN LENS LOOSE. SECURED LENS IAW MM.SDR SWAA2014100232551Angle · crackedLEFT WING UPPER WING SUPPORT UNDER PANEL 5735 26 INCHES AFT RS & 8 UP FROM NR 3 FLAP TRACK ANGLE CRACKED. R & R ANGLE IAW SRM.SDR SWAA2014100232550Angle · crackedLEFT WW CUT OUT FWD CURVED ANGLE CRACKED ON TOP CORNER. R & R ANGLE IAW SRM.SDR SWAA2014100232549Strap · crackedE & E COMPARTMENT FLOOR SUPPORT STRAP CRACKED AT BS 328 RT SIDE. REPAIRED STRAP IAW SRM.SDR SWAA2014100232548Door Frame · crackedR1 DOOR CRACKED LOWER EDGE FRAME CRACKED AT AFT LOWER CORNER STOP FITTING. R & R DOOR IAW AMM.SDR SWAA2014070829749Lens · missingLEFT EMER EXIT BULLNOSE LIGHT LENS MISSING AT ROW 14. INSTALLED LENS IAW AMM.SDR SWAA2014062529386Slide · out of positionL1 DOOR EMER EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW AMM.
Back to N615SW, cancelled Jan 2, 2019