N528SW, cancelled Mar 27, 2018
Service difficulty reports · 353
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 = 'N528SW' AND deregistration_id = 'N528SW-2018-03-27' 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 = 'N528SW' AND deregistration_id = 'N528SW-2018-03-27' 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 SWAA117427Shear Tie · corrodedDURING SCHEDULED OTS CHECK, FOUND SHEAR TIE CORRODED AT BS 967, BETWEEN STR 27L TO STR 27R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA117278Skin · corrodedDURING SCHEDULED OTS CHECK, FOUND SKIN CORRODED AT BS 949, STR 27L. REPAIRED SKIN IAW SRM AND DWG.SDR SWAA117358Shear Tie · corrodedDURING SCHEDULED OTS CHECK, FOUND SHEAR TIE CORRODED BETWEEN BS 927, BETWEEN STR 26L TO STR 27L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA117357Skin · corrodedDURING SCHEDULED OTS CHECK, FOUND BEAR STRAP SKIN CORRODED AT BS 987, BETWEEN STR 27L TO STR 27R. REPAIRED SKIN IAW SRM AND DWG.SDR SWAA117171Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 402, STR 16R. REPAIRED SKIN IAW ER AND EA.SDR SWAA117200Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 969, STR 21L. REPAIRED SKIN IAW ER.SDR SWAA117077Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED BETWEEN BS 793 TO BS 813, BETWEEN STR 19L TO STR 21L. REPAIRED SKIN IAW EA AND ER.SDR SWAA117076Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED BETWEEN BS 747 TO BS 762, BETWEEN STR 23L TO STR 25L. REPAIRED SKIN IAW EA AND ER.SDR SWAA116609Light · brokenDURING SCHEDULED 2HC2 CHECK, FOUND RT EEPLS BROKEN AT ROW 1. REMOVED AND REPLACED EEPLS PER MM.SDR SWAA116608Light · brokenDURING SCHEDULED 2HC2 CHECK, FOUND RT EEPLS BROKEN AT ROW 3. REMOVED AND REPLACED EEPLS PER MM.SDR SWAA116607Light · brokenDURING SCHEDULED 2HC2 CHECK, FOUND RT EEPLS BROKEN AT ROW 11. REMOVED AND REPLACED EEPLS PER MM.SDR SWAA116606Light · brokenDURING SCHEDULED 2HC2 CHECK, FOUND RT EEPLS BROKEN AT ROW 7. REMOVED AND REPLACED EEPLS PER MM.SDR SWAA116605Skin · crackedDURING SCHEDULED 2HC2 CHECK, FOUND SKIN CRACKED AT BS 803, STR 20L. REPAIRED SKIN PER SRM.SDR SWAA116604Skin · crackedDURING SCHEDULED 2HC2 CHECK, FOUND SKIN CRACKED BETWEEN BS 747+6 TO BS 747+8, STR 24L. REPAIRED SKIN PER SRM.SDR SWAA116613Attach Angle · missingDURING SCHEDULED 2HC2 CHECK, FOUND RT ELEVATOR ATTACH ANGLE MISSING. REMOVED AND REPLACED ELEVATOR ASSY PER MM.SDR SWAA116612Skin · crackedDURING SCHEDULED 2HC2 CHECK, FOUND SKIN CRACKED AT BS 402, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA116611Slide · out of positionDURING SCHEDULED 2HC2 CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE INADVERTANTLY FELL OUT, DID NOT DEPLOY. REMOVED AND REPLACED SLIDE PER MT.SDR SWAA116610Slide · wornDURING SCHEDULED 2HC2 CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE WORN. REMOVED AND REPLACED SLIDE PER MT.SDR SWAA113852Connector · disconnectedDURING SCHEDULED SPV CHECK FOUND, LT FWD OVERWING EMERGENCY EXIT LIGHT INOP. RECONNECTED CONNECTOR PER MM.SDR SWAA113851Battery Pack · failedDURING SCHEDULED SPV CHECK FOUND, RT AFT EMERGENCY EXIT LIGHT BATTERY PACK FAILED. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA113850Skin · crackedDURING SCHEDULED SPV CHECK FOUND, SKIN CRACKED AT BS 400, WL 232.5. REPAIRED SKIN PER EA.SDR SWAA113818Skin · crackedDURING SCHEDULED SPV CHECK FOUND, RT FUSELAGE SKIN CRACKED AT BS 400, WL 232.5. REPAIRED SKIN PER EA.SDR SWAA113262Skin · delaminatedDURING SCHEDULED SPV CHECK FOUND RT INBD FOREFLAP METAL BOND REPAIR (UPPER SURFACE) DELAMINATED. REPAIRED RIGHT I/B FOREFLAP PER SRMSDR SWAA113150Shear Web · corrodedDURING SCHEDULED SPV CHECK, FOUND SHEAR WEB CORRODED BETWEEN BS 380 TO BS 400, STR 17R. REMOVED AND REPLACED WEB PER SRM.SDR SWAA110525Web · crackedDURING SCHEDULED 2HC1 CHECK, FOUND WING BOX RT UPPER I/B BEAM WEB CRACKED. REPAIRED WEB PER SRM.SDR SWAA106400Slide · out of positionL1 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MT.SDR SWAA106017Stringer · crackedDURING SCHEDULED MV2 CHECK, FOUND STRINGER CRACKED AT BS 421, STR 17R. REPAIRED STRINGER PER SRM.SDR SWAA105303Lens · brokenDURING SCHEDULED MV2 CHECK, FOUND RT OVERWING EMERGENCY EXIT LIGHT LENS BROKEN. REMOVED AND REPLACED LENS PER MM.SDR SWAA103645Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND SKIN CRACKED AT BS 800, STR 23L. REPAIRED SKIN PER SRM.SDR SWAA103644Slide · out of positionDURING SCHEDULED HC2 CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MM.SDR SWAA102576Slide · out of adjustR2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA100525Skin · crackedDURING SCHEDULED 18Y CHECK, FOUND GROUND AIR CONDITION DOOR CUTOUT CRACKED AT FWD LT CORNER. REPAIRED SKIN PER ER.SDR SWAA100485Flap · delaminatedDURING SCHEDULED 18Y CHECK, FOUND LT WING O/B FORE FLAP T/E DELAMINATED. REPAIRED FORE FLAP PER SRM.SDR SWAA100452Floorbeam · crackedDURING SCHEDULED 18Y CHECK, FOUND LONGITUDINAL FLOORBEAM LOWER CHORD WEB CRACKED AT BS 664, LBL 24.8. REPAIRED BEAM PER ER.SDR SWAA100372Floorbeam · crackedDURING SCHEDULED 18Y CHECK, FOUND LONGITUDINAL FLOORBEAM LOWER CHORD CRACKED AT BS 707, BL 0. REPAIRED CHORD PER SI.SDR SWAA100371Skin · crackedDURING SCHEDULED 18Y CHECK, FOUND SKIN CRACKED AT BS 842, STR 17L. REPAIRED SKIN PER SRM.SDR SWAA100370Angle · crackedDURING SCHEDULED 18Y CHECK, FOUND FRAME TO FLOORBEAM ANGLE CRACKED AT BS 727B, RBL 45. REMOVED AND REPLACED ANGLE PER SRM.SDR SWAA100143Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 761, STR 23L. REPAIRED SKIN PER EA.SDR SWAA100142Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 765, STR 23L. REPAIRED SKIN PER EA.SDR SWAA100140Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 764, STR 22L. REPAIRED SKIN PER EA.SDR SWAA097999Slide · out of positionR2 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MM.SDR SWAA097747Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND SKIN CRACKED AT BS 955, STR 18L. REPAIRED SKIN PER EA.SDR SWAA096352Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND RT OVERHEAD EMERGENCY EXIT BULLNOSE LIGHT INOP. REMOVED AND REPLACED LIGHT PER MM.SDR SWAA095928Light · brokenDURING SCHEDULED MV1 CHECK, FOUND L1 DOOR LOWER EMERGENCY EXIT LIGHT ASSY BROKEN. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA093978Lens · crackedR1 DOOR EMERGENCY EXIT LIGHT LENS CRACKED. REMOVED AND REPLACED LENS PER MM.SDR SWAA093713Flap · delaminatedDURING SCHEDULED SPV CHECK, FOUND RT WING TRAILING EDGE O/B AFT FLAP DELAMINATED. REMOVED AND REPLACED AFT FLAP PER MM.SDR SWAA093712Skin · crackedDURING SCHEDULED SPV CHECK, FOUND LT HORIZONTAL STABILIZER LOWER SURFACE CRACKED. REPAIRED STABILIZER PER SWA EA.SDR SWAA087303Sensor · faultyAIR TURNBACK - BETWEEN 10K & 15K FT ON CLIMB NR 1 N1 WAS 80 PERCENT OR 12 LESS THAN NR 2 N1. MOVED NR 1 THRUST LEVER TO STOP, NO DIFFERENCE, TURNED PMC NR 1 OFF NO DIFFERENCE. REMOVED AND REPLACED NR 1 ENGINE CIT SENSOR PER MM.SDR SWAA086776Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER SWA EA.SDR SWAA086775Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT R2 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER SRM.
Back to N528SW, cancelled Mar 27, 2018