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 SWAA2014121134920Fitting · crackedFORWARD GALLEY DOOR CUT OUT FITTING CRACKED AT BS 337.6, STRINGER 8R. R & R FITTING IAW SRM & DWG.SDR SWAA2014120934847Support Bracket · crackedLEFT WING MID FLAP OTBD SUPPORT BRACKET CRACKED. R & R BRACKET IAW SRM & DWG.SDR SWAA2014120834767Floorbeam · corrodedFLOORBEAM CORRODED AT BS 312, BETWEEN LBL 8 TO RBL 8. REPAIRED BEAM IAW SRM.SDR SWAA2014121735104Support Angle · crackedRIGHT WING FIXED TE SUPPORT ANGLE CRACKED AT RSS 533+12. R & R ANGLE IAW SRM & DWG.SDR SWAA2014121535016Support Angle · crackedAFT CARGO COMPARTMENT SUPPORT ANGLE CRACKED BETWEEN BS 727D TO 727E, BETWEEN STRINGER 27R TO 27L. R & R ANGLE IAW SRM & DWG.SDR SWAA2014121234951Fitting · wornL1 DOOR EMER EVAC SLIDE GIRT BAR FITTING SHIMS WORN. R & R FITTING ASSEMBLY IAW AMM.SDR SWAA2014121234950Support Angle · crackedLEFT WING TE SUPPORT ANGLE CRACKED AT WBL 71.24. R & R ANGLE IAW SRM & DWG.SDR SWAA2014121234944Fitting · wornR1 DOOR EMER EVAC SLIDE GIRT BAR FITTING SHIMS WORN. R & R FITTING ASSEMBLY IAW AMM.SDR SWAA2014120334610Angle · crackedRIGHT WING FIXED TE ANGLE CRACKED AT RSS 533+12. R & R ANGLE IAW SRM & DWG.SDR SWAA2014120234588Support Angle · crackedLEFT WING SUPPORT ANGLE CRACKED AT TE INTERNAL CAVITY AT LEVEL WS 531. R & R ANGLE IAW SRM & DWG.SDR SWAA2015010535465Skin · crackedNUMBER 6 LE SLAT TE SKIN CRACKED AT STATION 380. REPAIRED SKIN IAW EA.SDR SWAA2015010235411Floor Support · crackedLONGITUDINAL FLOORBEAM CRACKED AT STATION 669.75, LBL 24.5. REPAIRED IAW EA.SDR SWAA2014121935157Frame · crackedFUSELAGE FRAME CRACKED AT STATION 520, STRINGER 20L TO 21L. REPAIRED FRAME IAW SRM.SDR SWAA2014121134919Attach Fitting · crackedLONGITUDINAL FLOORBEAM ATTACHMENT CLIP CRACKED AT BS 639, RBL 45.5. R & R CLIP IAW SRM & DWG.SDR SWAA2014120834766Attach Fitting · crackedLONGITUDINAL FLOORBEAM ATTACHMENT CLIP CRACKED AT BS 639, LBL 45.5. R & R CLIP IAW SRM & DWG.SDR SWAA2015010535468Frame · crackedLEFT FUSELAGE FRAME STATION 727 CRACKED AT STRINGER 18A. REPAIRED FRAME IAW EA.SDR SWAA2015010535467Frame · crackedRIGHT FUSELAGE FRAME STATION 727 CRACKED AT STRINGER 18A. REPAIRED FRAME IAW EA.SDR SWAA2015010535466Frame · crackedRIGHT FUSELAGE FRAME CHORD STATION 727 CRACKED AT STRINGER 18A FWD LOWER SECTION. REPAIRED FRAME IAW EA.SDR SWAA2014111834281Floor Support · crackedLEFT MAIN WW UPPER PRESS DECK LONGITUDINAL FLOORBEAM LOWER CHORD INBD FLANGE ANGLE CRACKED AT BS 663, LBL 45. REPAIRED CHORD IAW SRM.SDR SWAA2014111834280Floor Support · crackedLEFT MAIN WW UPPER PRESS DECK LONGITUDINAL FLOORBEAM LOWER CHORD ANGLE INBD FLANGE DOUBLER CRACKED AT BS 663, LBL 24. R & R ANGLE IAW SRM & DWG.SDR SWAA2014111734197Angle · crackedLEFT MAIN WW UPPER PRESS DECK ANGLE CRACKED AT BS 663, LBL 24. REPAIRED ANGLE IAW SRM.SDR SWAA2014111934312Pressure Deck · crackedMAIN WW HORIZONTAL PRESS DECK CRACKED AT BS 665, BETWEEN LBL 3 TO LBL 22. REPAIRED DECK IAW EA.SDR SWAA2014102833388Sign · unsecureL1 DOOR EXIT SIGN FELL OFF. R & R EXIT SIGN IAW MM.SDR SWAA2014093032448Battery · dischargedLEFT AFT FLASHLIGHT IN AFT GALLEY INOPERATIVE. R & R BATTERY IAW SIP.SDR SWAA2014091632031Lens · brokenAFT EMER EXIT LIGHT LENS COVER BROKEN. SECURED COVER IAW AMM.SDR SWAA2014060728922Lens · looseRIGHT OVERWING EMER EXIT LIGHT LENS LOOSE. R & R LENS IAW AMM.SDR SWAA2014060928803Hydraulic Line · faultyA SYS HYD PRESS & QTY WENT TO 0 WHEN LANDING GEAR SELECTED DOWN. R & R NOSE GEAR ACTUATOR EXTEND HYD LINE IAW SIP.SDR SWAA2014051327892Slat · delaminatedLEFT WING NR 2 LE SLAT DELAMINATED. R & R LE SLAT IAW MM.SDR SWAA2014041427065Skin · crackedRIGHT HORIZONTAL STABILIZER LOWER SURFACE SKIN CRACKED AT REAR SPAR STAB STATION 152.90. REPAIRED SKIN IAW EA.SDR SWAA2014041427064Skin · crackedFORWARD ENTRY DOOR INNER SKIN CRACKED AT LOWER HINGE BOX. R & R L1 DOOR IAW MM.SDR SWAA2014041427063Lens · looseRIGHT OVERWING EMERGENCY EXIT LIGHT LENS COVER LOOSE. SECURED COVER IAW AMM.SDR SWAA2014021725188Slide · out of positionL2 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW MT.SDR SWAA2014011324031Lens · brokenFWD ENTRY EMERGENCY EXIT LIGHT LENS BROKEN. R & R LENS IAW MM.SDR SWAA2013111822417Wedge · debondedLT WING NR 3 SLAT UPPER SURFACE TE WEDGE DISBONDED. R & R NR 3 SLAT IAW MM.SDR SWAA2013111822416Frame · crackedFRAME CRACKED AT BS 520, BETWEEN STRINGER 20R & 21R. REPAIRED FRAME IAW SRM.SDR SWAA2013111822415Frame · crackedFRAME CRACKED AT BS 500B, BETWEEN STRINGER 20L & 21L. REPAIRED FRAME IAW SRM.SDR SWAA2013111822414Skin · crackedSKIN CRACKED BETWEEN 345.5 TO 348.5, STRINGER 2L. REPAIRED SKIN IAW SRM.SDR SWAA2013111822413Pressure Panel · crackedPRESSURE DECK SKIN IN RT MAIN WW CRACKED AT STATION 664, RBL 41. REPAIRED SKIN IAW SRM.SDR SWAA2013091820212Slide · out of positionL2 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW SIP.SDR SWAA2013031113533Cover · looseEXIT SIGN COVER LOOSE AT FWD F/A'S SEAT. SECURED COVER PER MM.SDR SWAA2013030413290Skin · debondedLEFT WING INBOARD FOREFLAP, UPPER SURFACE, 4"X 5" DISBONDED, 32" INBOARD OF OUTBOARD END. REMOVED & REPLACED FORE FLAP IAW MM.SDR SWAA2013030413289Wire · brokenAFT GALLEY EMERGENCY LIGHT HAS A BROKEN WIRE. REPAIRED LIGHT PER SWPM & AMM.SDR SWAA2013030413288Skin · crackedCRACK IN FUSELAGE SKIN AT BS 953, BETWEEN STR 14L- STR 15L. REPAIRED SKIN IAW SRM & EA.SDR SWAA2013030413287Skin · crackedCRACK IN FUSELAGE SKIN AT CHEM-MILL BETWEEN BS 446 - 447, STR 1L. REPAIRED SKIN PER EA & ER.SDR SWAA2012121010376Light · inoperativeEMERGENCY LIGHT ON RIGHT AFT WING TO BODY FAIRING DOES NOT TURN ON. REPLACEMENT EMERGENCY LIGHT ON RIGHT AFT WING TO BODY FAIRING AND PERFORMED OPERATIONAL TEST, TEST IS OK IAW AMM 33-51-22.SDR SWAA2012121010375Nut Plate · looseLOOSE BOLTS ON BALL SCREW FITTING AREA AT FLAP TRACK NR 7 RT WING. REPLACED NUT PLATES AND TIGHTENED BOLTS ON BALL SCREW FITTING AREA AT FLAP TRACK NR 7 RT WING IAW SRM 51-40-02.SDR SWAA2012120710307Support Fitting · crackedCRACK ON SUPPORT FITTING LOCATED ON STA 150, WBL 84.64 ON LEFT WING GROUND SPOILER. REPLACED SUPPORT FITTING LOCATED ON STA 150, WBL 84.64 ON LEFT WING GROUND SPOILER IAW B737-300 SRM 51-10-02 AND DWG 65-50817.SDR SWAA2012120710306Skin · delaminatedDELAMINATION LOCATED ON LOWER SKIN I/B FORE FLAP RIGHT WING AT 47" FROM I/B EDGE. REPAIRED LOWER SKIN I/B FORE FLAP RIGHT WING AT 47" FROM I/B EDGE IAW B737-300 SRM 51-70-10-2R-0.SDR SWAA2012112901004Skin · corrodedCORROSION ON LOWER L/E SKIN AT INBOARD T/E AFT FLAP RIGHT WING. PERFORMED REPAIR ON LOWER L/E SKIN LOC WBL 73+19" AT INBOARD T/E AFT FLAP RIGHT WING IAW SRM B737-300 57-53-01-2R-4 REPAIR 4, 51-40-02SDR SWAA2012113010052Frame · corrodedCRACK HOLE SHEAR TIE FRAME AT BS 727D STR 27L CARGO COMPARTMENT. REPAIRED FRAME IAW SRM AND DWG.
Back to N368SW, cancelled Mar 22, 2018