N528SW, cancelled Mar 27, 2018
Service difficulty reports · 353
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 = 'N528SW' AND deregistration_id = 'N528SW-2018-03-27' 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 = 'N528SW' AND deregistration_id = 'N528SW-2018-03-27' 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 SWAA2014020524894Floor Support · crackedLONGITUDINAL FLOOR BEAM UPPER CHORD AFT END CRACKED AT BS 727B, LBL 45.5. REPAIRED CHORD IAW EO & EA.SDR SWAA2014020524862Seat Track · crackedFLOOR BEAM UPPER CHORD SEAT TRACK CRACKED AT BS 727B, LBL 44.5. REPAIRED SEAT TRACK IAW EO & EA.SDR SWAA2014020524872Seat Track · crackedFLOOR BEAM UPPER CHORD SEAT TRACK CRACKED AT BS 727B, LBL 46.5. REPAIRED SEAT TRACK IAW EO & EA.SDR SWAA2014013024679Light · delaminatedFWD CABIN EEPLS DELAMINATED. R & R EEPLS IAW AMM.SDR SWAA2014012024274Plate · crackedPLATE CRACKED AT BS 1112 STRINGER 8R. R & R PLATE IAW SRM & DRAWING.SDR SWAA2014011324057Holder · brokenFWD LAVATORY FLASHLIGHT HOLDER BROKEN. R & R HOLDER IAW MM.SDR SWAA2014010723814Floor Support · crackedLONGITUDINAL FLOOR BEAM WEB CRACKED AT BS 709 LBL 24.8. REPAIRED WEB IAW EA.SDR SWAA2013112622792Skin · crackedFUSELAGE SKIN CRACKED AT BS 814, STRINGER 20L. REPAIRED SKIN IAW SWA EA.SDR SWAA2013112222729Flap Track · corrodedLT WING NR 2 TE FLAP TRACK CORRODED ON UPPER SURFACE. R & R FLAP TRACK ASSEMBLY IAW MM.SDR SWAA2013112622791Skin · crackedFUSELAGE SKIN CRACKED AT BS 446, STRINGER 16R. REPAIRED SKIN IAW SWA EA.SDR SWAA2013112622790Skin · crackedFUSELAGE SKIN CRACKED AT BS 923, STRINGER 21R. REPAIRED SKIN IAW SWA EA.SDR SWAA2013112622789Skin · crackedFUSELAGE SKIN CRACKED AT BS 823, STRINGER 20L. REPAIRED SKIN IAW SWA EA.SDR SWAA2013112122658Skin · crackedSKIN CRACKED AT BS 312, BETWEEN STRINGER 19R TO 20R. REPAIRED SKIN IAW SRM.SDR SWAA2013100820972Light · inoperativeRT EEPLS INOPERATIVE AT ROW 5. R & R BULB IAW AMM.SDR SWAA2013081219009Skin · crackedFS SKIN CRACKED AT STATION 827, STRING 24L. REPAIRED SKIN IAW SRM.SDR SWAA2013070317876Skin · crackedL1 DOOR CRACKED AT INNER SKIN LOWER HINGE BOX. R&R DOOR ASSEMBLY IAW AMM.SDR SWAA2013070317899Escape Rope · out of adjustRT EMERGENCY EXIT OVERWATER ROPE OUT OF ADJUSTMENT. ADJUSTED ROPE IAW AMM.SDR SWAA2013052416459Skin · crackedSKIN CRACKED AT STA 767+4.6, STR 18L. REPAIRED SKIN IAW EA.SDR SWAA2013052416460Skin · crackedFUSELAGE SKIN CRACKED AT STA 767+12, STR -18L. REPAIRED SKIN IAW EA.SDR SWAA2013040314458Stringer · crackedSTRINGER CRACKED AT BS 360 + 9.5, STR 16L. REMOVED AND REPLACED STRINGER IAW AAR EA.SDR SWAA2013040314457Skin · delaminatedRIGHT WING NR 6 SLAT WEDGE UPPER SKIN DELAMINATED. REMOVED AND REPLACED NR 6 SLAT IAW AMM.SDR SWAA2013020812446Skin · crackedFUSELAGE SKIN CRACKED AT STA 520, STR 16R. REPAIRED SKIN IAW SRM.SDR SWAA2013020412279Skin · crackedFUSELAGE SKIN HAS A 1.4" CRACK, JUST ABOVE STR 24L AT STA. 785, 1.2" VISABLE AND .2" SUB SURFACE. REPAIRED PER E/A 1-553-21601 FACT AS A RESULT OF POST REPAIR INSPECTION.SDR SWAA2012112609789Lens · brokenFWD ENTRY EMERGENCY EXIT LIGHT NEAR FLOOR HAS BROKEN LENS. REPLACED LIGHT ASSY PER AMM, OPS CHECK GOOD.SDR SWAA2012102908924Skin · crackedR1 DOOR FUSELAGE SKIN CRACKED AT UPPER HINGE CUTOUT. REMOVED AND REPLACED DOOR IAW M/M.SDR SWAA2012111509419Support Angle · crackedLOWER SUPPORT ANGLE CRACKED - I/B SIDE OF NR 3 FLAP TRACK FAIRING CUTOUT (MARKED). REMOVED AND REPLACED LOWER SUPPORT ANGLE I/B SIDE NR 3 FLAP TRACK FAIRING PER SRM 51-40-02.SDR SWAA2012102908926Support Fitting · crackedSUPPORT CLIP CRACKED ON REAR SPAR AT UPPER CHORD. REPAIRED CLIP PER BOEING DWG & SRM.SDR SWAA2012102908925Skin · delaminatedRIGHT WING NR 5 GROUND SPOILER PANEL UPPER OUTBOARD SURFACE DELAMINATED. REMOVED AND REPLACED NR 5 SPOILER PER AMM.SDR SWAA2012101108430Light · inoperativeLEFT EMERGENCY EXIT LIGHT INOP AT BS 727. RELAMPED LIGHT PER M/M.SDR SWAA2012080806608Battery Pack · dischargedRIGHT AFT CABIN EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK PER AMM.SDR SWAA2012061905057Slide · looseR2 DOOR EMERGENCY EVAC SLIDE LOOSE. SECURED SLIDE IAW MT.SDR SWAA2012053004455Light · inoperativeRIGHT OVERWING EMERGENCY EXIT LIGHT INOP. REMOVED & REPLACED LIGHT ASSEMBLY IAW M/M.SDR SWAA120297Flap · delaminatedDURING SCHEDULED 10Y CHECK, FOUND RT WING O/B AFT FLAP I/B SIDE OF T/E DELAMINATED. REPAIRED AFT FLAP IAW SRM.SDR SWAA120296Fitting · crackedDURING SCHEDULED 20Y CHECK, FOUND BULKHEAD FITTING CRACKED AT BS 727, RBL 45.5. REMOVED AND REPLACED FITTING IAW SRM AND DWG.SDR SWAA120295Angle · corrodedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO COMPARTMENT FRAME ANGLE CORRODED AT BS 767, BETWEEN STR 27L TO STR 26R. REPAIRED ANGLE IAW EO.SDR SWAA120294Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 727B, RBL 45.5. REPAIRED CHORD IAW EA.SDR SWAA120293Floorbeam · corrodedDURING SCHEDULED 20Y CHECK, FOUND FLOORBEAM UPPER CHORD T-ANGLE CORRODED AT BS 986.5, RBL 44. REPAIRED CHORD IAW EO.SDR SWAA120292Keelbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND KEEL BEAM CORRODED AT BS 520+2, STR 28L. REPAIRED BEAM IAW SRM AND EA.SDR SWAA120291Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 482, BETWEEN STR 19L TO STR 23L. REPAIRED FRAME IAW EA.SDR SWAA120290Door Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO DOOR FRAME CRACKED AT LOWER CORNER. REMOVED AND REPLACED FRAME IAW MM.SDR SWAA120248Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN CRACKED AT L2 DOOR AFT UPPER CORNER, BS 992.8-4, STR 7L. REPAIRED SKIN IAW SRM.SDR SWAA120246Frame · corrodedDURING SCHEDULED 20Y CHECK, FOUND FWD CARGO COMPARTMENT FRAME CORRODED AT BS 482A, BETWEEN STR 27R TO STR 28R. REPAIRED FRAME IAW SRM.SDR SWAA120245Frame · corrodedDURING SCHEDULED 20Y CHECK, FOUND FWD CARGO COMPARTMENT FRAME CORRODED AT BS 482A, BETWEEN STR 28L TO STR 28R. REPAIRED FRAME IAW SRM.SDR SWAA120214Wedge · delaminatedDURING SCHEDULED 20Y CHECK, FOUND RT WING I/B MID FLAP T/E WEDGE DELAMINATED. REMOVED AND REPLACED MID FLAP IAW MM.SDR SWAA120213Web · crackedDURING SCHEDULED 20Y CHECK, FOUND NOSE LANDING GEAR WHEEL WELL LT WEB CRACKED AT BS 235.7+3.25, WL 170. REPAIRED WEB IAW EA.SDR SWAA120212Web · crackedDURING SCHEDULED 20Y CHECK, FOUND NOSE LANDING GEAR WHEEL WELL LT WEB CRACKED AT BS 243.7+3.5, WL 170. REPAIRED WEB IAW EA.SDR SWAA120134Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 482A, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME IAW SRM.SDR SWAA120098Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 947.5, STR 25R. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA120055Stringer Clip · corrodedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CORRODED BETWEEN BS 727B TO BS 727C, STR 17R. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA120054Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 927, STR 25L. REMOVED AND REPLACED CLIP IAW SRM AND DWG.
Back to N528SW, cancelled Mar 27, 2018