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 SWAA2012091207540Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 400+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012091707677Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 867+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012091707676Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 827+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012091407615Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 827+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012091407614Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 867+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012091407613Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 847+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012091307568Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 807+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012091307567Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 787+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012091307566Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 767+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012091307565Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 807+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012091307564Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 787+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012091307563Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 767+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012090707428Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 747+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SRM AND EA.SDR SWAA2012090707427Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 727E+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SRM AND EA.SDR SWAA2012090707426Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 727D+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SRM AND EA.SDR SWAA2012090707425Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 727C+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SRM AND EA.SDR SWAA2012090707424Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 727A+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN PER EA AND SRM.SDR SWAA2012090707423Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 747+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SRM AND EA.SDR SWAA2012090707422Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 727E+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SRM AND EA.SDR SWAA2012090707421Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 727D+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SRM & EA.SDR SWAA2012090707420Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 727A+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW TASK CARD & EA.SDR SWAA2012090507384Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 727+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012090507383Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 767+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012090507382Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 727A+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW TASK CARD AND EA 1.SDR SWAA2012062005106Light · inoperativeRIGHT EEPLS INOP AT ROW 19. RELAMPED EEPLS PER MM.SDR SWAA2012062005104Wedge · delaminatedLEFT WING NR 2 SLAT O/B END UPPER SURFACE TRAILING EDGE WEDGE DELAMINATED. REPAIRED NR 2 SLAT PER MM.SDR SWAA2012062305076Skin · crackedRIGHT WING NR 6 SLAT LOWER SKIN CRACKED. REPAIRED SKIN IAW SRM.SDR SWAA2012061404930Lens · brokenRIGHT OVERHEAD BULLNOSE EMERGENCY EXIT LIGHT LENS BROKEN AT ROW 19. REMOVED AND REPLACED LENS IAW AMM.SDR SWAA2012061104792Lens · out of positionL1 DOOR EMERGENCY EXIT LIGHT LENS CAME OFF DURING FLIGHT. REMOVED AND REPLACED LENS ASSY PER AMM.SDR SWAA2012050403692Slide · out of positionR1 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER M/M AND MT.SDR SWAA2012050403683Lens · damagedR2 DOOR EMERGENCY EXIT SIGN LENS DAMAGED. REMOVED AND REPLACED LENS ASSY PER MM.SDR SWAA2012041703169Cover · missingLT OVERWING EMERGENCY EXIT LENS COVER MISSING. INSTALLED COVER PER MM.SDR SWAA2012032202508Lens · brokenL1 DOOR EMERGENCY EXIT LIGHT LENS BROKEN. REMOVED AND REPLACED LENS PER M/M.SDR SWAA118605Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 727B+10, STR 4R. REMOVED AND REPLACED SKIN PER SRM.SDR SWAA118604Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 867+10, STR 4R. REMOVED AND REPLACED SKIN PER SRM.SDR SWAA118652Skin · crackedDURING SCHEDULED OTS CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 767+11, STR 4R. REPAIRED SKIN PER SRM.SDR SWAA118536Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 867+10, STR 4R. REPAIRED SKIN IAW SRM.SDR SWAA118535Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 767+11, STR 4R. REPAIRED SKIN IAW SRM.SDR SWAA118527Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 727+3, STR 4R. REPAIRED SKIN IAW SRM.SDR SWAA118508Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 727B+10, STR 4R. REPAIRED SKIN IAW SRM.SDR SWAA118741Skin · crackedDURING SCHEDULED OTS CHECK, FOUND FUSELAGE SKIN CRACK BS 727D+3, STR 4R. REPAIRED CRACK PER DOC.SDR SWAA117899Lens · missingDURING SCHEDULED 16Y CHECK, FOUND GALLEY EMERGENCY EXIT SIGN LENS MISSING. REMOVED AND REPLACED LENS ASSY IAW MM.SDR SWAA117821Web · crackedDURING SCHEDULED 16Y CHECK, FOUND LONGITUDINAL WEB CRACKED AT BS 616, LBL 45.5. REPAIRED WEB IAW EA.SDR SWAA117820Attach Fitting · crackedDURING SCHEDULED 16Y CHECK, FOUND STUB BEAM ATTACHMENT CLIP CRACKED AT BS 639, LBL 45.5. REMOVED AND REPLACED CLIP IAW EA.SDR SWAA117799Beam · crackedDURING SCHEDULED 16Y CHECK, FOUND LT STUB BEAM CRACKED AT BS 616. REMOVED AND RREPLACED BEAM IAW EA.SDR SWAA117798Fitting · crackedDURING SCHEDULED 16Y CHECK, FOUND STUB FRAME BEAM ATTACHMENT CLIP CRACKED AT BS 639, RBL 45.5. REMOVED AND REPLACED CLIP IAW SRM.SDR SWAA117630Doubler · corrodedDURING SCHEDULED 16Y CHECK, FOUND AFT FUSELAGE OUTFLOW VALVE OPENING CORRODED ON INNER SUFRACE AFT EDGE. REMOVED AND REPLACED DOUBLER IAW SRM.SDR SWAA117629Skin · delaminatedDURING SCHEDULED 16Y CHECK, FOUND RT WING I/B FORE FLAP UPPER SURFACE DELAMINATED. REPAIRED FORE FLAP IAW SRM.SDR SWAA117610Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME INNER CHORD CRACKED AT BS 616, STR 17L. REPAIRED FRAME IAW EA.SDR SWAA117577Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 380, STR 22L. REMOVED AND REPLACED CLIP IAW SRM AND DWG.
Back to N620SW, cancelled Nov 15, 2018