N522SW, cancelled Jan 6, 2020
Service difficulty reports · 351
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 = 'N522SW' AND deregistration_id = 'N522SW-2020-01-06' 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 = 'N522SW' AND deregistration_id = 'N522SW-2020-01-06' 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 SWAA2013070117760Channel · corrodedAFT CARGO COMPARTMENT FLOOR STRUCTURE FLOOR PANEL SUPPORT CHANNELS CORRODED AT STA 727B+6, RBL 3. REPAIRED CHANNEL IAW SRM AND EA.SDR SWAA2013062617619Strip · crackedL1 DOOR FWD UPPER CORNER OF DOOR CUTOUT COVER ATTACH STRIP CRACKED JUST BELOW STR 6L. REPAIRED STRIP IAW SRM & DRAWING.SDR SWAA2013062517576Channel · crackedLT WING UPPER T/E PANEL SUPPORT CHANNEL CRACKED. R&R CHANNEL IAW SRM & DRAWING.SDR SWAA2013062417483Bracket · crackedLT WING TRAILING EDGE, AFT OF AILERON CABLE TURN AROUND SPRING, COVE PANEL OB ATTACH ANGLE CRACKED. R&R BRACKET IAW SRM & DRAWING.SDR SWAA2013072418526Frame · crackedFRAME CRACKED AT STATION 482, STRINGER 20L. REPAIRED FRAME IAW SRM.SDR SWAA2013070117759Cover · crackedL2 DOOR CUTOUT WARNING SWITCH COVER CRACKED. REMOVED AND REPLACED COVER IAW AMM.SDR SWAA2013060316663Actuator · shearedLEFT WING INBD GROUND SPOILER OTBD ACTUATOR ROD END SHEARED. R & R ACTUATOR IAW MM.SDR SWAA2013060316662Spoiler · brokenLEFT WING INBD GROUND SPOILER BROKEN AT HINGE AREA. R & R SPOILER IAW AMM CK GOOD.SDR SWAA2013060316661Fitting · crackedLEFT WING GROUND SPOILER FITTING ASSY LUG ON NR 4 OTBD ACTUATOR CRACKED. REPAIRED FITTING ASSY IAW EA.SDR SWAA2013052216329Pump · faultyON TAKEOFF BOTH FORE AND AFT NR 1 FUEL PUMP LOW PRESSURE LIGHTS ILLUMINATED WITH CORRESPONDING MASTER CAUTION LIGHTS. LIGHTS WENT OUT APPROX. 1 MINUTE AFTER DECK ANGLE REDUCED. NR 1 TANK AFT PUMP LIGHT ILLUMINATED IN CRUISE FLIGHT. COMPLIED WITH QRH AND OPESDR SWAA2013031213563Sign · looseEXIT SIGN LOOSE AT FWD GALLEY. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA2013010411119Skin · crackedSKIN CRACK LOWER LT FUSELAGE STA 807 + 6 STRINGER 19L ABOVE, 11/2 LONG. VERIFIED BY HFEC PER NDT PART 6 51-00-00 PROCEDURE 23. REPAIRED IAW SRM 53-00-01-2R-31.SDR SWAA2012122110816Door Frame · crackedAFT ENTRY DOOR LOWER FWD CORNER FRAME CRACKED. REMOVED AND REPLACED AFT ENTRY DOOR PER AMM.SDR SWAA2012102308760Battery · dischargedRIGHT FWD PASSENGER CABIN EMERGENCY EXIT LIGHTING INOP. REMOVED & REPLACED BATTERY IAW AMM.SDR SWAA2012101908679Skin · crackedSKIN CRACKED AT BS 390, STR 16R. REPAIRED SKIN PER EA.SDR SWAA2012101108429Stringer · crackedSTRINGER CRACKED AT BS 390, STR 13R. REPAIRED STRINGER PER EA.SDR SWAA2012062605317Uplock Sensor · faultyRED GEAR LIGHT ILLUMINATED IN FLIGHT AND REMAINED ILLUMINATED AFTER RAISING GEAR HANDLE AS DIRECTED BY QRH. FOUND RIGHT MLG UPLOCK SENSOR BAD. REMOVED AND REPLACED RIGHT MLG UPLOCK SENSOR PER AMM.SDR SWAA2012052904430Battery Pack · dischargedR2 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED & REPLACED BATTERY PACK PER AMM.SDR SWAA2012050703731Skin · crackedSKIN CRACKED AT BS 761, STR 19L. REPAIRED SKIN IAW SRM.SDR SWAA2012050703730Skin · crackedSKIN CRACKED AT BS 772, STR 19L. REPAIRED SKIN IAW SRM.SDR SWAA2012050303652Skin · crackedFUSELAGE SKIN CRACKED AT BS 761, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA2012050303651Skin · crackedFUSELAGE SKIN CRACKED AT BS 772, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA2012050103620Slat · delaminatedLT WING NR 2 SLAT UPPER OUTBOARD TRAILING EDGE DELAMINATED. REMOVED AND REPLACED NR 2 SLAT IAW MM.SDR SWAA2012042703491Skin · crackedSKIN CRACKED AT BS 520, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA116482Keelbeam · corrodedDURING SCHEDULED 20Y CHECK, FOUND KEEL BEAM CORRODED BETWEEN BS 482B+4 TO BS 490, STR 28R. REPAIRED BEAM IAW EA.SDR SWAA116481Skin · corrodedDURING SCHEDULED 20Y CHECK, FOUND SKIN CORRODED BETWEEN BS 465 TO BS 471, BETWEEN STR 28R TOS TR 28L. REPAIRED SKIN IAW EO.SDR SWAA116410Flap · delaminatedDURING SCHEDULED 20Y CHECK, FOUND RT WING T/E FORE FLAP DELAMINATED. REMOVED AND REPLACED FORE FLAP IAW MM.SDR SWAA116387Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND SKIN CRACKED AT BS 959.5, STR 17L. REPAIRED SKIN IAW EA.SDR SWAA116366Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND SKIN CRACKED AT BS 827+6.5, STR 18L. REPAIRED SKIN IAW SRM.SDR SWAA116365Frame · corrodedDURING SCHEDULED 20Y CHECK, FOUND FRAME CORRODED AT BS 927, BETWEEN STR 27R TO STR 27L. REPAIRED FRAME IAW SRM.SDR SWAA116364Flap · delaminatedDURING SCHEDULED 20Y CHECK, FOUND RT WING AFT O/B FLAP DELAMINATED. REPAIRED AFT FLAP PER MM.SDR SWAA116363Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND SKIN CRACKED BETWEEN BS 827+4 TO BS 827+14, STR 16L. REPAIRED SKIN IAW SRM.SDR SWAA116208Rib · crackedDURING SCHEDULED 20Y CHECK, FOUND RT HORIZONTAL STABILIZER L/E RIB CRACKED AT STA 1883.94. REMOVED AND REPLACED RIB IAW SRM AND DWG.SDR SWAA116033Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 794.3, BETWEEN STR 23R TO STR 25R. REMOVED AND REPLACED FRAME PER SRM AND DWG.SDR SWAA116032Support Angle · crackedDURING SCHEDULED 20Y CHECK, FOUND SUPPORT ANGLE CRACKED BETWEEN BS 294.5 TO BS 303.9, STR 10L. REMOVED AND REPLACED ANGLE IAW SRM AND DWG.SDR SWAA116010Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 927, STR 24L. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA113925Skin · crackedDURING SCHEDULED CV CHECK FOUND, SKIN CRACKED AT BS 927+4, STR 23L. REPAIRED SKIN PER EA.SDR SWAA113924ASkin · crackedDURING SCHEDULED CV CHECK FOUND, SKIN CRACKED AT BS 887+13, STR 25R. REPAIRED SKIN PER EA.SDR SWAA113923Skin · crackedDURING SCHEDULED CV CHECK FOUND, SKIN CRACKED AT BS 927+15, STR 25R. REPAIRED SKIN PER EA.SDR SWAA113922ASkin · crackedDURING SCHEDULED CV CHECK FOUND, SKIN CRACKED AT BS 847+4, STR 15R. REPAIRED SKIN PER EA.SDR SWAA107848Priority Valve · faultyON LANDING IN SAN LOWERED LANDING GEAR AND GOT RED LIGHT ON LEFT GEAR. CYCLED GEAR 3 TIMES TO GET A GREEN LIGHT. REMOVED AND REPLACED MLG PRIORITY VALVE PER MM.SDR SWAA105156Actuator · faultyAIR TURNBACK, AFTER T/O LEFT MAIN LANDING GEAR LIGHT REMAINED RED IN THE UP POSITION CYCLE LANDING GEAR INDICATION WERE GOOD. RAISED GEAR LEFT MAIN RED LIGHT REMAINED ON. REMOVED AND REPLACED LT MLG ACTUATOR AND UPLOCK ACTUATOR PER MM.SDR SWAA105019Actuator · faultyAIR TURNBACK, RED LEFT GEAR LIGHT ILLUMINATED WHEN GEAR RETRACTED. RED AND GREEN LEFT GEAR LIGHT ILLUMINATED WHEN GEAR LEVEL POSITIONED TO OFF. REMOVED AND REPLACED LT MLG I/B LOCK ACTUATOR PER MM.SDR SWAA103367Skin · crackedDURING SCHEDULED 2HC1 CHECK, FOUND SKIN CRACKED AT BS 941, STR 23R. REPAIRED SKIN PER SRM.SDR SWAA103366Skin · crackedDURING SCHEDULED 2HC1 CHECK, FOUND SKIN CRACKED AT BS 972, STR 21L. REPAIRED SKIN PER SRM.SDR SWAA103365Skin · crackedDURING SCHEDULED 2HC1 CHECK, FOUND SKIN CRACKED AT BS 761, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA103364Skin · crackedDURING SCHEDULED 2HC1 CHECK, FOUND SKIN CRACKED AT BS 944, STR 23R. REPAIRED SKIN PER SRM.SDR SWAA103363Skin · crackedDURING SCHEDULED 2HC1 CHECK, FOUND SKIN CRACKED AT BS 971, STR 21L. REPAIRED SKIN PER SRM.SDR SWAA103362Skin · crackedDURING SCHEDULED 2HC1 CHECK, FOUND SKIN CRACKED AT BS 760, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA102429Light · inoperativeDURING SCHEDULED 18Y CHECK, FOUND LT EMERGENCY EXIT LIGHT INOP AT ROW 11. REMOVED AND REPLACED LIGHT PER MM.
Back to N522SW, cancelled Jan 6, 2020