N369SW, cancelled Mar 22, 2018
Service difficulty reports · 323
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 = 'N369SW' AND deregistration_id = 'N369SW-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 = 'N369SW' AND deregistration_id = 'N369SW-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 SWAA2013080118728Skin · crackedSKIN CRACKED BETWEEN STATION 433 TO STATION 436, STRINGER 2R. REPAIRED SKIN IAW SWA EA.SDR SWAA2013070817972Slide · out of positionL1 DOOR EMERGENCY EVAC SLIDE INADVERTENTLY FELL OUT, DID NOT DEPLOY, STILL OPERATIONAL. REINSTALLED SLIDE IAW MT.SDR SWAA2013062017439Lens · crackedL1 DOOR THRESHOLD EMERGENCY EXIT LIGHT LENS CRACKED. R & R LENS IAW M/M.SDR SWAA2013031313585Door Frame · crackedFORWARD FRAME CRACKED AT L1 DOOR. REMOVED AND REPLACED L1 DOOR ASSY PER MM.SDR SWAA2013031113534Door Frame · crackedL1 DOOR FWD LOWER FRAME CRACKED. REMOVED AND REPLACED L1 DOOR PER MM.SDR SWAA2013012811998Door · out of adjustF/A'S REPORT FWD GALLEY SERVICE DOOR DIFFICULT TO OPEN. ADJUSTED AND LUBRICATED DOOR AS PER MM.SDR SWAA2012121710691Support Angle · crackedSUPPORT ANGLE CRACKED AT STA 27.00 INTERNAL STRUCTURE O/B SIDE FAIRING NR 3 LEFT WING. REPLACED ANGLE IAW SRM AND DWG.SDR SWAA2012121310576Rub Strip · crackedCRACK ON RUB STRIP LOCATED ON DOOR WING LEADING EDGE KRUEGER FLAP L/E 118.56 LT WING. REPLACED RUB STRIP LOCATED ON DOOR WING LEADING EDGE KRUEGER FLAP LEADING EDGE 118.56 LT WING IAW B737-300 SRM 51-10-02 ITEM 8 AND B737-300 SRM 51-40-02.SDR SWAA2012121010419Seal · crackedCRACK ON RETAINER SEAL OF ACCESS PANEL 9207R RT HORIZONTAL STABILIZER TRAILING EDGE. REPLACED RETAINER SEAL OF ACCESS PANEL 9207R RT HORIZONTAL STABILIZER TRAILING EDGE IAW SRM B737-300 51-10-02 ITEM 8 AND DWG 65-53746.SDR SWAA2012121210520Access Panel · crackedCRACKS (4) AROUND FASTENER HOLE ACCESS PANEL 9207R HORIZONTAL STABILIZER RIGHT. REPAIRED FASTENER HOLE OF ACCESS PANEL 9207R IAW B737-300 SRM 51-70-17-0G-0.SDR SWAA2012121310575Rib · crackedRIGHT WING RIB CRACKED AT TRAILING EDGE EXHAUST GATE I/B END OF O/B FLAP WBL 184.40. REPLACED RIB IAW SRM AND DWG.SDR SWAA2012121110486Web · crackedCRACK ON WEB LOCATED AT BS 227.8 TO BS 231 BL 0 OF NOSE WHEEL WELL. REPLACED WEB LOCATED BETWEEN BS 227.8 TO BS 259.5 BL 0 OF NOSE WHEEL WELL AS PER SRM B737-300 51-10-02 ITEM 8 SRM B737-300 51-40-02. DWG 65-45819 AND ACO 7820-53.SDR SWAA2012120610273Skin · crackedGALLEY DOOR AT UPPER CORNER CRACKED AT BS 328, STR 7R. REPAIRED SKIN EA AND SRM.SDR SWAA2012120310107Reveal · crackedCRACK ON UPPER AFT REVEAL LOCATED BS 328 AND BETWEEN STR 8R TO STR 7R FWD GALLEY DOOR CUTOUT. REPLACED UPPER AFT REVEAL LOC BS 328 AND BETWEEN STR 7R TO STR 8R FWD GALLEY DOOR CUTOUT IAW SRM B737-300 51-10-02 PART 8 AND 51-40-02.SDR SWAA2012120310106Angle · crackedANGLE CRACKED BETWEEN BS 312 TO 328, BETWEEN STR 26L TO 27L ELECTRONIC COMPARTMENT. REMOVED AND REPLACED ANGLE IAW SRM AND DWG.SDR SWAA2012120310105Support Angle · crackedRIGHT WING SUPPORT ANGLE CRACKED AT WBL 71.24+10" TRAILING EDGE. REPLACED ANGLE IAW SRM AND DWG.SDR SWAA2012120310104Angle · crackedCRACK ON ANGLE LOCATED BETWEEN BS 927 AND BS 947.5 BL 0 AFT CARGO COMPARTMENT CEILING PANEL AREA. REPLACED ANGLE LOCATED BETWEEN BS 927 AND BS 947.5 BL 0 AFT CARGO COMP CEILING AREA IAW SRM 737-300 51-40-02 AND DRAWING 69-36656.SDR SWAA2012112901012Tie Clip · crackedCRACK ON TIE CLIP LOCATED AT BS 1006 AT S-22R AFT CARGO COMPARTMENT. REPLACED TIE CLIP LOCATED AT BS 1006 AT S-22R AFT CARGO COMPARTMENT IAW B737-300 SRM 51-10-02 ITEM 8 AND SRM 51-40-02 AND DRAWING 65-46567.SDR SWAA2012112901011Tie Clip · crackedCRACK ON TIE CLIP LOCTAED AT BS 787 AND S-20R AFT CARGO COMPARTMENT. REPLACED TIE CLIP LOCATED AT BS 787 AND STR 20R AFT CARGO COMPARTMENT IAW B737-300 SRM 51-10-02 ITEM 8 AND INSTALLED FASTENERS IAW B737-300 SRM 51-40-02 AND DRAWING #65-46550.SDR SWAA2012112901010Tie Clip · crackedCRACK ON TIE CLIP LOCATED AT BS 787 AND S-21R AFT CARGO COMPARTMENT. REPLACED TIE CLIP LOCATED AT BS 787 AND STR 21R AFT CARGO COMPARTMENT IAW B737-300 SRM 51-10-02 ITEM 8 AND INSTALLED FASTENERS IAW B737-300 SRM 51-40-02 AND DRAWING # 65-4655SDR SWAA2012112901009Tie Clip · crackedCRACK ON TIE LOCATED AT BS 927 AND S-22L AFT CARGO COMPARTMENT. REMOVED AND REPLACED TIE CLIP AND FASTENER LOCATED AT BS 927 AND S-22L AFT CARGO COMPARTMENT IAW B737-300 SRM 51-40-02, 51-10-02 ITEM 8 AND DRAWING 65-46559 SHEET 3.SDR SWAA2012112809961Tie Clip · crackedCRACK ON TIE CLIP LOCATED AT BS 727E AND S-21L AFT CARGO COMPARTMENT. REPLACED TIE CLIP LOCATED AT BS 727E AND STR 21L AFT CARGO COMPARTMENT IAW SRM B737-300 51-10-02 PART 8, 51-40-02 AND DRAWING 65C25228.SDR SWAA2012112809960Tie Clip · crackedCRACK ON TIE CLIP LOCATED AT BS 727E AND S-20L AFT CARGO COMPARTMENT. REPLACED TIE CLIP LOCATED AT BS 727E AND STR 20L AFT CARGO COMPARTMENT IAW SRM B737-300 51-10-02 PART 8, 51-40-02 AND DRAWING 65C25228.SDR SWAA2012112809959Tie Clip · crackedCRACK ON TIE CLIP LOCATED AT BS 787 AT LEVEL S-22R AFT CARGO COMPARTMENT. REPLACED TIE CLIP LOCATED AT BS787 AT LEVEL STR 22R AFT CARGO COMPARTMENT IAW SRM B737-300 51-10-02 PART 8, 51-40-02 AND DWG 65-46550.SDR SWAA2012120310103Shear Tie · crackedBRACKET WEB CRACKED AT BS 294.5, STR 23L FUSELAGE LOWER LOBE. REPLACED SHEAR TIE IAW SRM AND DWG.SDR SWAA2012120310102Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 380, STR 20L OF THE E/E COMPARTMENT. REPLACED ANGLE IAW SRM DRAWING.SDR SWAA2012120310101Strap · crackedCRACK ON STRAP LOCATED AT BS 312 AND AT LEVEL OF BL 0 UNDER FWD GALLEY AND LAVATORY E/E COMPARTMENT. REPLACED STRAP LOCATED AT BS 312 AND AT LEVEL OF BL 0 UNDER FWD GALLEY AND LAVATORY E/E COMPARTMENT IAW SRM B737-300 51-40-02 AND DWG 65-45834.SDR SWAA2012113010056Strap · crackedSTRAP CRACKED AT BS 312, RBL 31 UNDER GALLEY AND LAVATORY E/E COMPARTMENT. REPLACED STRAP IAW SRM.SDR SWAA2012112809958Tie Clip · crackedTIE CLIP CRACKED AT BS 380, STR 22L OF THE E/E COMPARTMENT. REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2012112809957Strap · crackedSTRAP CRACKED AT BS 328, RBL 46 UNDER GALLEY AND LAVATORY E/E COMPARTMENT. REPLACED STRAP IAW SRM.SDR SWAA2012121710690Skin · crackedCRACK ON EXTERNAL SKIN LOWER HINGE AT BS 947.5, BETWEEN STR 14L TO STR 15L. REPAIRED SKIN IAW EA.SDR SWAA2012112809956Angle · crackedCRACK ON VERTICAL ANGLE LOCATED AT WS 537.806 OF THE RIGHT WING FIXED TRAILING EDGE. REPLACED VERTICAL ANGLE LOC WS 537.806 OF THE RIGHT WING FIXED TRAILING EDGE IAW B737-300 SRM 51-10-02, 51-40-02 AND DWG N. 65-46460.SDR SWAA2012121410666Tie Clip · crackedCRACK ON TIE CLIP LOCATED AT BSTA 947.5 STR 25R AFT CARGO COMPARTMENT. REPLACED STRINGER TIE CLIP LOC AT BSTA 947.5 STR 25R AFT CARGO COMPARTMENT IAW EA 1-353-2122/R0. AND EO AEM-HC5-547/12.R0.SDR SWAA2012121210530Panel · crackedCRACK ON ALL FASTENER HOLE OF BALANCE PANEL 9537 OF VERTICAL STABILIZER. REPAIRED BALANCE PANEL 9537 IAW B737-300 SRM 51-70-07-0G-0.SDR SWAA2012121210519Panel · crackedCRACK ON ALL FASTENER HOLE OF BALANCE PANEL 9538 OF VERTICAL STABILIZER. REPAIRED RUDDER BALANCE PANEL 9538 IAW B737-300 SRM 51-70-07-0G-0.SDR SWAA2012121210518Panel · crackedCRACK ON ALL FASTENER HOLE OF BALANCE PANEL 9536 OF VERTICAL STABILIZER. REPAIRED RUDDER BALANCE PANEL 9536 IAW B737-300 SRM 51-70-07-0G-0.SDR SWAA2012121210517Panel · crackedCRACK ON ALL FASTENER HOLE OF BALANCE PANEL 9535 OF VERTICAL STABILIZER. REPAIRED RUDDER BALANCE PANEL 9535 IAW B737-300 SRM 51-70-07-0G-0.SDR SWAA2012121010418Tie Clip · crackedCRACK ON TIE CLIP LOCTED AT BS 986.5 STR 20L AFT CARGO COMPARTMENT. REPLACED TIE CLIP LOCATED AT BS 986.5 STR 20L AFT CARGO COMPARTMENT IAW B737-300 SRM 51-10-02 ITEM 8 AND DRAWING 65-46564.SDR SWAA2012121010417Tie Clip · crackedCRACK ON TIE CLIP LOCATED AT BS 967 STR 19L AFT CARGO COMPARTMENT. REPLACED TIE CLIP LOCATED AT BS 967 STR 19L AFTER CARGO COMPARTMENT IAW SRM B737-300 51-10-02 PAGE 8 ITEM 8 AND INSTALLED IAW SRM B737-300 51-40-02 AND DWG 65-46563.SDR SWAA2012121010381Skin · crackedFUSELAGE SKIN CRACKED AT BS 344+2, STR 2L. REPAIRED SKIN PER SRM.SDR SWAA2012121010380Stiffener · crackedCRACKED LOWER STIFFENER AT STAB STA 120.30 INTERNAL STRUCTURE MAIN BOX LEFT HORIZ STAB. REMOVED AND REPLACED STIFFENER IAW SRM.SDR SWAA2012120710308Skin · crackedFUSELAGE SKIN CRACKED AT BS 328+10, STR 2L. REPAIRED SKIN PER SRM.SDR SWAA2012120510227Tie Down · crackedCRACK ON TRACK TIE DOWN LOCATED AT BSTA 747 AND RBL 13.80 AFT CARGO COMPARTMENT. REPAIRED TRACK TIEDOWN SECTION LOC BETWEEN BS 747+10 TO BS 767+10 AND RBL 13.8 AFT CC IAW B737-300 SRM 53-00-53 REPAIR 2 AND DWG 65-46592.SDR SWAA2012120410205Skin · crackedCRACK IN THE FUSELAGE SKIN ALONG THE CHEM-MILL STEP AT BS 967+3, STR 5R. REPAIRED SKIN IAW SRM.SDR SWAA2012120410204Skin · crackedCRACK IN THE FUSELAGE SKIN ALONG THE CHEM-MILL STEP AT BS 947.5, STR 5R. REPAIRED SKIN IAW SRM.SDR SWAA2012120310108Tie Clip · crackedCRACK ON TIE CLIP LOCATED AT BS 887 STR 20L AFT CARGO COMPARTMENT. REPLACED NEW TIE CLIP LOC AT BS 887 STR 20L AFT CARGO COMP IAW SRM B737-300 51-40-02 AND DWG 65-46557.SDR SWAA2012120310099Shear Tie · corrodedSHEAR TIE CORRODED AT BS 520, BETWEEN STR 27L AND STR 28L. REMOVED AND REPLACED SHEAR TIE IAW SRM.SDR SWAA2012120310098Bolt · corrodedRUST ON BOLTS LOCATED ON BALANCE PANEL AREA OF THE LT AILERON. REPLACED BOLTS LOCATED ON BALANCE PANEL AREA OF THE LT AILERON IAW CMM 57-50-21.SDR SWAA2012120310097Angle · crackedCRACK ON VERTICAL ANGLE AT STRUT TORQUE BOX ACCESS PANEL 5858R ENGINE 2. REPLACED ANGLE IAW SRM AND DWG.SDR SWAA2012112901008Tie Clip · crackedCRACK ON TIE CLIP LOCATED AT BSTA 947.5 STR 27L AFT CARGO COMPARTMENT. REPLACED TIE CLIP LOC AT BS 947.5 S-27I AFT CARGO COMPARTMENT IAW B737-300 SRM 51-10-02 ITEM 8 SRM 51-40-02 AND DRAWING 65-46560.
Back to N369SW, cancelled Mar 22, 2018