N604SW, cancelled Aug 5, 2019
Service difficulty reports · 304
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 = 'N604SW' AND deregistration_id = 'N604SW-2019-08-05' 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 = 'N604SW' AND deregistration_id = 'N604SW-2019-08-05' 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 SWAA2014011424106Frame · crackedFRAME CRACKED AT BS 348.2 BETWEEN STRINGER 13L TO STRINGER 7L. REPAIRED FRAME IAW EA.SDR SWAA2014011324071Intercostal · crackedINTERCOSTAL CRACKED AT BS 348 STRINGER 16L. REPAIRED INTERCOSTAL IAW EA.SDR SWAA2014011324070Frame · crackedFRAME CRACKED AT BS 348.2 BETWEEN STRINGER 13L TO STRINGER 17L. REPAIRED FRAME IAW SWA EA.SDR SWAA2013120322900Cover · looseFWD ENTRY EMERGENCY EXIT COVER LOOSE. SECURED COVER IAW SIP.SDR SWAA2013090919980Mount Bracket · crackedR2 DOOR EMERGENCY EVAC SLIDE FWD MOUNT BRACKET CRACKED. R&R BRACKET IAW AMM.SDR SWAA2013070117815Doubler · crackedAFT CARGO DOOR CUTOUT LOWER AFT CORNER DOUBLER CRACKED. REPAIRED DOUBLER IAW EA.SDR SWAA2013020712415Lens · looseEMERGENCY LIGHT LENS NOT SECURED IN BULLNOSE 19 D. ADJUSTED PER MM.SDR SWAA2013020712358Slide · out of positionR2 DOOR SLIDE PRESSURE GAUGE NOT VISABLE IN WINDOW. REPOSITIONED GAUGE PER MM.SDR SWAA2012103008968Light · inoperativeL1 DOOR EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT PER MM.SDR SWAA2012101808616Sign · brokenL1 DOOR EMERGENCY EXIT SIGN BROKEN. REMOVED AND REPLACED SIGN PER M/M.SDR SWAA2012091907782Floorbeam · crackedLONGITUDINAL FLOORBEAM CRACKED AT BS 713, BL 0. REPAIRED WEB PER SI & EA.SDR SWAA2012091907781Floorbeam · crackedLONGITUDINAL FLOORBEAM CRACKED AT BS 708, BL 0. REPAIRED WEB PER SI & EA.SDR SWAA2012091907780Floorbeam · crackedLONGITUDINAL FLOORBEAM CRACKED AT BS 709, BL 0. REPAIRED WEB PER SI & EA.SDR SWAA2012091907779Shear Tie · corrodedSHEAR TIE CORRODED AT BS 500C, BETWEEN STR 28LTO STR 27L. REPAIRED SHEAR TIE PER SRM.SDR SWAA2012092007816Shear Tie · crackedSHEAR TIE CORRODED AT BS 500C, BETWEEN STR 28R TO STR 28L. REPAIRED SHEAR TIE PER SRM.SDR SWAA2012092007815Gusset · crackedLONGITUDINAL FLOORBEAM UPPER CHORD LOWER SURFACE ATTACH STRAP CRACKED AT BS 727A+17, RBL 24.8. REMOVED AND REPLACED GUSSET PER SRM.SDR SWAA2012092007814Gusset · crackedLONGITUDINAL FLOORBEAM UPPER CHORD LOWER SURFACE ATTACH STRAP CRACKED AT BS 727A+18, RBL 24.8. REMOVED AND REPLACED GUSSET PER SRM.SDR SWAA2012092007813Gusset · crackedLONGITUDINAL FLOORBEAM UPPER CHORD LOWER SURFACE ATTACH STRAP CRACKED AT BS 727A+18, LBL 45.5. REMOVED AND REPLACED GUSSET PER SRM.SDR SWAA2012092507979Floorbeam · crackedLONGITUDINAL FLOORBEAM CRACKED AT BS 714, RBL 24.8. REPAIRED BEAM IAW EA.SDR SWAA2012092507978Floorbeam · crackedLONGITUDINAL FLOORBEAM CRACKED AT BS 710, LBL 24.8. REPAIRED BEAM IAW EA.SDR SWAA2012092507977Floorbeam · crackedLONGITUDINAL FLOORBEAM CRACKED AT BS 709, LBL 24.8. REPAIRED BEAM IAW EA.SDR SWAA2012092107844Gusset · crackedCENTER FUEL TANK FRONT SPAR GUSSET CRACKED AT AFT END, LBL 53.75. REMOVED AND REPLACED GUSSET PER SRM.SDR SWAA2012091907741Floorbeam · crackedLONGITUDINAL FLOORBEAM WEB CRACKED AT BS 707, LBL 24.8. REPAIRED WEB IAW SRM.SDR SWAA2012091907740Frame · corrodedFRAME CORRODED AT BS 500B, BETWEEN STR 28L TO STR 27L. REPAIRED FRAME IAW SRM.SDR SWAA2012091907739Frame · corrodedFRAME CORRODED AT BS 500B, BETWEEN STR 27L TO STR 26L. REPAIRED FRAME IAW SRM.SDR SWAA2012091907738Slat · delaminatedLEFT WING NR 2 SLAT O/B TRAILING EDGE DELAMINATED. REPAIRED SLAT PER SRM.SDR SWAA2012072306118Skin · puncturedRIGHT ELEVATOR PUNCTURED ON UPPER SURFACE APPROX 6.5 INCHES FROM TRAILING EDGE AND 41.5 INCHES FROM OUTBD END. REPAIRED ELEVATOR PER SRM.SDR SWAA2012072306069Light · inoperativeL2 DOOR LOWER EMERGENCY LIGHT BULBS INOP. REMOVED AND REPLACED BULBS PER AMM.SDR SWAA2012071605852Cover · missingRIGHT OVERHEAD EMERGENCY EXIT LIGHT COVER MISSING AT ROW 19. INSTALLED COVER IAW AMM.SDR SWAA2012051804129Light · inoperativeRIGHT EMERGENCY LIGHT INOP AT ROW 19. REMOVED AND REPLACED LIGHT IAW AMM.SDR SWAA2012051804128Stringer · crackedSTRINGER CRACKED AT BS 727D, STR 5L. REPAIRED STRINGER IAW EA.SDR SWAA2012050803758Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 400, STR 8L. REMOVED AND REPLACED STRINGER CLIP IAW SRM AND DWG.SDR SWAA2012050303653Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 1006, STR 6L. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA2012050903849Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 967, STR 2R. REMOVED AND REPLACED CLIP IAW SRM & DWG.SDR SWAA2012051403984Lens · crackedOVERHEAD EMERGENCY EXIT LIGHT LENS CRACKED. REMOVED AND REPLACED LENS IAW MM.SDR SWAA2012050903848Shear Tie · crackedSHEAR TIE CRACKED AT BS 947.5, BETWEEN STR 5L AND STR 6L. REMOVED AND REPLACED SHEAR TIE PER SRM AND DWG.SDR SWAA2012050803768Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 500C+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012050803767Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 440+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012050703736Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 807+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012050703735Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 460+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012050703732Skin · crackedRT FUSELAGE SKIN CRACKED AT BS 380+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW BAC DWG.SDR SWAA2012041703168Slide · out of adjustR2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA2012041203067Light · looseRT EMERGENCY EXIT BULLNOSE LIGHT LENS LOOSE AT ROW 8. SECURED LIGHT PER AMM.SDR SWAA2012031902395Skin · crackedFUSELAGE SKIN CRACKED AT BS 727E+16, STR 1R. REPAIRED SKIN IAW EA.SDR SWAA2012031902394Skin · crackedFUSELAGE SKIN CRACKED AT BS 847+7.5, STR 1L. REPAIRED SKIN IAW EA.SDR SWAA2012031902393Skin · crackedFUSELAGE SKIN CRACKED AT BS 847+1.5,STR 1L. REPAIRED SKIN IAW EA.SDR SWAA2012031902392Skin · crackedFUSELAGE SKIN CRACKED AT BS 847+6, STR 1. REPAIRED SKIN.SDR SWAA2012031902391Skin · crackedFUSELAGE SKIN CRACKED AT BS 827+15, STR 2R. REPAIRED SKIN IAW EA.SDR SWAA2012031902390Skin · crackedFUSELAGE SKIN CRACKED AT BS 727E+16, STR 1. REPAIRED SKIN IAW EA.SDR SWAA2012031602266Skin · crackedFUSELAGE SKIN CRACKED AT BS 787+4, STR 4R. REPAIRED SKIN PER REO & EA.
Back to N604SW, cancelled Aug 5, 2019