N384SW, cancelled Aug 3, 2018
Service difficulty reports · 368
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 = 'N384SW' AND deregistration_id = 'N384SW-2018-08-03' 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 = 'N384SW' AND deregistration_id = 'N384SW-2018-08-03' 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 SWAA2012121710677Cover · brokenRIGHT SIDE OVERWING EMERGENCY EXIT COVER BROKEN OFF. REMOVED AND REPLACED COVER ASSY PER MM.SDR SWAA2012120410213Shaft · shearedIN CLIMB ABOVE FL340-FL370 THE NR 1 ENGINE WOULD NOT MAINTAIN CLIMB N1 OF 93.1% THE MAX IT MAINTAINED AT THOSE ALTITUDES WAS 91.8 WHICH DECREASED TO A MAX OF 91.4 AT FL370. N1 EGI WAS 796 VS N2 OF 699; N2'S WERE 96.6 AND 91.2 RESPECTIVELY. AT CRUISE POWER THESDR SWAA2012100108206Sign · crackedL1 DOOR EMERGENCY EXIT SIGN CRACKED. REMOVED AND REPLACED SIGN PER M/M.SDR SWAA2012092507973Pump · faultyABOUT A 900 POUND FUEL IMBALANCE OVER THE DURATION OF THE FLIGHT CROSSFEED CORRECTED THE IMBALANCE. TANK NR 2 THE LOW TANK. REMOVED AND REPLACED NR 1 FWD FUEL BOOST PUMP PER M/M.SDR SWAA2012080306435Slide · out of adjustL1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MT.SDR SWAA2012070305525Light · looseLEFT EEPLS LOOSE BETWEEN ROW 7 TO ROW 8. REMOVED AND REPLACED EEPLS PER AMM.SDR SWAA2012062105118Actuator · out of adjustON TAKEOFF WITH YOKE CENTERED THE AIRCRAFT ROLLED TO THE RIGHT. THE AIRCRAFT ROLLED RIGHT WITH YOKE CENTERED IN ALL MANUAL FLIGHT. REMOVED AND REPLACED AILERON TRIM ACTUATAOR BOTH SPRINGS AND ROLLERS PER M/M.SDR SWAA2012061404937Slide · out of positionR2 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MT.SDR SWAA2012040902850Rib · crackedRT HORIZONTAL STABILIZER RIB CHORD CRACKED AT STA 147.9. REMOVED AND REPLACED CHORD PER SRM.SDR SWAA2012040902852Floorbeam · crackedLONGITUDINAL FLOORBEAM FOUND CRACKED AT BS 670, LBL 24.8. REPAIRED BEAM PER ER AND EA.SDR SWAA2012040302788Shear Tie · corrodedSHEAR TIE CORRODED AT BS 887, RBL 1. REPAIRED SHEAR TIE PER ER AND EA.SDR SWAA2012040202748Skin · crackedL1 DOOR BEAR STRAP SKIN CUTOUT AFT LOWER CORNER CRACKED. REPAIRED SKIN PER ER AND EA.SDR SWAA2012040202735Shear Tie · corrodedSHEAR TIE CORRODED AT BS 907, BETWEEN STR 25R TO STR 26R. REPAIRED SHEAR TIE PER ER AND EA.SDR SWAA2012040202734Shear Tie · corrodedSHEAR TIE CORRODED AT BS 727B, BETWEEN STR 26LTO STR 27L. REPAIRED SHEAR TIE PER EA.SDR SWAA2012032902694Angle · crackedL1 DOOR LOWER AFT CORNER FOUND LOWER AFT SILL ANGLE CRACKED. REPAIRED ANGLE PER SRM.SDR SWAA2012032902657Skin · delaminatedLT WING I/B FORE FLAP UPPER SURFACE DELAMINATED. REPAIRED FORE FLAP IAW SRM.SDR SWAA2012032702613Floor Support · corrodedFLOOR SUPPORT ANGLE CORRODED AT BS 727D+6, LBL 8. REPAIRED ANGLE PER SRM.SDR SWAA2012032602590Skin · puncturedRIGHT WING I/B FOR FLAP LOWER SURFACE PUNCTURED. REPAIRED FORE FLAP IAW SRM.SDR SWAA2012032602583Frame · crackedFRAME INNER CHORD CRACKED AT BS 616, LBL 65. REPAIRED CHORD PER EA.SDR SWAA2012032602582Crease Beam · corrodedCREASE BEAM WEB CORRODED BETWEEN BS 500 TO BS 500A, LBL 60. REPAIRED WEB PER SRM AND DWG.SDR SWAA2012040902851Skin · crackedRT HORIZONTAL STABILIZER LOWER SKIN CRACKED AT STA 96. REPAIRED SKIN IAW EA.SDR SWAA2012032902656Skin · crackedLT HORIZONTAL STABILIZER CRACKED IN LOWER SKIN AT STA 112.138. REPAIRED STABILIZER IAW EA.SDR SWAA120560Bracket · looseL1 DOOR EMERGENCY EVAC SLIDE GIRT BAR BRACKETS LOOSE. SECURED BRACKETS PER MM.SDR SWAA2012021601502Attach Angle · crackedCRACK AT FASTENER HOLE ON SEAL RETAINER ATTACH ANGLE AT RT MLG CUTOUT FWD O/B SIDE. REPAIRED ANGLE PER EA.SDR SWAA117680Wire · damagedDURING SCHEDULED SPV CHECK, FOUND AFT OVERHEAD EMERGENCY EXIT BULLNOSE LIGHT INOP. REPAIRED WIRE IAW WDM.SDR SWAA117679Lens · crackedDURING SCHEDULED SPV CHECK, FOUND FWD LAVATORY EMERGENCY EXIT LIGHT LENS CRACKED. REMOVED AND REPLACED LENS ASSY PER MM.SDR SWAA117623Bulb · brokenDURING SCHEDULED SPV CHECK, FOUND L1 DOOR EXTERIOR EMERGENCY EXIT LIGHT BULB BROKEN. REMOVED AND REPLACED BULB IAW MM.SDR SWAA117622Light · brokenDURING SCHEDULED SPV CHECK, FOUND RT OVERHEAD EMERGENCY EXIT BULLNOSE LIGHT BROKEN AT ROW 5. REMOVED AND REPLACED LIGHT IAW MM.SDR SWAA117621Wire · brokenDURING SCHEDULED 22Y CHECK, FOUND EMERGENCY EXIT LIGHT RESISTOR WIRE BROKEN AT BS 263, STR 2L. REPAIRED WIRE IAW MM.SDR SWAA117393Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 847, STR 4L. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA117164Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE WINDOW SKIN CRACKED AT 500A+10 UPPER FORWARD CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA117224Stringer Clip · missingDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP MISSING AT BS 520, STR 3L. INSTALLED CLIP PER SRM AND DWG.SDR SWAA117110Skin · crackedDURING SCHEDULED SPV CHECK, FOUND LT FUSELAGE WINDOW SKIN CRACKED AT BS 500A+10 AFT FORWARD CORNER. REPAIRED SKIN PER SRM.SDR SWAA117109Skin · crackedDURING SCHEDULED SPV CHECK, FOUND LT FUSELAGE WINDOW SKIN CRACKED AT BS 520+10 UPPER FORWARD CORNER. REPAIRED SKIN PER SRM.SDR SWAA117108Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 500, STR 7L. REMOVED AND REPLACED CLIP IAW SRM.SDR SWAA117039Stringer · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CRACKED AT BS 271, STR 3L. REPAIRED STRINGER.SDR SWAA117011Skin · crackedDURING SCHEDULED SPV CHECK, FOUND RT FUSELAGE WINDOW SKIN CUTOUT CRACKED AT BS 500+10, LOWER AFT CORNER. REPAIRED SKIN PER SRM.SDR SWAA117010Skin · crackedDURING SCHEDULED SPV CHECK, FOUND RT FUSELAGE WINDOW SKIN CUTOUT CRACKED AT BS 460+10, LOWER AFT CORNER. REPAIRED SKIN PER SRM.SDR SWAA117009Skin · crackedDURING SCHEDULED SPV CHECK, FOUND RT FUSELAGE WINDOW SKIN CUTOUT CRACKED AT BS 500B+10, UPPER FORWARD CORNER. REPAIRED SKIN PER SRM.SDR SWAA117008Skin · crackedDURING SCHEDULED SPV CHECK, FOUND RT FUSELAGE WINDOW SKIN CUTOUT CRACKED AT BS 460+10, UPPER FORWARD CORNER. REPAIRED SKIN PER SRM.SDR SWAA117007Skin · crackedDURING SCHEDULED SPV CHECK, FOUND RT FUSELAGE WINDOW SKIN CUTOUT CRACKED AT BS 440+10, UPPER FORWARD CORNER. REPAIRED SKIN PER SRM.SDR SWAA117006Skin · crackedDURING SCHEDULED SPV CHECK, FOUND RT FUSELAGE WINDOW SKIN CUTOUT CRACKED AT BS 500+10, LOWER AFT CORNER. REPAIRED SKIN PER SRM.SDR SWAA117005Skin · crackedDURING SCHEDULED SPV CHECK, FOUND LT FUSELAGE WINDOW SKIN CUTOUT CRACKED AT BS 480+10, LOWER AFT CORNER. REPAIRED SKIN PER SRM.SDR SWAA117004Skin · crackedDURING SCHEDULED SPV CHECK, FOUND LT FUSELAGE WINDOW SKIN CUTOUT CRACKED AT BS 360+10, LOWER AFT CORNER. REPAIRED SKIN PER SRM.SDR SWAA117003Skin · crackedDURING SCHEDULED SPV CHECK, FOUND LT FUSELAGE WINDOW SKIN CUTOUT CRACKED AT BS 500C+10, UPPER FORWARD CORNER. REPAIRED SKIN PER SRM.SDR SWAA116915Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 967, BETWEEN STR 4L TO STR 5L. REPAIRED SHEAR TIE IAW SRM.SDR SWAA116888Skin · crackedDURING SCHEDULED SPV CHECK, FOUND LT FUSELAGE WINDOW SKIN CUTOUT CRACKED AT BS 847+10. REPAIRED SKIN IAW EA.SDR SWAA116867Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 277, STR 4L. REMOVED AND REPLACED CLIP IAW DWG.SDR SWAA116836Skin · crackedDURING SCHEDULED SPV CHECK, FOUND RT UPPER AFT WINDOW SKIN CORNER CUTOUT CRACKED AT BS 727+10. REPAIRED SKIN IAW DWG.SDR SWAA116516Skin · delaminatedDURING SCHEDULED SPV CHECK, FOUND LT WING NR 3 SLAT SKIN DELAMINATED ON CORNER. REPAIRED SKIN IAW SRM.
Back to N384SW, cancelled Aug 3, 2018