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 SWAA2014090231449Flap · delaminatedLEFT WING OTBD AFT FLAP DELAMINATED. R & R AFT FLAP IAW MM.SDR SWAA2014052728373Battery Pack · dischargedL1 DOOR EMERGENCY EXIT LIGHT INOPERATIVE. R & R BATTERY PACK IAW AMM.SDR SWAA2014051427919O-Ring · failedDIVERSION, SYS A HYD FAILURE INFLIGHT. FOUND FAILED O RING ON A SYS MODULE. R & R O RING ON A SYS MODULE IAW SIP.SDR SWAA2014022125407Bracket · looseRT WING NR 5 SPOILER IND ACTUATOR BRACKET LOOSE AT FWD ATTACHMENT. REPAIRED BRACKET IAW EA.SDR SWAA2013102821592Battery Pack · inoperativeFORWARD LT EMERGENCY EXIT LIGHTS BATTERY PACK INOPERATIVE. R &R BATTERY PACK IAW MM.SDR SWAA2013102821584Battery Pack · dischargedRT EMERGENCY LIGHTS INOPERATIVE AT ROW 4. R & R BATTERY PACK IAW AMM.SDR SWAA2013102821578Battery Pack · dischargedL1 DOOR EMERGENCY LIGHTS INOPERATIVE. R & R BATTERY PACK IAW AMM.SDR SWAA2013102321421Skin · crackedSKIN CRACKED AT BS 767+1, STRINGER 19L. REPAIRED SKIN IAW EA.SDR SWAA2013102321420Skin · crackedSKIN CRACKED AT BS 747, STRINGER 19L. REPAIRED SKIN IAW EA.SDR SWAA2013102821591Skin · crackedSKIN CRACKED AT BS 887, STRINGER 19L. REPAIRED SKIN IAW EO & EA.SDR SWAA2013102821590Skin · crackedSKIN CRACKED AT BS 867, STRINGER 19L. REPAIRED SKIN IAW EO & EA.SDR SWAA2013102321419Skin · crackedSKIN CRACKED AT BS 747 + 13, STRINGER 19L. REPAIRED SKIN IAW EA.SDR SWAA2013102821589Skin · crackedSKIN CRACKED AT BS 847, STRINGER 19L. REPAIRED SKIN IAW EO & EA.SDR SWAA2013100820971Tie Clip · crackedTIE CLIP CRACKED AT BS 847 STRINGER 20L. R & R TIE CLIP IAW SRM & DRAWING.SDR SWAA2013100220663Cover · crackedLT WING NR 3 FLAP CARRIAGE BUMPER PLATE COVER CRACKED. R & R COVER IAW CMM.SDR SWAA2013100120616Support Angle · crackedLT WING SUPPORT ANGLE AT INTERNAL STRUCTURE CRACKED AT WBL 183.40 OF FLAP TRACK FAIRING. R & R CLIP IAW SRM & DRAWING.SDR SWAA2013100220679Flap · delaminatedLT WING INBD CORNER OF INBD AFT FLAP DELAMINATED. REPAIRED AFT FLAP IAW SRM.SDR SWAA2013091820229Stringer · crackedSTRINGER CRACKED BETWEEN BS 747 TO BS 767, STRINGER 22L. REPAIRED STRINGER IAW SRM.SDR SWAA2013091120074Shear Tie · crackedSHEAR TIE ANGLE CRACKED AT BS 747, BETWEEN STRINGER 22L TO STRINGER 23L. R&R ANGLE IAW SRM & DRAWING.SDR SWAA2013091820228Stiffener · crackedSTIFFENER "Z" CRACKED BS 1016, STRINGER 18L. R & R STIFFENER IAW SRM & DRAWING.SDR SWAA2013092320336Angle · crackedANGLE CRACKED AT BS 1016 + 11 LBL 29. R & R ANGLE IAW SRM.SDR SWAA2013091920314Angle · crackedANGLE CRACKED AT BS 1016 STRINGER 17L. R & R ANGLE IAW SRM.SDR SWAA2013100220674Bulkhead · crackedBULKHEAD WEB CRACKED AT BS 1016 STRINGER 18L. REPAIRED WEB IAW EA.SDR SWAA2013091920313Stringer · crackedL1 DOOR CUTOUT STRINGER CRACKED AT BS 294.5 STRINGER 4L. REPAIRED STRINGER IAW SRM.SDR SWAA2013102821588Skin · crackedSKIN CRACKED AT BS 787 + 15, STRINGER 21L. REPAIRED SKIN IAW EO & EA.SDR SWAA2013100320753Frame · crackedFRAME CRACKED AT BS 520 STRINGER 21R. REPAIRED FRAME IAW EA.SDR SWAA2013100320752Skin · crackedSKIN CRACKED AT BS 400 + 12.5 STRINGER 1L. REPAIRED SKIN IAW EA.SDR SWAA2013102821587Skin · crackedSKIN CRACKED AT BS 787 + 12, STRINGER 19L. REPAIRED SKIN IAW EO & EA.SDR SWAA2013102821586Skin · crackedSKIN CRACKED AT BS 787 + 12.5, STRINGER 8L. REPAIRED SKIN IAW EO & EA.SDR SWAA2013091320116Skin · crackedSKIN CRACKED AT BS 747 + 1.75, STRINGER 18L. REPAIRED SKIN IAW SRM.SDR SWAA2013091320115Skin · crackedSKIN CRACKED AT BS 767 + 12.5, STRINGER 18L. REPAIRED SKIN IAW SRM.SDR SWAA2013091020038Strap · crackedSTRAP CRACKED BETWEEN BS 927 & BS 947.5, BETWEEN STRINGER 16L & STRINGER 17L. R&R STRAP IAW SRM & DRAWING.SDR SWAA2013091020037Tie Clip · crackedTIE CLIP CRACKED AT BS 277, STRINGER 10R. R&R TIE CLIP IAW SRM & DRAWING.SDR SWAA2013091020036Frame · crackedSTUB FRAME CRACKED AT BS 947.5+9, STRINGER 8R. R&R FRAME IAW SRM.SDR SWAA2013090919969Floorbeam · corrodedFLOOR BEAM CORRODED AT BS 344, BL 0. REPAIRED BEAM IAW SRM.SDR SWAA2013090919968Strap · crackedSTRAP CRACKED BETWEEN BS 927 & BS 947.5, BETWEEN STRINGER 16R & STRINGER 17R. R&R STRAP IAW SRM & DRAWING.SDR SWAA2013090919967Tie Clip · crackedTIE CLIP CRACKED AT BS 967, STRINGER 4R. R&R TIE CLIP IAW SRM & DRAWING.SDR SWAA2013102821585Skin · crackedSKIN CRACKED AT BS 787 + 16, STRINGER 18L. REPAIRED SKIN IAW EO & EA.SDR SWAA2013102321418Skin · crackedSKIN CRACKED AT BS 927 + 4.7, STRINGER 23R. REPAIRED SKIN IAW EA.SDR SWAA2013100220695Skin · crackedSKIN CRACKED AT BS 420+6" BETWEEN STRINGER 17R TO STRINGER 18R. REPAIRED SKIN IAW EA.SDR SWAA2013093020568Floor Support · crackedLONGITUDINAL FLOOR BEAM WEB CRACKED AT BS 707 RBL 24.8. REPAIRED WEB IAW EA.SDR SWAA2013092620544Fitting · crackedFWD GALLEY DOOR CUT OUT FITTING CRACKED AT BS 294.5 STRINGER 8R. REPAIRED FITTING IAW EA.SDR SWAA2013092320383Door Frame · crackedFWD GALLEY DOOR CUTOUT STUB FRAME CRACKED AT BS 294.5, STRINGER 7R. REPAIRED FRAME IAW EA.SDR SWAA2013091220101Frame · crackedFRAME CRACKED AT BS 520, BETWEEN STRINGER 20L TO STRINGER 2L. REPAIRED FRAME IAW SRM.SDR SWAA2013091120073Angle · crackedLT WING NR 3 FLAP TRACK FAIRING ANGLE CRACKED BETWEEN WBL 184.40 TO WBL 202.60. R&R ANGLE IAW SRM & DRAWING.SDR SWAA2013091020035Reveal · crackedL1 DOOR CUTOUT AFT LOWER REVEAL CRACKED AT STRINGER 17L. R&R REVEAL IAW SRM & DRAWING.SDR SWAA2013091020034Angle · crackedLT WING NR 3 FAIRING FLAP TRACK ANGLE CRACKED AT WBL 202.40. R&R ANGLE IAW SRM & DRAWING.SDR SWAA2013090919966Angle · crackedFWD GALLEY DOOR CUTOUT ANGLE CRACKED AT BS 291.5, BETWEEN STRINGER 12R TO STRINGER 13R. R&R ANGLE IAW SRM & DRAWING.SDR SWAA2013090619935Shear Tie · crackedSHEAR TIE CRACKED AT BS 294.5, BETWEEN STRINGER 9L TO STRINGER 10L. R&R SHEAR TIE IAW SRM & DRAWING.SDR SWAA2013090619934Plate · crackedRT WING INBD MID FLAP PLATE CRACKED. R&R PLATE IAW SRM.
Back to N526SW, cancelled Mar 27, 2018