N526SW, cancelled Mar 27, 2018
Service difficulty reports · 422
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 = 'N526SW' AND deregistration_id = 'N526SW-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 = 'N526SW' AND deregistration_id = 'N526SW-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 SWAA2013090319766Angle · crackedR1 DOOR CUTOUT ANGLE CRACKED AT BS 291.5, BETWEEN STRINGER 9R TO STRINGER 10R. R&R ANGLE IAW SRM & DRAWING.SDR SWAA2013102221349Angle · crackedRT WING INTERNAL AREA TE ANGLE CRACKED AT RSS 238+7. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2013091220100Skin · crackedSKIN CRACKED AT BS 951 + 1, STRINGER 11L. REPAIRED SKIN IAW SRM.SDR SWAA2013091020033Angle · crackedRT WING TE ANGLE CRACKED AT WBL 184.40. R&R ANGLE IAW SRM & DRAWING.SDR SWAA2013091020032Support Angle · crackedSTRUCTURE SUPPORT ANGLE INTERNAL CAVITY OF PYLON ACCESS PANEL NR 5858R CRACKED. R&R ANGLE IAW DRAWING & SRM.SDR SWAA2013090919965Lens · brokenBROKEN EMERGENCY EXIT LENS ON WALL OF GALLEY 4. R&R LENS IAW AMM.SDR SWAA2013090919964Support Angle · crackedSUPPORT ANGLE CRACKED AT INTERNAL AREA OF ACCESS PANEL NÏ¿½ 5757L ON STRUT TORQUE BOX OTBD SIDE NR 1 ENGINE. R&R ANGLE IAW SRM & DRAWING.SDR SWAA2013090419836Intercostal · crackedINTERCOSTAL CRACKED BETWEEN BS 927 TO BS 947.5, BL 0. R&R INTERCOSTAL IAW SRM & DRAWING.SDR SWAA2013090319765Angle · crackedRT WING NR 6 FLAP TRACK FAIRING OTBD SIDE TE ANGLE CRACKED AT WBL 202.60. R&R ANGLE IAW SRM & DRAWING.SDR SWAA2013083019747Skin Panel · crackedLT WING FIXED LE LOWER SKIN PANEL CRACKED. REPAIRED PANEL IAW EA.SDR SWAA2013083019741Skin Panel · crackedRT WING FIXED LE LOWER SKIN PANEL CRACKED. REPAIRED PANEL IAW EA.SDR SWAA2013100120601Skin · crackedSKIN CRACKED AT BS 887+ 14 STRINGER 25R. REPAIR SKIN IAW SRM.SDR SWAA2013092620543Floor Support · crackedLONGITUDINAL FLOOR BEAM WEB CRACKED AT BS 708 RBL 24.8 CENTER WING BOX. REPAIRED WEB IAW EA.SDR SWAA2013092620542Floor Support · crackedLONGITUDINAL FLOOR BEAM UPPER CHORD CRACKED AT BS 666 RBL 24.8 CENTER WING BOX. REPAIRED CHORD IAW EA.SDR SWAA2013102321415Stiffener · crackedSTIFFENER CRACKED AT BS 663, RBL 7. R & R STIFFENER IAW SRM.SDR SWAA2013100320768Skin · crackedRT WING FIXED LE INBD SKIN CRACKED AT BS 208. REPAIRED SKIN IAW EA.SDR SWAA2013091220099Skin · crackedSKIN CRACKED AT BS 887+14, STRINGER 25R. REPAIRED SKIN IAW EA.SDR SWAA2013090919963Cap · crackedLT WING NR 1 FLAP TRACK FWD FAIRING EDGE CAP CRACKED. R&R CAP IAW DWG.SDR SWAA2013090419835Angle · crackedFWD BULKHEAD WW ANGLE CRACKED AT BS 727, RBL 15. R&R ANGLE IAW SRM & DRAWING.SDR SWAA2013102821581Skin · crackedSKIN CRACKED AT BS 727, STRINGER 18A LT SIDE. REPAIRED SKIN IAW EA.SDR SWAA2013102321413Structure · crackedCHORD CRACKED AT BS 727, STRINGER 18A RT SIDE. REPAIRED CHORD IAW EA.SDR SWAA2013070417927Battery · dischargedFWD OTBD FLASHLIGHT LED INOPERATIVE. R&R BATTERY IAW MM.SDR SWAA2013061817260Spindle · corrodedRT WING NR 7 SPINDLE LOWER SURFACE ROOT CORRODED. R&R NR 7 FLAP SPINDLE CARRIAGE PER MT.SDR SWAA2013021912766Shear Tie · crackedSHEAR TIE REPAIR CRACKED AT BS 360 BETWEEN STRS 14 AND 15. REMOVED CRACKED SHEAR TIE AND INSTALLED REPAIR SHEAR TIE BS 360 STR 14-15 RT IAW SRM 53-00-07-2R-8 REP 2 STEPS 1-11. 87529U, 17FEB13SDR SWAA2013022212987Skin · crackedFUSELAGE LOWER LOBE, CHEM-MILL CRACK AT BS 932, UNDER STR 21RT. REPAIRED SKIN IAW ER & EA 1-553-21838.SDR SWAA2013022212986Skin · crackedFUSELAGE LOWER LOBE, CHEM-MILL CRACK AT BS 932, UNDER STR 21RT. REPAIRED SKIN IAW ER & EA 1-553-21838.SDR SWAA2013022112954Skin · crackedFUSELAGE UPPER LOBE, CHEM-MILL CRACK, BELOW STR 15 RT, BS 482B+14, NO POP THROUGH. REPAIRED CHEM-MILL CRACK AT BS 482B + 14 STR 15R PER ER 13-01462 AND EA 1-553-21794.SDR SWAA2013022112953Skin · crackedFUSELAGE UPPER LOBE SKIN CRACKED VERTICALLY AT CHEM-MILL POCKET, 3" BELOW STR 5RT, 1" AFT OF BS 360 BUTT JOINT, CRACK IS 1" LONG, WITH NO POP THROUGH. REPAIRED DAMAGE IN FUSE SKIN STR 5 RT 1" AFT OF 360 BUTT JOINT IAW ER 13-01463 AND EA 1-553-21810.SDR SWAA2013021912765Skin · crackedFUSE LWR LOBE, CHEM-MILL CRACK AT BS 772, OVER STR 24LT. INSTALLED REPAIR FOR CHEM-MILL CRACK AT BS 772, OVER STR 24 LT, FUSELAGE LOWER LOBE IAW SRM 53-00-01-2R-3. 43976U, 16FEB13. FURTHER ACTION IS REQUIRED.SDR SWAA2012122810943Battery Pack · dischargedFWD ENTRY EMERGENCY LIGHTS INOP. REMOVED AND REPLACED FWD GALLEY BATTERY PACK ASSY PER AMM. OPS CHECK GOOD.SDR SWAA2012112309882Outflow Valve · faultyDECLARED EMERGENCY - CABIN ALT WARNING HORN SOUNDED WHILE CLIMBING ABOVE FL 260. BOTH PACK SWITCHES IN AUTO POSITION BOTH BLED SWITCHES IN POSITION. ISO VALVE IN AUTO MODE. EMERGENCY DESCENT INITIATED. LEVELED OFF AT 10,000 FT / PASSENGER OXYGEN MASKS NEVSDR SWAA2012101508521Skin · crackedSKIN CRACKED AT BS 405, STR 16R. REPAIRED SKIN PER EA.SDR SWAA2012092708067Hook · dirtyR2 DOOR EMERGENCY EVAC SLIDE GIRT BAR DIFFICULT TO OPERATE DUE TO DEBRIS. CLEANED & LUBED HOOKS PER M/M.SDR SWAA2012091307583Skin · crackedSKIN CRACKED AT BS 430+5, STR 1. REPAIRED SKIN PER EA.SDR SWAA2012090407314Light · inoperativeR1 DOOR EXTERIOR EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER MM.SDR SWAA2012090607408Skin · crackedSKIN FUSELAGE CRACKED BETWEEN BS 979 TO BS 982, STR 21L. REPAIRED SKIN IAW ER AND EA.SDR SWAA2012090407313Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 979 TO BS 982, STR 21L. REPAIRED SKIN PER SRM.SDR SWAA2012083007200Light · damagedEEPLS DAMAGED BETWEEEN ROW 6 TO ROW 8. REMOVED AND REPLACED EEPLS PER MM.SDR SWAA2012083007199Flap · delaminatedRIGHT WING NR 8 O/B AFT FLAP DELAMINATED. REMOVED AND REPLACED AFT FLAP PER AMM.SDR SWAA2012083007198Cover · looseLEFT EEPLS COVER LOOSE AT ROW 6. REMOVED AND REPLACED EEPLS PER MM.SDR SWAA2012080106376Fitting · out of adjustR2 DOOR EMERGENCY EVAC SLIDE GIRT BAR CLIP OUT OF ADJUST. ADJUSTED CLIP PER MM.SDR SWAA2012052904408Hinge Fitting · brokenLEFT I/B GROUND SPOILER O/B HINGE FITTING BROKEN. REMOVED AND REPLACED NR 4 GROUND SPOILER PER MM.SDR SWAA120053Light · looseLT EEPLS LOOSE AT ROW 6. SECURED EEPLS PER MM.SDR SWAA118666Bear Strap · corrodedDURING SCHEDULED 20Y CHECK, FOUND FUSELAGE SKIN BEAR STRAP CORRODED AT BS 967, STR 26R TO STR 27L. REPAIRED BEAR STRAP PER EA.SDR SWAA118633Shear Tie · corrodedDURING SCHEDULED 20Y CHECK, FOUND SHEAR TIE CORRODED AT BS 520, BETWEEN STR 27L TO KEEL BEAM LOWER LT CHORD. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA118632Shear Tie · corrodedDURING SCHEDULED 20Y CHECK, FOUND SHEAR TIE CORRODED AT BS 767, BETWEEN STR 26R TO STR 27R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA118631Shear Tie · corrodedDURING SCHEDULED 20Y CHECK, FOUND SHEAR TIE CORRODED AT BS 747, BETWEEN STR 26L TO STR 27L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA118603Shear Tie · corrodedDURING SCHEDULED 20Y CHECK, FOUND SHEAR TIE CORRODED AT BS 787, BETWEEN STR 25L TO STR 26L. REMOVED AND REPLACED SHEAR TIE IAW SRM.SDR SWAA118602Shear Tie · corrodedDURING SCHEDULED 20Y CHECK, FOUND SHEAR TIE CORRODED AT BS 767, BETWEEN STR 26R TO STR 27R. REMOVED AND REPLACED SHEAR TIE IAW SRM.SDR SWAA118601Failsafe · corrodedDURING SCHEDULED 20Y CHECK, FOUND FAIL-SAFE CHORD CORRODED AT BS 747, BETWEEN STR 27R TO STR 27L. REMOVED AND REPLACED CHORD IAW SRM.
Back to N526SW, cancelled Mar 27, 2018