N512SW, cancelled Mar 26, 2018
Service difficulty reports · 301
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 = 'N512SW' AND deregistration_id = 'N512SW-2018-03-26' 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 = 'N512SW' AND deregistration_id = 'N512SW-2018-03-26' 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 SWAA2012112809963Support Angle · crackedCRACK ON SUPPORT ANGLE LOC AT LEVEL OF WBL 71.24 OF THE TREALING EDGE AREA R/T WING. REPLACED SUPPORT ANGLE LOC AT LEVEL OF WBL 71.24 OF THE TRAILING EDGE AREA RT WING IAW SRM B737-500 51-10-02, 51-40-02 AND DRAWING 65-50820.SDR SWAA2012112609767Support Angle · crackedCRACK ON UPPER SUPPORT ANGLE AT LEVEL WBL 188 TRAILING EDGE AREA R/T WING INTERNAL AREA. REPLACED SUPPORT ANGLE (CLIP) AT LEVEL WBL 188 TRAILING EDGE AREA R/T WING INTERNAL AREA IAW B737-500 SRM 51-10-02, SRM 51-40-02 AND DRAWING #65C26300.SDR SWAA2012112609752Plate · crackedCRACK ON PLATE OF THE ACCESS PANEL 9224 R RIGHT HORIZONTAL STABILIZER. REPLACED PLATE OF THE ACCESS PANEL 9224R RIGHT HORIZONTAL STABILIZER IAW SRM B737-500 51-10-02 ITEM 8.SDR SWAA2012120710358Floorbeam · crackedCRACK ON OVAL HOLE LOCATED ON LBL 24.5 BS 667 CENTER WING BOX. REPAIRED FLOORBEAM UPPER CHORD AT LBL 24.82 BETWEEN STA 656 AND STA 685 WING CENTER SECTION IAW EO AEM-HC57-291/12 R0 AND EA 1-557-7751 REV-SDR SWAA2012120710314Floorbeam · crackedCRACK ON LONGITUDINAL FLOORBEAM WEB LOCATED AT BS 708 APPROX AT LBL 24.8 CENTER WING BOX. REPAIRED FLOORBEAM WEB AT LBL 24.82 BETWEEN STA 698 AND STA 717 IAW EAN 1-557-7739 AND EO AEM-HC57-290/12 R0SDR SWAA2012120310148Pan · crackedCRACK ON EXTERNAL FUSELAGE AT BS 268.25, STR 22R. REPLACED PAN RING IAW SRM AND DWG.SDR SWAA2012111409334Rivet · crackedLEFT WING IFOT FAIRING INBOARD FLAP TRACK CUTOUT LOWER BRACKET HAS TWO CRACKED RIVETS (MARKED). REMOVED AND REPLACED FASTENERS PER SRM 51-40-02.SDR SWAA2012110809158Slide · out of positionR1 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER M/M.SDR SWAA2012052304282Skin · crackedR2 DOOR FWD SKIN CRACKED AT UPPER HINGE CUTOUT LWR CORNER. REPAIRED SKIN PER SRM.SDR SWAA2012120310147Panel · crackedCRACK ON BOTH SIDES OF FASTENER HOLE ON PYLON/WING PANEL AFT OF 58710R. REPLACED PANEL 5871 OR ON PYLON/WING RIGHT IAW SRM B737-500 51-40-05 AND DWG 65C27356.SDR SWAA2012050403688Light · inoperativeR2 DOOR LOWER EMERGENCY EXIT SIGN BULBS INOP. REMOVED AND REPLACED SIGN PER M/M.SDR SWAA2012042403347Window · arcedDIVERSION -- L2 COCKPIT WINDOW ARCED. REMOVED AND REPLACED L2 COCKPIT WINDOW ASSY PER MM.SDR SWAA116956Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 947.5+12, STR 21L. REPAIRED SKIN IAW SRM.SDR SWAA116958Stringer Clip · crackedDURING SCHEDULED OTS CHECK, FOUND STRINGER CLIP CRACKED AT BS 986, STR 22L. REMOVED AND REPLACED CLIP IAW SRM.SDR SWAA116957Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 482B+15, STR 15R. REPAIRED SKIN IAW SRM.SDR SWAA116868Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 437.5, STR 17R. REPAIRED SKIN IAW SRM.SDR SWAA116237Frame · crackedDURING SCHEDULED SPV CHECK, FOUND RT FRAME INNER CHORD CRACKED AT BS 616, STR 17R. REPAIRED CHORD IAW EA.SDR SWAA116008Light · inoperativeDURING SCHEDULED SPV CHECK, FOUND LT OVERWING EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BULB IAW MM.SDR SWAA116007Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED BETWEEN BS 929 TO BS 932, STR 21L. REPAIRED SKIN PER SRM.SDR SWAA116012Support · damagedDURING SCHEDULED HEAVY CHECK, FOUND AILERON LATER CONTROL POWER CONTROL SUPPORT BEARING BORE DAMAGED. REPAIRED PER EA.SDR SWAA115703Battery Pack · inoperativeDURING SCHEDULED MV1 CHECK, FOUND LT AFT GALLEY EMERGENCY EXIT LIGHT BATTERY PACK INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA115179Actuator · crackedDURING SCHEDULED MV1 CHECK, FOUND LT WING I/B GROUND SPOILER I/B ACTUATOR CRACKED. REMOVED AND REPLACED GROUND SPOILER ACTUATOR PER MM.SDR SWAA113762Fan · faultyDIVERSION/DECLARED EMERGENCY. FLIGHT ATTENDANTS REPORTED STRONG ELECTRICAL ODOR IN AFT GALLEY AND MID CABIN. STRONG ODOR ALSO NOTICED IN COCK.SDR SWAA113710Skin · crackedDURING SCHEDULED MV1 CHECK FOUND, SKIN CRACKED AT BS 807, STR 21L. REPAIRED SKIN PER SRM.SDR SWAA111866Tie Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND CRACK ON AFT CARGO COMPARTMENT TIE CLIP STA 727A, STR 21L. REPLACED TIE CLIP PER SRM.SDR SWAA111063Fitting · corrodedDURING SCHEDULED 20Y CHECK, FOUND LT MLG TRUNNION FITTING LUG FACES CORRODED. REMOVED AND REPLACED FITTING PER EA.SDR SWAA111288Battery Pack · dischargedDURING SCHEDULED MV1 CHECK, FOUND L2 DOOR EXTERIOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA111001Fitting · corrodedDURING SCHEDULED 20Y CHECK, FOUND RT VERTICAL FIN TERMINAL FITTING CORRODED AT BS 1016. REPAIRED FITTING PER EA.SDR SWAA111000Attach Fitting · corrodedDURING SCHEDULED 20Y CHECK, FOUND LT FAIL SAFE CHORD ATTACH FITTING CORRODED AT BS 1088. REPAIRED FITTING PER EA.SDR SWAA110999Attach Fitting · corrodedDURING SCHEDULED 20Y CHECK, FOUND RT FAIL-SAFE CHORD ATTACH FITTING CORRODED AT BS 1088. REPAIRED FITTING PER EA.SDR SWAA110930Strap · crackedDURING SCHEDULED 20Y CHECK, FOUND SKIN STRAP CRACKED BETWEEN BS 370 TO BS 395, BETWEEN STR 27R TO STR 27L. REMOVED AND REPLACED STRAP PER SRM AND BAC DWG.SDR SWAA110929Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 669, RBL 24.5. REPAIRED BEAM PER EA.SDR SWAA110888Lens · brokenDURING SCHEDULED 20Y CHECK, FOUND LT AFT EMERGENCY EXIT LIGHT LENS BROKEN. REMOVED AND REPLACED LENS PER MM.SDR SWAA110887Channel · corrodedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 790, RBL 3. REPAIRED CHANNEL PER EA.SDR SWAA110886Spar · crackedDURING SCHEDULED 20Y CHECK, FOUND LT WING CRACKED ON UPPER CHORD REAR SPAR RSS 223.14. REPAIRED SPAR PER EA.SDR SWAA110885Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND SKIN CRACKED AT BS 367 STR 28R+8. REPAIRED SKIN EA.SDR SWAA110884Flap · delaminatedDURING SCHEDULED 20Y CHECK, FOUND RT WING I/B FORE FLAP DELAMINATED. REPAIRED FORE FLAP PER SRM.SDR SWAA110576Slat · delaminatedDURING SCHEDULED 20Y CHECK, FOUND LT WING NR 2 SLAT O/B EDGE DELAMINATED. REPAIRED SLAT PER SRM.SDR SWAA110575Stiffener · crackedDURING SCHEDULED 20Y CHECK, FOUND STIFFENER CRACKED AT BS 727, STR 27L. REMOVED AND REPLACED STIFFENER PER SRM AND BAC DWG.SDR SWAA110507Frame · corrodedDURING SCHEDULED 20Y CHECK, FOUND FRAME CORRODED AT BS 460, STR 26R. REPAIRED FRAME PER EA.SDR SWAA110451Flap · delaminatedDURING SCHEDULED 20Y CHECK, FOUND LT WING I/B FORE FLAP DELAMINATED. REPAIRED FORE FLAP PER SRM.SDR SWAA110393Stringer Splice · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER SPLICE CRACKED AT BS 363, STR 16L. REMOVED AND REPLACED SPLICE PER SRM.SDR SWAA110392Shear Tie · corrodedDURING SCHEDULED 20Y CHECK, FOUND SHEAR TIE CORRODED AT BS 482, BETWEEN STR 28R TO STR 28L. REPAIRED SHEAR TIE PER SRM.SDR SWAA110391Shear Tie · corrodedDURING SCHEDULED 20Y CHECK, FOUND SHEAR TIE CORRODED AT BS 482, BETWEEN STR 24R TO STR 28R. REPAIRED SHEAR TIE PER SRM.SDR SWAA110390Shear Tie · corrodedDURING SCHEDULED 20Y CHECK, FOUND SHEAR TIE CORRODED AT BS 482, BETWEEN STR 26R TO STR 27R. REPAIRED SHEAR TIE PER SRM.SDR SWAA110389Shear Tie · corrodedDURING SCHEDULED 20Y CHECK, FOUND SHEAR TIE CORRODED AT BS 360, BETWEEN STR 28L TO STR 28R. REPAIRED SHEAR TIE PER SRM.SDR SWAA110388Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND SKIN CRACKED AT BS 282, BETWEEN STR 24R TO STR 25R. REPAIRED SKIN PER SRM.SDR SWAA110387Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND SKIN CRACKED AT BS 787+18, STR 23L. REPAIRED SKIN PER SRM.SDR SWAA110386Support Channel · crackedDURING SCHEDULED 20Y CHECK, FOUND FWD CARGO COMPARTMENT SUPPORT CHANNEL CRACKED AT BS 460, STR 26R. REMOVED AND REPLACED CHANNEL PER SRM AND BAC DWG.SDR SWAA110385Frame · corrodedDURING SCHEDULED 20Y CHECK, FOUND FRAME CORRODED AT BS 482A, BETWEEN STR 28L TO STR 28R. REPAIRED FRAME PER SRM.
Back to N512SW, cancelled Mar 26, 2018