N620SW, cancelled Nov 15, 2018
Service difficulty reports · 407
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 = 'N620SW' AND deregistration_id = 'N620SW-2018-11-15' 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 = 'N620SW' AND deregistration_id = 'N620SW-2018-11-15' 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 SWAA117550Crease Beam · corrodedDURING SCHEDULED SPV CHECK, FOUND R1 DOOR CREASE BEAM CORRODED BETWEEN BS 293 TO BS 321, STR 17R. REPAIRED BEAM IAW SRM.SDR SWAA117502Crease Beam · corrodedDURING SCHEDULED 16Y CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 500B+17, STR 17R. REPAIRED WEB IAW SRM AND DWG.SDR SWAA117501Stiffener · corrodedDURING SCHEDULED 16Y CHECK, FOUND CREASE BEAM "L" CHANNEL STIFFENER CORRODED AT BS 380+14, STR 17R. STIFFENER REPAIRED IAW SRM AND DWG.SDR SWAA117494Crease Beam · corrodedDURING SCHEDULED 16Y CHECK, FOUND LT CREASE BEAM WEB CORRODED AT BS 500+12, STR 17L. REPAIRED WEB IAW SRM AND DWG.SDR SWAA117474Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 500C, BETWEEN STR 26L TO STR 26R. REPAIRED FRAME IAW SRM.SDR SWAA117433Support · corrodedDURING SCHEDULED 16Y CHECK, FOUND AFT CARGO COMPARTMENT SUPPORT CORRODED AT BS 773, RBL 8. REPAIRED SUPPORT IAW SRM.SDR SWAA117432Support · corrodedDURING SCHEDULED 16Y CHECK, FOUND AFT CARGO COMPARTMENT SUPPORT CORRODED AT BS 773, LBL 3. REPAIRED SUPPORT IAW SRM.SDR SWAA117324Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 947.5, STR 25R. REMOVED AND REPLACED CLIP PER SRM AND DWG.SDR SWAA117323Stringer · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CRACKED AT BS 380, STR 5L. REPAIRED STRINGER IAW SRM.SDR SWAA117285Crease Beam · corrodedDURING SCHEDULED 16Y CHECK, FOUND FLOOR CREASE BEAM CORRODED BETWEEN BS 907+2 TO BS 1006, STR 17R. REPAIRED BEAM IAW SRM AND DWG.SDR SWAA117284Floorbeam · corrodedDURING SCHEDULED 16Y CHECK, FOUND FLOORBEAM CORRODED AT BS 947, LBL 5. REPAIRED BEAM IAW SRM.SDR SWAA117283Bracket · corrodedDURING SCHEDULED 16Y CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR FITTING BRACKET CORRODED. REMOVED AND REPLACED BRACKET IAW SRM AND DWG.SDR SWAA117282Bracket · corrodedDURING SCHEDULED 16Y CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR FITTING BRACKET CORRODED. REMOVED AND REPLACED BRACKET IAW SRM AND DWG.SDR SWAA117281Floorbeam · crackedDURING SCHEDULED 16Y CHECK, FOUND LONGITUDINAL FLOORBEAM ANGLE CRACKED AT BS 727B, RBL 45.5. REMOVED AND REPLACED ANGLE IAW SRM AND DWG.SDR SWAA117230Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 380, STR 26L. REMOVED AND REPLACED CLIP PER SRM AND DWG.SDR SWAA117205Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 380, STR 8L. REMOVED AND REPLACED STRINGER CLIP IAW SRM AND DWG.SDR SWAA116721Skin · crackedDURING SCHEDULED RON CHECK, FOUND SKIN CRACKED AT BS 727E+7, STR 4R. REPAIRED SKIN IAW EA.SDR SWAA116112Channel · corrodedDURING SCHEDULED 16Y CHECK, FOUND AFT CARGO COMPARTMENT CHANNEL CORRODED AT BS 772, LBL 12.50. REPAIRED CHANNEL IAW EA.SDR SWAA114855Actuator · malfunctionedAIR TURNBACK - NR 4 FLAP EXTENSION AFTER TAKEOFF AND FLAP RETRACTION. REMOVED AND REPLACED NR 4 L/E FLAP ACTUATOR PER MM.SDR SWAA114437Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND SKIN CRACKED AT BS 727C+7, STR 4R. REPAIRED SKIN PER EA.SDR SWAA114550Skin · crackedDURING SCHEDULED RON CHECK, FOUND SKIN CRACKED AT BS 727C+13, STR 4R. REPAIRED SKIN PER SRM.SDR SWAA113561Skin · crackedDURING SCHEDULED OTS CHECK FOUND, L2 DOOR FUSELAGE SKIN CRACKED AT UPPER AFT CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA106711Lens · looseRT OVERHEAD BULLNOSE EMERGENCY EXIT LIGHT LENS LOOSE. SECURED LENS ASSY PER MM.SDR SWAA106064Light · inoperativeDURING SCHEDULED OTS CHECK, FOUND LT OVERHEAD EMERGENCY EXIT BULLNOSE LIGHT INOP. REPAIRED LIGHT PER MM.SDR SWAA106063Pressure Panel · crackedDURING SCHEDULED OTS CHECK, FOUND LT MLG WHEEL WELL PRESSURE DECK WEB CRACKED AT BS 675, LBL 30. REPAIRED WEB PER SRM.SDR SWAA105988Charger · inoperativeDURING SCHEDULED OTS CHECK, FOUND LT EEPLS INOP AT ROW 10. REMOVED AND REPLACED BATTERY CHARGER ASSY PER MM.SDR SWAA106146Skin · corrodedL1 DOOR AFT UPPER CORNER SKIN CORRODED. REPAIRED DOOR PER ER AND EA.SDR SWAA105955Light · looseDURING SCHEDULED HC1 CHECK, FOUND MID CABIN OVERHEAD EMERGENCY EXIT LIGHT LOOSE. SECURED LIGHT PER MM.SDR SWAA104917Slide · out of positionR1 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MT.SDR SWAA104672Valve · defectiveCHEMICAL/HEAT SMELL ON ROTATION, WENT COLD ON PACKS. FOUND LT PACK VALVE STUCK IN ON POSITION. REMOVED AND REPLACED LT PACK VALVE PER MM.SDR SWAA101819Slat · delaminatedDURING SCHEDULED 2HC2 CHECK, FOUND RT WING NR 4 SLAT INBOARD UPPER CORNER DELAMINATED. REMOVED AND REPLACED SLAT PER MM.SDR SWAA101665Lens · damagedDURING SCHEDULED MV4 CHECK, FOUND LT OVERWING EMERGENCY EXIT LIGHT LENS DAMAGED. REMOVED AND REPLACED LENS PER MM.SDR SWAA100031Proximity Sensor · faultyDURING APPROACH TO LANDING, THE RIGHT MAIN LANDING GEAR INDICATOR LIGHT WOULD CYCLE FROM GREEN TO RED. IT DID THIS ABOUT THREE TIMES. RAN THE QRH CHECK LIST. REMOVED AND REPLACED RT MLG DOWN AND LOCK PROX SENSOR PER MM.SDR SWAA097702Flap · delaminatedDURING SCHEDULED 14Y CHECK, FOUND RT WING O/B AFT FLAP DELAMINATED. REMOVED AND REPLACED AFT FLAP PER MM.SDR SWAA097612Rib · crackedDURING SCHEDULED 14Y CHECK, FOUND LT WING RIB LOWER CHORD CRACKED AT WBL 135.5, BETWEEN STR S2 TO STR S3. REPAIRED RIB PER ACO.SDR SWAA097611Skin · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 286, STR 12R. REPAIRED SKIN PER EA.SDR SWAA097610Skin · crackedDURING SCHEDULED 14Y CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER EA.SDR SWAA097609Stringer Clip · crackedDURING SCHEDULED 14Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 277, STR 15R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA097592Skin · crackedDURING SCHEDULED 14Y CHECK, FOUND SKIN CRACKED BETWEEN BS 290 TO BS 291, BETWEEN WL 233.5 TO WL 234.5. REPAIRED SKIN PER EA.SDR SWAA097511Stringer Clip · crackedDURING SCHEDULED 14Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 639, STR 3R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA097362Stringer Clip · crackedDURING SCHEDULED 14Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 663.75, STR 10R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA097361Stringer Clip · crackedDURING SCHEDULED 14Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 663.75, STR 10L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA097350Stringer Clip · crackedDURING SCHEDULED 14Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 747, STR 6R. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA097349Stringer Clip · crackedDURING SCHEDULED 14Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, STR 5R. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA097348Stringer Clip · crackedDURING SCHEDULED 14Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, STR 6R. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA097326Stringer Clip · crackedDURING SCHEDULED 14Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500A, STR 9R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA097325Stringer Clip · crackedDURING SCHEDULED 14Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, STR 3R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA097324Stringer Clip · crackedDURING SCHEDULED 14Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 400, STR 8R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA095929Skin · crackedDURING SCHEDULED 2HC1 CHECK, FOUND SKIN CRACKED AT BS 1004, STR 5R. REPAIRED SKIN PER SWA EA.SDR SWAA096127Bracket · crackedDURING SCHEDULED 2HC1 CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE BRACKET CRACKED. REMOVED AND REPLACED BRACKET PER MM.
Back to N620SW, cancelled Nov 15, 2018