N690SW, cancelled Jan 28, 2013
Service difficulty reports · 240
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 = 'N690SW' AND deregistration_id = 'N690SW-2013-01-28' 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 = 'N690SW' AND deregistration_id = 'N690SW-2013-01-28' 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 SWAA117836Switch · faultyAIR TURNBACK - GEAR WOULD NOT RETRACT NORMALLY ON TAKEOFF/RETRACTED NORMALLY WITH OVERRIDE. REMOVED AND REPLACED R276 RELAY, M911 PC CARD SENSING SWITCH IN E11, LANDING GEAR LEVER LOCK SOLENOID PER MM.SDR SWAA113395Lens · brokenL1 DOOR EMERGENCY EXIT LIGHT LENS BROKEN. REMOVED AND REPLACED LENS PER MM.SDR SWAA110435Slide · looseR2 DOOR EMERGENCY EVAC SLIDE LOOSE. SECURED SLIDE PER MM.SDR SWAA105242Battery · dischargedDURING SCHEDULED MV2 CHECK, FOUND L1 DOOR OVERHEAD EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED CHARGER & BATTERY ASSY PER MM.SDR SWAA101555Skin · delaminatedDURING SCHEDULED 22Y CHECK, FOUND RT WING I/B AFT FLAP LOWER SURFACED DELAMINATED. REPAIRED AFT FLAP PER SRM.SDR SWAA101552Frame · corrodedDURING SCHEDULED 22Y CHECK, FOUND FRAME WEB CORRODED AT BS 312, STR 28L. REPAIRED WEB PER AEM EO.SDR SWAA101542Shear Tie · corrodedDURING SCHEDULED 22Y CHECK, FOUND SHEAR TIE CORRODED AT BS 312, BETWEEN STR 28L TO STR 28R. REPAIRED SHEAR TIE PER AEM EO.SDR SWAA101541Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 500C, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER AEM EO.SDR SWAA101540Girt Bar · damagedDURING SCHEDULED 22Y CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE GIRT BAR BASE DAMAGED. REMOVED AND REPLACED BASE PER MM.SDR SWAA101539Fitting · corrodedDURING SCHEDULED 22Y CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE GIRT BAR FITTING BASE CORRODED. REMOVED AND REPLACED BASE PER MM.SDR SWAA101538Fitting · corrodedDURING SCHEDULED 22Y CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE GIRT BAR FITTING CORRODED. REMOVED AND REPLACED FITTING PER MM.SDR SWAA101537Lens · damagedDURING SCHEDULED 22Y CHECK, FOUND AFT LAV EEPLS LENS DAMAGED. REMOVED AND REPLACED LENS PER MM.SDR SWAA101480Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 727B, RBL 24.5. REPAIRED BEAM PER AEM EA.SDR SWAA101441Fitting · corrodedDURING SCHEDULED 22Y CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE GIRT BAR FITTING CORRODED. REPAIRED FITTING PER MM.SDR SWAA101440Fitting · corrodedDURING SCHEDULED 22Y CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE GIRT BAR FITTING CORRODED. REPAIRED FITTING PER MM.SDR SWAA101439Light · inoperativeDURING SCHEDULED 22Y CHECK, FOUND EMERGENCY EXIT LIGHT BULB INOP AT FWD GALLEY. REMOVED AND REPLACED BULB PER MM.SDR SWAA101438Light · inoperativeDURING SCHEDULED 22Y CHECK, FOUND EMERGENCY EXIT LIGHT BULB INOP. REMOVED AND REPLACED BULB PER MM.SDR SWAA101416Light · inoperativeDURING SCHEDULED 22Y CHECK, FOUND AFT GALLEY EMERGENCY EXIT LIGHT BULB INOP. REMOVED AND REPLACED BULB PER MM.SDR SWAA101395Support Bracket · crackedDURING SCHEDULED 22Y CHECK, FOUND SUPPORT BRACKET CRACKED AT BS 294.5, STR 23L. REMOVED AND REPLACED BRACKET PER SRM.SDR SWAA101388Web · crackedDURING SCHEDULED 22Y CHECK, FOUND WEB CRACKED AT BS 295.5, STR 8L. REMOVED AND REPLACED WEB PER SRM.SDR SWAA101386Angle · corrodedDURING SCHEDULED 22Y CHECK, FOUND ZEE ANGLE CORRODED AT BS 297.5, STR 17R. REPAIRED ZEE ANGLE PER SRM.SDR SWAA101385Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA101384Web · crackedDURING SCHEDULED 22Y CHECK, FOUND R1 DOOR CUTOUT WEB CRACKED AT BS 297.5, STR 17R. REMOVED AND REPLACED WEB PER SRM.SDR SWAA101383Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND RT WING NR 4 SLAT SKIN LOWER SURFACE CRACKED. REPAIRED SKIN PER SRM.SDR SWAA101382Flap · delaminatedDURING SCHEDULED 22Y CHECK, FOUND LT WING FORE FLAP T/E DELAMINATED BETWEEN WBL 117 TO WBL 122. REPAIRED FORE FLAP PER SRM.SDR SWAA101381Tab · delaminatedDURING SCHEDULED 22Y CHECK, FOUND LT WING AILERON TAB O/B CORNER DELAMINATED. REPAIRED TAB PER SRM.SDR SWAA101380Floorbeam · corrodedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM CORRODED AT BS 967, RBL 48. REPAIRED BEAM PER SRM.SDR SWAA101318Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 321, STR 20L. REPAIRED FRAME PER SRM.SDR SWAA101223Fitting · crackedDURING SCHEDULED 22Y CHECK, FOUND FITTING CRACKED AT BS 294.5, STR 8R. REMOVED AND REPLACED FITTING PER SRM.SDR SWAA101222Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 344, STR 16R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA101221Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 277, STR 10R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA101220Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 294.5, STR 21L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA101219Angle · corrodedDURING SCHEDULED 22Y CHECK, FOUND SUPPORT ZEE ANGLE CORRODED BETWEEN BS 967 TO BS 986.5, LBL 50. REMOVED AND REPLACED SUPPORT ZEE ANGLE PER SRM.SDR SWAA101203Angle · crackedDURING SCHEDULED 22Y CHECK, FOUND ANGLE CRACKED AT BS 294.5, STR 13L. REMOVED AND REPLACED ANGLE PER SRM.SDR SWAA096520Skin · crackedDURING SCHEDULED 2HC1 CHECK, FOUND SKIN CRACKED AT BS 864, STR 3L. REPAIRED SKIN PER EA.SDR SWAA094764Gasper Fan · faultyFLIGHT ATTENDANT ADVISED MODERATE ACRID SMELL (HYD) IN CABIN. ODOR DISSIPATED AS FLIGHT CONTINUED. REMOVED AND REPLACED GASPER FAN PER MM.SDR SWAA094374Light · missingDURING SCHEDULED CV CHECK, FOUND L1 DOOR EMERGENCY EXIT LIGHT LENS MISSING. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA092148Lens · crazedDURING SCHEDULED HC2 CHECK, FOUND LT OVERWING EXTERIOR EMERGENCY EXIT LIGHT LENS CRAZED. REMOVED AND REPLACED LENS PER MM.SDR SWAA092147Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 259, STR 24L. REPAIRED SKIN PER SRM.SDR SWAA092146Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND FUSELAGE SKIN CRACKED AT R2 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER SWA EA.SDR SWAA091959Battery · dischargedFWD F/A FLASHLIGHT INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA091253Terminal · looseL1 COCKPIT WINDOW ARCED. TIGHTENED L1 COCKPIT WINDOW HEAT HARNESS TERMNAL PER MM.SDR SWAA085553Light · looseFOUND EMERGENCY EXIT FLOOR LIGHT STRIP LOOSE AT ROW 8 ABC. SECURED STRIP PER MM.SDR SWAA084309Fuse · inoperativeDURING SCHEDULED SPV CHECK, FOUND L1 DOOR EMERGENCY EXIT EXTERIOR LIGHT INOP. REMOVED AND REPLACED FUSE PER MM.SDR SWAA083863Battery Pack · dischargedDURING SCHEDULED MV1 CHECK, AFT LT CABIN EMERGENCY EXIT LIGHT INOP. R&R BATTERY PACK PER MM.SDR SWAA082268Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND L2 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA082269Battery · dischargedDURING SCHEDULED MV2 CHECK, FOUND R2 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA082146Lens · dislodgedRIGHT OVERWING EMERGENCY EXIT LIGHT LENS FELL OFF. INSTALLED LIGHT LENS PER MM.SDR SWAA081331Stiffener · crackedDURING SCHEDULED 20Y CHECK, FOUND LT WING AFT SPAR UPPER CHORD INBOARD STIFFENER CRACKED. REPAIRED STIFFENER PER ER.SDR SWAA081324Bulkhead · crackedDURING SCHEDULED 20Y CHECK, FOUND AFT PRESSURE BULKHEAD WEB CRACKED AT BS 1016, STR 6R. REPAIRED WEB PER ER.
Back to N690SW, cancelled Jan 28, 2013