N697SW, cancelled Oct 5, 2019
Service difficulty reports · 430
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 = 'N697SW' AND deregistration_id = 'N697SW-2019-10-05' 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 = 'N697SW' AND deregistration_id = 'N697SW-2019-10-05' 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 SWAA2015042739031Stringer Splice · crackedSPLICE STRAP CRACKED AT BS 360, STRINGER 3R. REPAIRED STRAP IAW EA.SDR SWAA2015052740073Channel · corrodedR2 DOOR CREASE BEAM SUPPORT CHORD ANGLE TEE CHANNEL CORRODED BETWEEN BS 986.5 - 1001.5, RBL 41. R & R TEE CHANNEL IAW SRM & DWG.SDR SWAA2015051939841Web · corrodedAFT PIT DOOR CUT OUT UPPER SILL BEAM INBD VERTICAL WEB CORRODED AT BS 829, STRINGER 18R. R & R WEB IAW SRM & DWG.SDR SWAA2015050539310Support · crackedFORWARD PIT RT SIDE LONGITUDINAL FLOOR TO SIDEWALL SUPPORT CRACKED BETWEEN BS 492 - 500A. R & R SUPPORT IAW SRM & DWG.SDR SWAA2015042739030Shear Tie · corrodedSHEAR TIE CORRODED AT BS 947, STRINGER 27L. R & R SHEAR IAW SRM & DWG.SDR SWAA2015033037981Stringer Splice · crackedSTRINGER SPLICE CRACKED AT BS 360, STRINGER 14L. R & R SPLICE IAW SRM & DWG.SDR SWAA2015032037676Crease Beam · crackedRIGHT INNER CREASE BEAM CRACKED AT BS 616. REPAIRED CREASE BEAM IAW SRM & AMM.SDR SWAA2015052740072Stringer Clip · crackedAFT CARGO PIT STRINGER CLIP CRACKED AT BS 947L, STRINGER 26L. R & R CLIP IAW DWG & EA.SDR SWAA2015040738186Support Fitting · crackedAFT CARGO PIT BULKHEAD SUPPORT CLIP CRACKED AT BS 947, STRINGER 22L. R & R CLIP IAW DWG & SRM.SDR SWAA2015051439682Intercostal · corrodedAFT CARGO COMPARTMENT FLOOR FRAME INTERCOSTAL WEB CORRODED AT BS 767, BETWEEN STRINGER 26R - 25R. R & R WEB IAW DWG & SRM.SDR SWAA2015051339637Stringer · crackedSTRINGER CRACKED AT BS 1016, STRINGER 5R. R & R STRINGER IAW EA.SDR SWAA2015050839470Support · corrodedAFT CARGO PIT INTERNAL VHF 3 ANTENNA SUPPORT STRUCTURE CORRODED AT BS 727E, BETWEEN STRINGER 27L - 27R. R & R SUPPORT IAW EA.SDR SWAA2015050639360Frame · crackedFRAME WEB CRACKED AT BS 344, STRINGER 8R. REPAIRED WEB IAW EA.SDR SWAA2015042939126Support · corrodedFORWARD CARGO COMPARTMENT SPLICE SUPPORT CORRODED AT BS 500, BETWEEN STRINGER 24L - 26L. R & R SUPPORT IAW SRM & DWG.SDR SWAA2015040938324Beam · corrodedAFT CARGO COMPARTMENT CARGO FLOOR STRUCTURE CORRODED AT BS 796, LBL 8. REPAIRED BEAM IAW SRM.SDR SWAA2015032037675Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 500, STRINGER 22L. R & R CLIP IAW SRM & DWG.SDR SWAA2015051139530Skin · crackedL1 DOOR CUT OUT AFT LOWER THRESHOLD SKIN FASTENER HOLE CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2015050539309Plate · corrodedAFT CARGO BAY DOOR THRESHOLD COVER PLATE CORRODED ER HOLES BETWEEN BS 805 - 809, BETWEEN STRINGER 24R - 25R. R & R PLATE IAW DWG.SDR SWAA2015060340340Crease Beam · corrodedRIGHT CREASE BEAM CORRODED AT STATION 967 - 970. REPAIRED CREASE BEAM IAW SRM.SDR SWAA2015060340339Stringer · crackedLEFT STRINGER 18A CRACKED AT STATION 727. REPAIRED STRINGER IAW EA.SDR SWAA2015060240310Strap · crackedLEFT FUSELAGE FRAME STRAP CRACKED AT STATION 727, STRINGER 18A. REPAIRED FRAME IAW SRM.SDR SWAA2015060240298Strap · crackedRIGHT FUSELAGE FRAME STRAP CRACKED AT STATION 727, STRINGER 18A. REPAIRED FRAME IAW SRM.SDR SWAA2015060240297Frame · crackedRIGHT FUSELAGE FRAME CRACKED AT STATION 727, STRINGER 18A. REPAIRED FRAME IAW SRM.SDR SWAA2015060240294Frame · crackedLEFT FUSELAGE FRAME CRACKED AT STATION 727, STRINGER 18A. REPAIRED FRAME IAW SRM.SDR SWAA2015052740071Door Frame · crackedR1 GALLEY DOOR FWD LOWER REVEAL FRAME CRACKED AT BS 295, BETWEEN STRINGER 15R - 17R. R & R FRAME IAW SRM & DWG.SDR SWAA2015051839806Crease Beam · corrodedMAIN CABIN COMPARTMENT, R2 LOWER DOOR CUT OUT UPPER CREASE BEAM CORRODED BETWEEN BS 950 - 996, RBL 52. R & R CREASE BEAM IAW SRM & DWG.SDR SWAA2015042438887Frame · crackedFORWARD INTERIOR FUSELAGE, AFT SIDE OF FRAME WEB CRACKED AT BS 277, STRINGER 5L. R & R WEB IAW DWG & SRM.SDR SWAA2015042438874Angle · crackedFORWARD INTERIOR FUSELAGE AFT SIDE OF FRAME WEB ATTACH CLIP ANGLE CRACKED AT BS 277, STRINGER 5L. R & R CLIP IAW SRM & DWG.SDR SWAA2015041638586Frame · crackedFRAME WEB CRACKED BS 294.5, STRINGER 6R. REPAIRED FRAME SECTION IAW SRM.SDR SWAA2015032337687Seat Track · crackedPASSENGER CABIN FLOOR STRUCTURE, OTBD SEAT TRACK, INBD LOWER FLANGE, UPPER SURFACE CORRODED AT BS 328, RBL 52. R & R SEAT TRACK IAW SRM.SDR SWAA2015031737491Intercostal · crackedINTERCOSTAL CRACKED BETWEEN BS 312 TO BS 326, RBL 32. R & R INTERCOSTAL IAW SRM.SDR SWAA2015042739029Wedge · delaminatedLEFT WING TE INBD MID FLAP TE WEDGE, 30" OTBD FROM INBD EDGE BOTH SKINS DELAMINATED. REPAIRED WEDGE IAW WO.SDR SWAA2015022336822Slide · out of positionL2 DOOR EMER EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW MT.SDR SWAA2015022336821Door Frame · crackedR1 DOOR LOWER EDGE FRAME CRACKED AT LOWER AFT CORNER STOP FITTING. R & R DOOR IAW AMM.SDR SWAA2015022336820Slat · crackedLEFT WING NR 2 SLAT CRACKED. R & R SLAT IAW MM.SDR SWAA2014093032492Door · looseFIRST OFFICER'S ESCAPE ROPE DOOR LATCH LOOSE. SECURED ESCAPE ROPE DOOR IAW SIP.SDR SWAA2014071630038Strip · dirtyAFT CABIN FLOOR EMER EXIT STRIP DIRTY. CLEANED STRIP IAW AMM.SDR SWAA2014071630037Light · inoperativeRIGHT CABIN EMER BULLNOSE LIGHT INOPERATIVE AT ROW 19. REPAIRED LIGHT IAW MM.SDR SWAA2014052728371Light · inoperativeAFT SERVICE DOOR EMERGENCY EXIT LIGHT INOPERATIVE. R & R LIGHT IAW AMM.SDR SWAA2014052728370Light · inoperativeAFT ENTRY DOOR EMERGENCY EXIT LIGHT INOPERATIVE. R & R LIGHT IAW AMM.SDR SWAA2014052728369Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 680 TO BS 681, STRINGER 10R. REPAIRED SKIN IAW ER & EA.SDR SWAA2014032426425Slide · out of positionL1 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW MM.SDR SWAA2014021725222Girt Bar · out of adjustR1 DOOR EMERGENCY EVAC SLIDE GIRT BAR OUT OF ADJUSTMENT. ADJUSTED GIRT BAR IAW MT.SDR SWAA2014021325114Slide · looseR1 DOOR EMERGENCY EVAC SLIDE LOOSE. SECURED SLIDE IAW MT.SDR SWAA2014010223677Frame · crackedLT WING NR 1 FAIRING FLAP TRACK FRAME CRACKED. R & R FRAME IAW DRAWING & SRM.SDR SWAA2013121823507Tie Clip · crackedTIE CLIP CRACKED AT BS 360, STRINGER 16L. R & R TIE CLIP IAW SRM & DRAWING.SDR SWAA2013121923543Channel · crackedRT MAIN WW AREA CHANNEL CRACKED. R & R CHANNEL IAW SRM & DRAWING.SDR SWAA2013121723438Plate · crackedLT WING NR 3 SIDE TRACK FIXED TE PLATE CRACKED. R & R PLATE IAW DRAWING & SRM.SDR SWAA2013121623383Plate · crackedFWD CARGO COMPARTMENT PLATE CRACKED BETWEEN SIDEWALL PANEL 1321X & FLOOR PANEL 1326X. R & R PLATE IAW SRM & DRAWING.SDR SWAA2014010223676Frame · crackedFRAME CRACKED AT BS 348.2 STRINGER 15L. R & R FRAME IAW EA.
Back to N697SW, cancelled Oct 5, 2019