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 SWAA2014010923931Angle · crackedVERTICAL ANGLE CRACKED AT BS 967 STRINGER 2R. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014010923930Plate · crackedPLATE CRACKED BETWEEN BS 298 TO BS 314 STRINGER 4L. R & R PLATE IAW SRM & DRAWING.SDR SWAA2014010823872Structure · corrodedRT LOWER CHORD CORRODED BETWEEN BS 1112+3" TO BS 1121+17". R & R CHORD IAW SRM & DRAWING.SDR SWAA2014021125002Frame · crackedFRAME CRACKED AT BS 348.2, STRINGER 16L. REPAIRED FRAME IAW EA.SDR SWAA2014021024993Shear Web · crackedSHEAR WEB CRACKED AT BS 348.2, BETWEEN STRINGER 17L TO STRINGER 15L. R & R SHEAR WEB IAW EA.SDR SWAA2014021024992Frame · crackedFRAME INNER CHORD CRACKED AT BS 348.2, STRINGER 17L. REPAIRED CHORD IAW EA.SDR SWAA2014021024991Floorbeam · crackedFLOOR BEAM UPPER CHORD CRACKED AT BS 947.5, LBL 53.5. REPAIRED CHORD IAW EA.SDR SWAA2014021024940Structure · crackedFWD ENTRY DOOR STRUCTURE CRACKED AT BS 348.2, STRINGER 16L. REPAIRED STRUCTURE IAW EA.SDR SWAA2014020624904Frame · crackedFRAME CRACKED AT BS 277, BETWEEN STRINGER 15L TO STRINGER 16L. REPAIRED FRAME IAW EO.SDR SWAA2014020624903Frame · crackedFRAME CRACKED AT BS 277, BETWEEN STRINGER 15L TO STRINGER 16L. REPAIRED FRAME IAW EA.SDR SWAA2014020424835Beam · corrodedUPPER FLANGE OF FLOOR STRUCTURE BEAM CORRODED AT BS 328, RBL 49. R & R BEAM IAW SRM & DRAWING.SDR SWAA2014020424836Beam · corrodedUPPER FLANGE OF FLOOR STRUCTURE BEAM CORRODED AT BS 328 LBL 49. R & R BEAM IAW SRM & DRAWING.SDR SWAA2014020324772Beam · corrodedFLOOR STRUCTURE BEAM UPPER FLANGE CHORD CORRODED AT BS 328, BL 0. R & R CHORD IAW SRM & DRAWING.SDR SWAA2014020324771Sill · crackedFWD GALLEY DOOR CUTOUT SILL WEB CRACKED AT BS 294.5, STRINGER 17R. R & R WEB IAW SRM & DRAWING.SDR SWAA2014012924657Support Fitting · crackedSUPPORT FITTING CRACKED BETWEEN BS 291.5 TO BS 294.5 STRINGER 8R. R & R FITTING IAW SRM & DRAWING.SDR SWAA2014012824632Web · crackedWEB CRACKED BETWEEN BS 328 TO BS 344 LBL 44. R & R WEB IAW SRM & DRAWING.SDR SWAA2014012224399Frame · corrodedFRAME CORRODED AT BS 867 BETWEEN STRINGER 26L TO STRINGER 27L. REPAIRED FRAME IAW SRM.SDR SWAA2014012124361Support Angle · crackedRT WING TE SUPPORT ANGLE CRACKED AT RSS 544. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014012024279Strap · crackedAFT CARGO DOOR CUTOUT STRAP CRACKED AT BS 749.3 BETWEEN STRINGER 23R TO STRINGER 25R. R & R STRAP IAW SRM & DRAWING.SDR SWAA2014012024278Rib · crackedRT WING MID FLAP RIB CRACKED AT WBL 82. R & R RIB IAW SRM & DRAWING.SDR SWAA2014012024277Angle · crackedLT WING INBD FIXED TE STRUCTURE ANGLE CRACKED AT WBL 84. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014012024276Angle · crackedLT WING ANGLE CRACKED AT WBL 204.4. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014011624155Flap · delaminatedRT WING AFT FLAP DELAMINATED. REPAIRED AFT FLAP IAW SRM.SDR SWAA2014011624147Support Angle · crackedSUPPORT ANGLE CRACKED BETWEEN BS 277 TO BS 291.5 BETWEEN STRINGER 13R TO STRINGER 14R. R & R ANGLE IAW SRM.SDR SWAA2014011624146Tie Clip · crackedTIE CLIP CRACKED AT BS 294.5 STRINGER 12L. R & R TIE CLIP IAW SRM & DRAWING.SDR SWAA2014011424105Stiffener · crackedLT WING NR 3 FLAP TRACK FAIRING STIFFENER CRACKED AT WBL 183. R & R STIFFENER IAW SRM & DRAWING.SDR SWAA2014011424101Bracket · crackedBRACKET CRACKED AT BS 294.5 STRINGER 4R. R & R BRACKET IAW SRM & DRAWING.SDR SWAA2014011424100Tie Clip · crackedTIE CLIP CRACKED AT BS 277 STRINGER 10R. R & R TIE CLIP IAW SRM & DRAWING.SDR SWAA2014011324061Floorbeam · corrodedFLOOR BEAM UPPER FLANGE CORRODED AT BS 312 LBL 8. REPAIRED BEAM IAW SRM.SDR SWAA2014011324060Bracket · crackedRT WING NR 8 FLAP TRACK BRACKET CRACKED. R & R BRACKET IAW SRM & DRAWING.SDR SWAA2014011324059Support Angle · crackedRT WING NR 6 FLAP TRACK FAIRING INBD LOWER SIDE SUPPORT ANGLE CRACKED. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014011324058Reveal · crackedFWD SERVICE DOOR FWD UPPER CORNER REVEAL CRACK BETWEEN BS 294.5 TO BS 312, BETWEEN STRINGER 7R TO STRINGER 8R. R & R REVEAL IAW SRM & DRAWING.SDR SWAA2014010923929Angle · crackedLT WING INBD FIXED TE STRUCTURE ANGLE CRACKED ON WBL 183.4. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014021225081Skin · crackedFUSELAGE SKIN CRACKED AT BS 787+16, STRINGER 18L. REPAIRED SKIN IAW EA.SDR SWAA2014021024990Skin · crackedSKIN CRACKED AT BS 787+11.5, STRINGER 18L. REPAIRED SKIN IAW EA.SDR SWAA2014021024989Skin · crackedSKIN CRACKED AT BS 747+16, STRINGER 25L. R & R SKIN IAW EA.SDR SWAA2014021024988Skin · crackedSKIN CRACKED AT BS 767+6.25, STRINGER 25L. R & R SKIN IAW EA.SDR SWAA2014021024987Skin · crackedSKIN CRACKED AT BS 807+7, STRINGER 24L. R & R SKIN IAW EA.SDR SWAA2014021024986Skin · crackedSKIN CRACKED AT BS 807+13, STRINGER 23L. R & R SKIN IAW EA.SDR SWAA2014021024985Floor Support · crackedLONGITUDINAL FLOOR BEAM LOWER CHORD CRACKED AT BS 663, RBL 24.08. REPAIRED CHORD IAW EA.SDR SWAA2014021024979Skin · crackedSKIN CRACKED AT BS 767+8, STRINGER 25L. R & R SKIN IAW EA.SDR SWAA2014021024939Skin · crackedSKIN CRACKED AT BS 908+12.75, STRINGER 23L. REPAIRED SKIN IAW EO & EA.SDR SWAA2014021024938Skin · crackedSKIN CRACKED AT BS 927+3.5, STRINGER 21L. REPAIRED SKIN IAW EO & EA.SDR SWAA2014021024937Plate · crackedLT WING UPPER SURFACE TE PLATE CRACKED BETWEEN WING STATION 391 TO WING STATION 402 IN UPPER SURFACE. R & R PLATE IAW SRM & DRAWING.SDR SWAA2014021024936Plate · crackedRT WING NR 8 SPOILER PLATE CRACKED. R & R PLATE IAW SRM & DRAWING.SDR SWAA2014012024275Plate · crackedRT WING PLATE CRACKED AT WBL 204.40. R & R PLATE IAW SRM & DRAWING.SDR SWAA2014011624145Lens · brokenGALLEY NR 4 EMERGENCY EXIT LENS BROKEN. R & R LENS IAW AMM.SDR SWAA2014010223744Floorbeam · crackedFLOOR BEAM WEB LOWER CHORD CRACKED AT BS 708, LBL 24.8. REPAIRED CHORD IAW EA.SDR SWAA2014021024978Pressure Deck · crackedMAIN WW PRESS DECK WEB CRACKED AT BS 663.75+1.5, LBL 24.5+14.5. REPAIRED WEB IAW EA.SDR SWAA2014021024935Door Frame · crackedFWD GALLEY DOOR AFT FRAME CRACKED. R & R DOOR IAW SRM.
Back to N528SW, cancelled Mar 27, 2018