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 SWAA2013121723437Skin · crackedLT WING NR 2 SLAT OTBD EDGE LOWER SKIN CRACKED. REPAIRED SKIN IAW SRM.SDR SWAA2014010223684Intercostal · crackedINTERCOSTAL WEB CRACKED AT THE FWD ENTRY DOOR SURROUND STRUCTURE BETWEEN BS 348.2 & BS 360 STRINGER 16L. R & R WEB IAW EO.SDR SWAA2013121923555Skin · crackedSKIN CRACKED AT STATION 824 OF THE AFT CARGO COMPARTMENT DOOR. REPAIRED SKIN IAW EA.SDR SWAA2014010223683Bear Strap · crackedBEAR STRAP CRACKED FOUND ON FWD GALLEY DOOR CUT OUT FWD LOWER CORNER LOCATED AT BS 294.5+5 STRINGER 17R. REPAIRED CUT OUT IAW EA.SDR SWAA2013121123228Plate · crackedLT HORIZONTAL STABILIZER ACCESS PANEL 9124L PLATE CRACKED. R & R PLATE IAW SRM & DRAWING.SDR SWAA2013121123212Strap · crackedEE COMPARTMENT UPPER SURFACE STRAP CRACKED AT STATION 328, LBL 12. R & R STRAP IAW SRM & DRAWING.SDR SWAA2014010223675Skin · crackedFWD GALLEY DOOR ON UPPER HINGE POSITION SKIN CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014010223674Structure · crackedCTR WING BOX UPPER CHORD AFT END OTBD FLANGE CRACKED AT BS 727B RBL 24.8. REPAIRED CHORD IAW EA.SDR SWAA2013121723436Floor Support · crackedLONGITUDINAL FLOOR BEAM UPPER CHORD CRACKED AT BS 661, LBL 0.07. REPAIRED CHORD IAW EA.SDR SWAA2013121723435Floor Support · crackedLONGITUDINAL FLOOR BEAM UPPER CHORD CRACKED AT BS 661, LBL 0.07. REPAIRED CHORD IAW EA.SDR SWAA2013121123211Angle · crackedFWD ENTRY DOOR FWD EDGE UPPER CORNER ANGLE CRACKED. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2013071818342Intercostal · crackedAFT CARGO DOOR HOLD OPEN LATCH BRACKET INTERCOSTAL CRACKED. R&R INTERCOSTAL IAW DRAWING.SDR SWAA2013062617630Reveal · crackedUPPER AFT CORNER REVEAL CRACKED ON FWD GALLEY SERVICE DOOR OPENING. REPAIRED REVEAL IAW EA.SDR SWAA2013062517606Skin · crackedUPPER FWD CORNER REVEAL CRACKED ON FWD GALLEY SERVICE DOOR OPENING. REPAIRED SKIN IAW EA.SDR SWAA2013050115435Slide · unsecureR1 DOOR EMERGENCY EVAC SLIDE FELL OUT. REMOVED & REPLACED SLIDE IAW AMM.SDR SWAA2013041814997Mount Bracket · crackedR2 DOOR EMERGENCY EVAC SLIDE AFT MOUNT BRACKET CRACKED. REMOVED AND REPLACED BRACKET PER AMM.SDR SWAA2013032814231Skin · crackedFUSELAGE SKIN CRACKED AT BS 580, STR 10L. REPAIRED SKIN PER EA.SDR SWAA2013022513087Fluid · leakingAIR TURNBACK/DECLARED EMERGENCY -- TOWER NOTED SIGNIFICANT FLUID COMING FROM LEFT WING ON TAKEOFF AND ADVISED CREW AIRBORNE. COCKPIT VERIFIED LEAK, DECLARED EMERGENCY, AND RETURNED TO AND. DEFERRED PER MEL. ON 2-26-13, FLOAT SWITCH OPERATED NORMAL.SDR SWAA2012091107522Sign · crackedFORWARD OVERHEAD EMERGENCY EXIT SIGN CRACKED. REMOVED AND REPLACED SIGN PER AMM.SDR SWAA2012070205418Battery · dischargedOVERWING EXTERIOR EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY ASSY PER MM.SDR SWAA2012070205403Battery · dischargedAFT OVERHEAD EMERGENCY EXIT BULLNOSE LIGHTS INOP. REMOVED AND REPLACED BATTERY ASSY PER MM.SDR SWAA2012062005088Wire · damagedAIR TURNBACK/DECLARED EMERGENCY -- AFTER TAKEOFF AT 1000FT APU FIRE, FIRED BOTTLE RAN QRH RETURNED TO FIELD NORMAL LANDING AT 116.5, MINIMAL BRAKING. FOUND DAMAGE WIRE FWD BULKHEAD OF APU COMPARTMENT. REPAIRED WIRE AS PER STANDARD WIRING PRACTICE MANUAL. RESDR SWAA2012061404949Attach Fitting · brokenLEFT WING NR 4 GROUND SPOILER O/B ATTACH LUG BROKEN. REMOVED AND REPLACED SPOILER PER MM.SDR SWAA2012052904379Light · inoperativeR1 DOOR EXTERIOR EMERGENCY LIGHT INOP. RELAMPED LIGHT PER AMM.SDR SWAA2012021301409Lens · brokenBROKEN EMERGENCY EXIT LENS LOCATED AT FWD LAVATORY. REPLACED LENS LOCATED IAW AMM.SDR SWAA2012021001332Lens · looseRT EMERGENCY EXIT LIGHT LENS LOOSE. REMOVED AND REPLACED LENS IAW AMM.SDR SWAA2012021001331Light · inoperativeR2 DOOR EMERGENCY EXIT LIGHT BULB INOP. REPLACED BULB IAW AMM.SDR SWAA120743Web · crackedDURING SCHEDULED 24Y CHECK, FOUND WEB CRACKED AT BS 294.5, STR 17R. REMOVED AND REPLACED WEB IAW SRM AND DWG.SDR SWAA120741Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED BETWEEN BS 663.75 TO BS 675.75, LBL 24.5. REPAIRED CHORD IAW EA.SDR SWAA120669Web · crackedDURING SCHEDULED 24Y CHECK, FOUND RT NOSE LANDING GEAR WHEEL WELL SIDE WEB CRACKED BETWEEN BS 243.7 TO BS 251.625, WL 170. REPAIRED WEB IAW EA.SDR SWAA120667Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED BETWEEN BS 663.75 TO BS 674.75, RBL 24.5. REPAIRED CHORD IAW EA.SDR SWAA120661Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND AFT GALLEY DOOR CUTOUT FWD LOWER CORNER CRACKED AT BS 951+11, STR 17R. REPAIRED SKIN IAW SRM.SDR SWAA120656Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND FLOORBEAM CRACKED AT BS 711.5, BBL 0.07. REPAIRED BEAM IAW EAO.SDR SWAA120623Battery Pack · inoperativeDURING SCHEDULED 24Y CHECK, FOUND RT EMERGENCY EXIT LIGHT INOP AT BS 627. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA120622Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727E, STR 20L. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA120584Stringer · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CRACKED AT BS 500D, STR 21R. REPAIRED STRINGER IAW SRM AND DWG.SDR SWAA2012021301411Spar · corrodedRIGHT HORIZONTAL STABILIZER REAR SPAR CHORD CORRODED AT STAB 306.79. REPAIRED CHORD IAW EA AND EO.SDR SWAA2012021301410Skin · delaminatedRIGHT HORIZONTAL STABILIZER DELAMINATED ON UPPER SKIN AT STA 247.81. REPAIRED SKIN IAW SRM.SDR SWAA120482Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM WEB CRACKED AT BS 707, LBL 24.5. REPAIRED WEB IAW EA.SDR SWAA120457Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM WEB CRACKED AT BS 707, RBL 24.5. REPAIRED WEB IAW SRM AND EA.SDR SWAA120456Shear Tie · crackedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CRACKED AT BS 987, STR 26R. REMOVED AND REPLACED SHEAR TIE IAW SRM AND DWG.SDR SWAA120337Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 380, STR 16R. REPAIRED FRAME IAW SRM.SDR SWAA120336Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500D, STR 19R. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA120335Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 947.5, STR 26R. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA120334Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 727E, BETWEEN STR 27R TO BL 0. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2012021001330Stiffener · crackedMAIN WHEEL WELL REAR SPAR STIFFENER CRACKED AT LBL 6.15. REPAIRED STIFFENER IAW EO & EA.SDR SWAA120234Stringer Splice · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER SPLICE CRACKED AT BS 360, STR 4L. REMOVED AND REPLACED SPLICE PER SRM AND DWG.SDR SWAA120233Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 232.7, STR 20L. REMOVED AND REPLACED FRAME IAW SRM AND DWG.SDR SWAA120232Light · crazedDURING SCHEDULED 24Y CHECK, FOUND EEPLS CRAZED. REMOVED AND REPLACED EEPLS PER MM.SDR SWAA120231Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 747, BETWEEN STR 26L TO STR 27L. REPAIRED SHEAR TIE IAW SRM.
Back to N697SW, cancelled Oct 5, 2019