N511SW, cancelled Jan 2, 2019
Service difficulty reports · 300
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 = 'N511SW' AND deregistration_id = 'N511SW-2019-01-02' 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 = 'N511SW' AND deregistration_id = 'N511SW-2019-01-02' 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 SWAA2013102821574Stringer Clip · crackedSTRINGER CLIP CRACKED AT STATION 360, STRINGER 15L. R & R CLIP IAW SRM.SDR SWAA2013102321417Intercostal · corrodedNLG INSPECTION WINDOW INTERCOSTAL CORRODED. R & R INTERCOSTAL IAW SRM & DRAWING.SDR SWAA2013112622787Skin · crackedFUSELAGE SKIN CRACKED AT L1 DOOR AFT LOWER CUTOUT. REPAIRED SKIN IAW SWA EA.SDR SWAA2013111322301Frame · crackedFRAME CRACKED AT BS 482, STRINGER 14L. REPAIRED FRAME IAW EA.SDR SWAA2013102221346Strap · crackedL1 DOOR UPPER HINGE H STRAP CRACKED AFT LOWER END IN RADIUS. R & R STRAP IAW SRM & DRAWING.SDR SWAA2013111122082Pressure Deck · crackedMAIN WW PRESSURE DECK CRACKED BETWEEN BS 672.5 TO BS 673, RBL41. REPAIRED DECK IAW SRM.SDR SWAA2013110421833Skin · crackedSKIN CRACKED BETWEEN BS 933 TO 934.4, STRINGER 22R. REPAIRED SKIN IAW SRM.SDR SWAA2013112622786Skin · crackedFUSELAGE SKIN CRACKED TA BS 392.5 TO BS 396, STRINGER 1. REPAIRED SKIN IAW SWA EA.SDR SWAA2013112222726Lens · crackedAFT LAVATORY EMERGENCY EXIT LIGHT LENS COVER BROKEN. R & R LENS IAW MM.SDR SWAA2013110421832Skin · crackedSKIN CRACKED BETWEEN BS 783.4 TO BS 784.5, STRINGER 21L. REPAIRED SKIN IAW EA.SDR SWAA2013110421831Skin · crackedSKIN CRACKED BETWEEN BS 892 TO BS 894.5, STRINGER 24R. REPAIRED SKIN IAW SRM.SDR SWAA2013103121717Skin · crackedLT WING NR 3 SLAT ACTUATOR CUTOUT INNER SKIN CRACKED. REPAIRED SKIN IAW SRM.SDR SWAA2013102821577Skin · crackedSKIN CRACKED AT BS 908, STRINGER 4L. REPAIRED SKIN IAW EA.SDR SWAA2013101721252Skin · crackedSKIN CRACKED BETWEEN BS 942.3 TO BS 944, STRINGER 22L. REPAIRED SKIN IAW SRM.SDR SWAA2013101821281Frame · crackedFUSELAGE FRAME CRACKED AT BS 520, STRINGER 20L. REPAIRED FRAME IAW SRM.SDR SWAA2013112222725Slide · crackedL1 DOOR ESCAPE SLIDE GIRT HAS CRACKED PLASTIC SLEEVE AT AFT END. R & R SLIDE ASSEMBLY IAW MT.SDR SWAA2013112222724Skin · crackedFUSELAGE SKIN CRACKED AT BS 482B+6, STRINGER 16R. REPAIRED SKIN IAW SWA EA.SDR SWAA2013112122655Skin · crackedSKIN CRACKED AT BS 482B+14, STRINGER 16L. REPAIRED SKIN IAW EA.SDR SWAA2013112022613Cover · looseR1 DOOR EMERGENCY EVAC SLIDE COVER LOOSE. SECURED COVER IAW SRM.SDR SWAA2013112022612Frame · crackedFRAME FWD FLANGE CRACKED AT BS 727, STRINGER 18A LT. REPAIRED FLANGE IAW EA.SDR SWAA2013112022611Frame · crackedFRAME FWD FLANGE CRACKED AT BS 727, STRINGER 18A RT. REPAIRED FLANGE IAW SWA EA.SDR SWAA2013103121730Skin · crackedFUSELAGE SKIN CRACKED AT BS 425, STRINGER 17R. REPAIRED SKIN IAW ER & SWA EA.SDR SWAA2013100320769Sensor · faultyNR 2 ENGINE WILL NOT GO TO IDLE IN DESCENT WITH THRUST LEVERS AT IDLE. R & R CIT SENSOR IAW AMM.SDR SWAA2013082619541Lens · looseLT OVERWING EXIT SIGN LOOSE. R&R LENS IAW AMM.SDR SWAA2013032113946Skin · crackedSKIN CRACKED AT BS 360, BETWEEN STR 2R AND STR 3R. REPAIRED SKIN IAW EA.SDR SWAA2013032113945Skin · crackedSKIN CRACKED AT BS 360, BETWEEN STR 1R AND STR 2R. REPAIRED SKIN IAW EA.SDR SWAA2013032113944Skin · crackedSKIN CRACKED AT BS 360, BETWEEN STR 1L AND STR 2L. REPAIRED SKIN IAW EA.SDR SWAA2012010500Sensor · faultyPOWER REDUCED ON BOTH ENGINE NR 2 ENGINE NOT RESPONSIVE TO THRUST LEVER POSITION. REMOVED AND REPLACED SENSORS IAW M/M.SDR SWAA2012121110500Sensor · faultyON DESCENT FROM FL 210, POWER REDUCED ON BOTH ENGINES, NR 2 ENGINE NOT RESPONSIVE TO THRUST LEVER POSITION FOR +1/-2 MINS AND MAINTAINED 80% N1 WHILE / THE LEVER AT 101E. SUBSEQUENTLY BEGAN RESPONDING TO THRUST LEVER AND OPERATED NORMALLY TO LANDINGSDR SWAA2012111209220Lens · missingRIGHT OVERWING EMERGENCY EXIT SIGN MISSING. INSTALLED LENS PER AMM.SDR SWAA2012100108095Skin · crackedFUSELAGE SKIN CRACKED AT BS 498, STR 19R. REPAIRED SKIN PER EA.SDR SWAA2012062505212Lens · missingFWD EEPLS LENS MISSING. INSTALLED LENS IAW M/M.SDR SWAA2012050403687Light · disconnectedL2 DOOR LOWER EMERGENCY LIGHT INOP. RECONNECTED LIGHT ASSY IAW MM.SDR SWAA2012041803221Frame · brokenFUSELAGE FRAME BROKEN AT BS 847, BETWEEN STRINGERS 17R AND 18R LOWER END IS BROKEN. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA2012041603166Structure · corrodedLT AFT INNER CHORD CORRODED AT BS 967, LBL 52 IAW SRM. REPAIRED CHORD IAW AMM.SDR SWAA2012042503383Skin · puncturedLT WING INBD FORE FLAP LOWER SURFACE PUNCTURED. REPAIRED FLAP PER SRM.SDR SWAA2012041903242Skin · delaminatedLEFT WING I/B FOREFLAP UPPER SURFACE DELAMINATED. REPAIRED FLAP PER SRM.SDR SWAA2012041703175Skin · puncturedLEFT WING I/B FORE FLAP LOWER SURFACE PUNCTURED. REPAIRED FORE FLAP IAW SRM.SDR SWAA2012041603139Web · corrodedR2 DOOR THRESHOLD CENTER FLOOR PAN WEB CORRODED AT STA 980. REMOVED AND REPLACED WEB PER BAC DWG & SRM.SDR SWAA2012043003602Floorbeam · crackedFLOORBEAM WEB CRACKED AT BS 295.5, LBL 53. REPAIRED WEB IAW EA.SDR SWAA2012041203074Web · crackedFWD CARGO DOOR CUTOUT AREA AFT TORQUE BOX LOWER AFT CORNER INNER WEB CRACKED. REMOVED AND REPLACED WEB PER MM, SRM, & BAC DWG.SDR SWAA2012041103013Angle · crackedSHEAR WEB ANGLE CRACKED BETWEEN BS 380 TO BS 400, BL 0. REMOVED AND REPLACED ANGLE PER BAC DWG AND SRM.SDR SWAA2012043003603Floorbeam · crackedMAIN CABIN FLOORBEAM T-CAP CRACKED AT BS 294.5, LBL 52. REMOVED T-CAP IAW SRM.SDR SWAA2012043003601Web · crackedFORWARD CARGO PIT DOOR CUTOUT AREA LOWER TORQUE BOX CRACKED BETWEEN BS 420 TO BS 440, STR 26R. REPAIRED WEB PER EA.SDR SWAA2012043003600Skin · crackedL2 DOOR FUSELAGE SKIN FWD LOWER CORNER CRACKED AT UPPER RADIUS OF CORNER LOWEST FASTENER. REPAIRED SKIN PER EA.SDR SWAA2012042703489Crease Beam · corrodedRT CREASE BEAM WEB CORRODED BETWEEN BS 847 TO BS 86.7. REMOVED & REPLACED WEB IAW BAC DWG, SRM, & AMM.SDR SWAA2012042603432Crease Beam · corrodedLT CABIN CREASE BEAM WEB CORRODED AT BS 370. REMOVED AND REPLACED WEB IAW BAC DWG AND SRM.SDR SWAA2012042403353Floorbeam · corrodedFLOORBEAM CORRODED AT BS 986, RBL 45. REPAIRED FLOORBEAM PER SRM AND EA.SDR SWAA2012042403352Crease Beam · corrodedLT CREASE BEAM CORRODED AT BS 867 TO BS 887. REPAIRED BEAM PER SRM AND BAC DRAWING.SDR SWAA2012041803220Floor Support · corrodedRT FLOOR SUPPORT BS 986.5, RBL 16 CORRODED. REMOVED AND REPLACED FLOOR SUPPORT PER SRM.
Back to N511SW, cancelled Jan 2, 2019