N368SW, cancelled Mar 22, 2018
Service difficulty reports · 360
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 = 'N368SW' AND deregistration_id = 'N368SW-2018-03-22' 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 = 'N368SW' AND deregistration_id = 'N368SW-2018-03-22' 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 SWAA2012112901003Flap · delaminatedDELAMINATION LOC UPPER SURFACE OF INBOARD FOREFLAP RIGHT WING. REPAIRED I/B FORE FLAP RIGHT WING IAW B737-300 SRM 51-70-10-2R-0 AND 51-70-10-2R-3.SDR SWAA2012112609808Channel · crackedCRACK ON CHANNEL AT BS 492 TO 500A STR 26R CARGO COMPARTMENT. REMOVED AND REPLACED CHANNEL IAW SRM.SDR SWAA2012112709901Stringer Splice · crackedCRACK ON STRINGER SPLICE CHANNEL LOC BSTA 360 S-15L. REPLACED STRINGER SPLICE CHANNEL LOC BS 360 STR 15L IAW SRM B737-300 51-10-02 ITEM 8, 51-40-02 DWG 65-17685.SDR SWAA2012112609811Fitting · crackedCRACK ON CLIP LOCATED AT BS 294.5 AND STR 23L, NOSE LANDING GEAR WHEEL WELL STRUCTURE. REPLACED CLIP LOCATED AT BS 294.5 AND STR 23L, NOSE LANDING GEAR WHEEL WELL STRUCTURE IAW B737-300 SRM 51-10-02 ITEM 8, DRAWING 65-45806 AND 65-45808.SDR SWAA2012120710351Fairing · brokenBROKEN FAIRING ASSY LOWER BIFURCATION AFT LOWER POSITION INBOARD T/R ENGINE NR 2. REPAIRED FAIRING ASSY LOWER BIFURCATION AFT LOWER POSITION I/B T/R ENGINE NR 2 IAW EA N. 1-354-1515 R0 AND EO N. AEM-HC54-060/12 REV 0. FOR DETAIL SEE TLD N. T030220SDR SWAA2012120410203Angle · crackedCRACK ON ANGLE LOCATED ON BS 380 AT LEVEL OF STR 21L ON E/E COMPARTMENT. REPLACED ANGLE AND FASTENERS LOC ON BS 380 AT LEVEL OF STR 21L ON E/E COMPARTMENT IAW B737-300 SRM 51-10-02 ITEM 8 AND SRM 51-40-02 AND DRAWING #65-61380.SDR SWAA2012113010053Frame · corrodedCORROSION ON FRAME AT BS 344 LEVEL OF STR 27R E/E COMPARTMENT. REPAIRED FRAME IAW SRM.SDR SWAA2012112901006Angle · crackedCRACK ON ANGLE LOCATED AT LEVEL STR 22L BS 540 WING TO BODY FAIRING. REPAIRED ANGLE LOCATED AT LEVEL STR 22L BS 540 WING TO BODY FAIRING IAW SRM B737-300 51-70-11.SDR SWAA2012112809954Strap · crackedCRACK ON STRAP LOCATED AT LEVEL OF BS 312 AND LBL 13.0 E/E COMPARTMENT. REPLACED STRAP LOCATED AT LEVEL OF BS 312 AND LBL 13.0 E/E COMPARTMENT IAW B737-300 SRM 51-10-02 ITEM 8 AND DRAWING 65-45834.SDR SWAA2012112709902Shear Tie · corrodedCORROSION ON SHEAR TIE LOCATED AT BS 360 AND BETWEEN STR 19L AND STR 20L E/E COMPARTMENT. REPLACED SHEAR TIE LOCATED AT BS 360 AND BETWEEN STR 19L AND STR 20L E/E COMPARTMENT IAW SRM B737-300 51-10-02 ITEM 8, SRM B737-300 51-40-02 AND DWG 65-5828.SDR SWAA2012112609810Angle · crackedCRACK ON ANGLE LOCATED AT BS 351.2 BETWEEN STR 25R AND STR 27R E/E COMPARTMENT. REPLACED ANGLE AND FASTENERS LOCATED AT BS 315.2 BETWEEN STR 25R AND STR 27R E/E COMPARTMENT IAW B737-300 SRM 51-10-02 ITEM 8 AND SRM 51-40-02 AND DRAWING 65-63811.SDR SWAA2012112609809Strap · crackedCRACK ON STRAP LOCATED AT BS 312 AND RBL 31.6 E/E COMPARTMENT. REPLACED STRAP LOC BS 312 TO BS 344 RBL 31.6 IAW B737-300 SRM 51-10-02, 51-40-02 AND DRAWING 65-45834.SDR SWAA2012112609806Angle · crackedCRACK ON ANGLE BETWEEN BS 927 TO 947.5 AND BL 0 BETWEEN FLOORBEAM CARGO COMPARTMENT. REMOVED AND REPLACED ANGLE IAW SRM AND DWG.SDR SWAA2012112609799Strap · crackedCRACK ON STRAP LOCATED AT BS 328 AND LBL 0 E/E COMPARTMENT. REPLACED STRAP LOC BETWEEN BS 312 AND BS 344 BL 0 E/E COMPARTMENT IAW B737-300 SRM 51-10-02, 51-40-02 AND DRAWING 65-45834.SDR SWAA2012112109724Plate · crackedCRACK ON PLATE LOCATED ACCESS PANEL 9505 VERTICAL STABILIZER. REPLACED PLATE LOCATED ACCESS PANEL 9505 VERTICAL STABILIZER IAW SRM 51-10-02 ITEM 8, SRM B737-300 51-40-02 AND DWG.SDR SWAA2012112009634Angle · crackedCRACK ON ANGLE LOCATED AT BS 328 AND RBL 44 E/E COMPARTMENT. REPLACED ANGLE PER SRM.SDR SWAA2012112009633Spindle · crackedCRACK ON SPINDLE OF MIDFLAP CARRIAGE N.1 OF OUTBOARD FLAP LEFT WING. REPLACED SPINDLE OF MIDFLAP CARRIAGE N.1 OF OUTBOARD FLAP LEFT WING IAW AMM 27-51-44 AND MT# 327-51-07.SDR SWAA2012120410202Floor Panel · crackedCRACK ON FLOOR PANEL LEFT SIDE OF HATCH FRAME AT ELECTRONICS COMPARTMENT DOOR. REPAIRED FLOOR PANEL LEFT SIDE AT HATCH FRAME AT ELECTRONICS COMPARTMENT DOOR IAW B737-300 SRM 51-70-06-0G-0 PAR 4KSDR SWAA2012120310095Tie Clip · crackedCRACK ON TIE CLIP LOCATED AT BSTA 947.5 STR 25R AFT CARGO COMPARTMENT. REPLACED TIE CLIP AND FASTENERS LOCATED BS 947.5 AND STR 25R IN AFT CARGO COMPARTMENT IAW EO AEM-HC53-524/12 R0 AND EA 1-353-21129 R0.SDR SWAA2012112901005Frame · crackedCRACK ON FRAME LOCATED AT BSTA 947.5 LEVEL STR 19L AFT CARGO COMPARTMENT. REPLACED REPAIR FRAME AND FASTENERS LOCATED AT BS 947.5 BETWEEN STR 17L AND 23L IAW B737-300 SRM 51-10-02 ITEM 8, SRM 51-40-02 AND DWG 65-46947.SDR SWAA2012112609805Angle · crackedCRACK ON ANGLE LOCATED AT LEVEL OF RSS 533 TRAILING EDGE AREA OF LT WING. REPLACED ANGLE LOCATED AT LEVEL OF RSS 533 TRAILING EDGE AREA OF LT WING IAW B737-300 SRM 51-10-02 ITEM 8 AND 51-40-02, DWG #65-46460.SDR SWAA2012112609804Support Angle · crackedCRACK SUPPORT ANGLE LOCATED ENTRY DOOR CUTOUT UPPER CORNER BETWEEN BS 310 TO 328 AND STR 5L TO 7L. REPLACED ANGLE IAW BOEING SRM AND DRAWING.SDR SWAA2012112609803Support Angle · crackedCRACK ON SUPPORT ANGLE LOCATED BETWEEN BS 294.5 TO BS 303.9 AND STR 10L IN FWD CABIN. REPLACED SUPPORT ANGLE LOCATED BETWEEN BS 294.5 TO BS 303.9 AND STR 10L IN FWD CABIN IN ACCORDANCE WITH BOEING 737-300 SRM 51-10-02 ITEM 8 AND DRAWING #69-785.SDR SWAA2012112609802Support Angle · crackedCRACK ON SUPPORT ANGLE LOCATED LOWER SURFACE OF CSD OIL ACCESS PANEL INTERNAL OF I/B FAN COWL ENG NR 2. REPLACED SUPPORT ANGLE IAW SRM.SDR SWAA2012111909592Tie Clip · crackedCRACK ON TIE CLIP LOCATED AT BSTA 727B STR 21L AFT CARGO COMPARTMENT. REPLACED TIE CLIP LOC AT BS 727B STR 21L AFT CARGO COMPARTMENT IAW B737-300 SRM 51-40-02 DWG 65-46596.SDR SWAA2012111909591Tie Clip · crackedCRACK ON TIE CLIP LOCATED AT BSTA 727B STR 20L AFT CARGO COMPARTMENT. REPLACED TIE CLIP LOC AT B/S 727B STR 20L AFT CARGO COMPARTMENT IAW B737-300 SRM 51-40-02 DWG #65-46596.SDR SWAA2012111909590Tie Clip · crackedCRACK ON TIE CLIP LOCATED AT BSTA 727E STR 23L AFT CARGO COMPARTMENT. REPLACED TIE CLIP AND FASTENERS LOCATED AT BS 727E STR 23L AFT CARGO COMPARTMENT IAW B737-300 SRM 51-10-02 ITEM 8 AND SRM 51-40-02 AND DRAWING 65-46596.SDR SWAA2012111909589Tie Clip · crackedCRACK ON TIE CLIP LOCATED AT BSTA 727E STR 21L AFT CARGO COMPARTMENT. REPLACED TIE CLIP AND FASTENERS LOCATED AT BS 727E STR 21L AFT CARGO COMPARTMENT IAW B737-300 SRM 51-10-02 ITEM 8 AND SRM 51-40-02 AND DRAWING 65-46596.SDR SWAA2012111909588Channel · crackedCRACK ON CHANNEL LOCATED BS 540 AND BETWEEN BL 0 TO LBL 24.5 CEILING AREA FWD C.C. REPLACED CHANNEL IAW SRM DRAWING.SDR SWAA2012111509496Angle · crackedCRACK ON ANGLE LOCATED AT LEVEL OF RSS 545 INTERNAL T/E AREA OF RIGHT WING. REPLACED ANGLE LOCATED AT LEVEL OF RSS 545 INTERNAL T/E AREA OF RIGHT WING IAW B737-300 SRM 51-40-02, 51-10-02 AND DRAWING 65-46460.SDR SWAA2012120710350Skin · crackedCRACK SKIN LOWER LOBE FUSELAGE OF ANTENNA VHF 3 BETWEEN BS 727D TO 727E AND LBL 0.5. REPAIRED FUSELAGE SKIN IAW EO & EA.SDR SWAA2012113010051Frame · corrodedCORROSION LOWER FLANGE OF FRAME AT BS 867 BETWEEN STR 27L TO STR 27R. REPAIRED FRAME IAW SRM DWG.SDR SWAA2012112901002Flap · delaminatedDELAMINATION ON LEFT OUTBOARD AFT FLAP. REPAIRED LEFT OUTBOARD AFT FLAP IAW B737-300 SRM 51-70-10-2R-0.SDR SWAA2012112009632Tie Clip · crackedCRACK ON TIE CLIP LOCATED AT BSTA 947.5 AND STR 27L AFT CARGO COMPARTMENT. REPLACED TIE CLIP LOC AT BS 947.5 AND STR 27L AFT CARGO COMPARTMENT IAW B737-300 SRM 51-10-02 ITEM 8 AND DRAWING.SDR SWAA2012111909587Web · crackedCRACK ON WEB LOCATED BETWEEN BS 500D TO BS 520 AT LEVEL OF STR 28L. REPLACED WEB LOCATED BS 500D TO BS 520 AT LEVEL OF STR 28L FWD C.C IAW B737-300 SRM 51-10-02 ITEM 8 B737-300 51-40-02 AND DRAWING 65C27393.SDR SWAA2012111509495Tie Clip · crackedCRACK ON TIE CLIP LOCATED ON BS 500C AND STR 27L FWD CC. REPLACED TIE CLIP LOCATED ON BS 500C AND STR 27L FWD CC. IAW B737-300 SRM 51-10-02 ITEM 8, SRM 51-40-02 AND DRAWING 65C22909.SDR SWAA2012120610271Skin · crackedCRACK ON EXTERNAL SKIN LOCATED L/E OF ACCESS PANEL 9249R RT STABILIZER. REPAIRED EXTERNAL SKIN LOCATED L/E STA 230/269 RT HORIZONTAL STABILIZER ACCESS PANEL 9249R IAW EA 1-355-1752 R0 AND EO AEM-HC55-050/12 R0SDR SWAA2012120510226Stiffener · crackedCRACK ON STIFFENER LOCATED AT BSTA 727 STR 27L AFT CARGO COMPARTMENT. REPLACED STIFFENER LOCATED AT BSTA 727 STR 27L AFT CARGO COMPARTMENT IAW SRM B737-300 51-10-02 AND DRAWING 65-46547.SDR SWAA2012120410201Skin · crackedCRACK ENTRY DOOR UPPER CORNER BS 303.9+12" AND STR 6L+1". REPAIRED SKIN IAW EO AND EA.SDR SWAA2012113010050Skin · crackedCRACK ENTRY DOOR UPPER CORNER BS 992.8+19" AND STR 7L+3". REPAIRED SKIN IAW SRM.SDR SWAA2012113010049Frame · corrodedCORROSION ON LOWER FLANGE OF FRAME AT BS STA 807 BETWEEN STR 27L TO STR 27R. REPAIRED FRAME IAW SRM DWG.SDR SWAA2012112901001Channel · crackedCRACK ON CHANNEL LOCATED AT BSTA 727+4" BETWEEN STR 25L TO STR 25R AFT CARGO COMPARTMENT. REPLACED CHANNEL LOC AT BS 727+4" BETWEEN STR 25L TO STR 25R AFT CARGO COMPARTMENT IAW B737-300 SRM 51-40-02, SRM 51-10-02 ITEM 8 AND DRAWING 65-49614.SDR SWAA2012112901000Bracket · crackedCRACK BRACKET BS STA 727 BETWEEN STR 27L TO STR 27R FACE OF BULKHEAD. REPLACED BRACKET IAW SRM AND DRAWING.SDR SWAA2012112809953Web · crackedCRACK ON WEB LOCATED ON BS 492.4 AND AT LEVEL OF STR 26R OF THE FWD CARGO COMPARTMENT. REPLACED WEB LOCATED ON BS 492.4 BETWEEN STR 19R TO STR 26R FWD CARGO COMP IAW B737-300 SRM 51-40-02 AND DWG 6520723.SDR SWAA2012112709900Stiffener · crackedCRACK ON STIFFENER LOCATED AT BSTA 727 STR 27R AFT CARGO COMPARTMENT. REPLACED STIFFENER LOC AT BSTA 727 STR 27R AFT CARGO COMPARTMENT IAW B737-300 SRM 51-10-02 ITEM 8 AND DRAWING 65-46547.SDR SWAA2012111509494Tie Clip · crackedCRACK ON TIE CLIP LOCATED AT BSTA 727A STR 26L AFT CARGO COMPARTMENT. REPLACED TIE CLIP LOCATED AT BS 727A STR 26L AFT CARGO COMPARTMENT IAW B737-300 SRM 51-10-02 ITEM 8 SRM B737-300 51-40-02 AND DRAWING #65-46595.SDR SWAA2012121010377Floorbeam · crackedCRACK ON THE RBL 45.5 LONGITUDINAL FLOORBEAM UPPER CHORD, AFT END AROUND FASTENER AT BS 727B. REPAIRED LONGITUDINAL FLOORBEAM UPPER CHORD RBL 45.57 AT BSTA 727B IAW EA 1-357-7724 REV.0 EO AEM-HC57-289/12 R0SDR SWAA2012120710349Floor Support · crackedCRACK ON LBL 45.5 LONGITUDINAL FLOORBEAM UPPER CHORD AFT AND AROUND FASTENER HOLE COMMON TO THE ATTACH STRAP AT BS 727B. REPAIRED CHORD IAW EA.SDR SWAA2012120710346Floor Support · crackedCRACK ON RBL 24.8 LONGITUDINAL FLOORBEAM UPPER CHORD AFT END AROUND FASTENER HOLE COMMON TO THE ATTACH STRAP AT BS 727B. REPAIRED CHORD IAW EA.SDR SWAA2012120710345Floorbeam · crackedCRACK ON THE LBL 24.8 LONGITUDINAL FLOORBEAM STRUCTURE, UPPER CHORD, AFT END AROUND FASTENERS HOLES COMMON TO THE ATTACH STRAP AT BS 727B. REPAIRED IAW EO.
Back to N368SW, cancelled Mar 22, 2018