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 SWAA2012031602263Skin · crackedFUSELAGE SKIN CRACKED AT BS 727E+15, STR 2R. REPAIRED SKIN PER SRM & EA.SDR SWAA2012031502217Beam · crackedLT STUB BEAM CRACKED AT STA 616. REMOVED AND REPLACED STUB BEAM PER EA.SDR SWAA2012022901819Fastener · crackedCREASE BEAM FASTENER CRACKED AT BS 616, STR 17R. REMOVED AND REPLACED FASTENER IAW SRM.SDR SWAA2012030601970Structure · crackedLT SIDE INNER CHORD CRACKED AT BS 616. REPAIRED CHORD PER EA.SDR SWAA2012030501898Fitting · crackedLT STUB BEAM ATTACHMENT CLIP CRACKED AT BS 639, LBL 45.5. REMOVED AND REPLACED CLIP IAW AND BAC DWG.SDR SWAA2012022901818Attach Fitting · crackedRT STUB BEAM ATTACHMENT CLIP CRACKED AT BS 639 RBL 45.5. REMOVED AND REPLACED CLIP IAW BAC DWG.SDR SWAA118700Skin · crackedDURING SCHEDULED RON CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 727E+6, STR 4R. REPAIRED SKIN PER EA & SRM.SDR SWAA118701Skin · crackedDURING SCHEDULED RON CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 807 TO BS 827, STR 4R. REPAIRED SKIN PER EA & SRM.SDR SWAA116926Lens · looseRT OVERHEAD EMERGENCY EXIT BULLNOSE LIGHT LENS LOOSE AT ROW 9. REMOVED AND REPLACED LENS IAW MM.SDR SWAA113263Skin · crackedDURING SCHEDULED 2HC1 CHECK FOUND, FUSELAGE SKIN CRACK FORWARD FROM AFT SERVICE DOOR LOWER HINGE CUTOUT AND BELOW FUSELAGE SCALLOP. REPAIRED PER DOC.SDR SWAA113264Slide · looseDURING SCHEDULED 2HC1 CHECK FOUND, FWD ENTRY DOOR SLIDE GIRT OUTPLAY IS EXCESSIVE. ADJUSTED FWD ENTRY DOOR SLIDE GIRT PER AMM.SDR SWAA112429Light · inoperativeDURING SCHEDULED MV1 CHECK, FOUND LT WING EXTERIOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LAMP PER MM.SDR SWAA110790Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED BETWEEN BS 845 TO BS 847, STR 1L. REPAIRED SKIN PER EA.SDR SWAA110789Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 735A, STR 4R. REPAIRED SKIN PER EA.SDR SWAA110788Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 527, STR 10R. REPAIRED SKIN PER ER AND EA.SDR SWAA110703Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED BETWEEN BS 845 TO BS 847, STR 1L. REPAIRED SKIN PER SRM.SDR SWAA110702Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 727A, STR 4R. REPAIRED SKIN PER SRM.SDR SWAA110701Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 527, STR 10R. REPAIRED SKIN PER SRM.SDR SWAA107189Stringer · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CRACKED AT BS 663.75, STR 16R. REPAIRED STRINGER PER EA.SDR SWAA107188Frame · damagedDURING SCHEDULED 16Y CHECK, FOUND RT FRAME WEB DAMAGED AT BS 235.8, WL 226. REPAIRED WEB PER EA.SDR SWAA107163Floorbeam · corrodedDURING SCHEDULED 16Y CHECK, FOUND FLOORBEAM CORRODED AT BS 986.5. REPAIRED BEAM PER EA.SDR SWAA107162Floorbeam · crackedDURING SCHEDULED 16Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 727B, LBL 24. REMOVED AND REPLACED BEAM PER EA.SDR SWAA107161Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 663.75, STR 10R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA107160Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 294.5, STR 13L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA107159Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 5L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA107158Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 8L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA107157Floorbeam · crackedDURING SCHEDULED 16Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 727B-3, LBL 24. REPAIRED BEAM PER EA.SDR SWAA107156Floorbeam · crackedDURING SCHEDULED 16Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 668, LBL 24.5. REPAIRED BEAM PER EA.SDR SWAA107086Floorbeam · crackedDURING SCHEDULED 16Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 727B, LBL 45. REPAIRED CHORD PER EA.SDR SWAA107085Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP DAMAGED AT BS 787, STR 9L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA107084Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 827, STR 16R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA107051Angle · crackedDURING SCHEDULED 16Y CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE CRACKED BETWEEN GIRT BAR SUPPORT ANGLE. REPAIRED ANGLE PER SRM.SDR SWAA106974Floorbeam · crackedDURING SCHEDULED 16Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 727B, RBL 24. REPAIRED BEAM PER EA.SDR SWAA106973Floorbeam · crackedDURING SCHEDULED 16Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 727B, RBL 45. REPAIRED BEAM PER EA.SDR SWAA106910Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 500B, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER SRM.SDR SWAA104503Circuit Card · faultyAFTER RAISING GEAR ON TAKE OFF, RED "RIGHT" AND GREEN "RIGHT GEAR" LIGHTS WERE ON. LOWERED GEAR AND GEAR INDICATED ALL DOWN WITH THREE GREEN LIGHTS. REMOVED AND REPLACED M986 CIRCUIT CARD PER MM.SDR SWAA101216Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 510A, STR 8L. REPAIRED SKIN PER EA.SDR SWAA2012050803757Skin · crackedFUSELAGE SKIN CRACKED AT BS 500A+10, STR 8L. REMOVED AND REPLACED SKIN PER SRM.SDR SWAA100762Keelbeam · crackedDURING SCHEDULED HC1 CHECK, FOUND MAIN WHEEL WELL KEEL BEAM LOWER SKIN CRACKED BETWEEN BS 660 TO BS 724. REPAIRED BEAM PER EA.SDR SWAA100646Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED ON KEEL BEAM MAIN WHEEL WELL BETWEEN BS 698 TO BS 715. REPAIRED SKIN PER SRM.SDR SWAA097944Light · inoperativeDURING SCHEDULED MV3 CHECK, FOUND RT AFT LOWER EMERGENCY EXIT LIGHT INOP. RELAMPED PER MM.SDR SWAA2012050903847Skin · crackedSKIN CRACKED AT BS 836, STR 3L. REMOVED AND REPLACED SKIN PER SRM.SDR SWAA2012050903846Skin · crackedSKIN CRACKED AT BS 836, STR 3L. REPAIRED SKIN PER EA.SDR SWAA094899Skin · crackedDURING SCHEDULED 2HC2 CHECK, FOUND SKIN CRACKED AT BS 836, STR 3L. REPAIRED SKIN PER SWA EA.SDR SWAA094898Skin · delaminatedDURING SCHEDULED 2HC2 CHECK, FOUND LT WING O/B AFT FLAP LOWER SURFACE DELAMINATED. REMOVED AND REPLACED AFT FLAP PER MM.SDR SWAA094897Wedge · delaminatedDURING SCHEDULED 2HC2 CHECK, FOUND RT WING NR 5 SLAT T/E WEDGE DELAMINATED. REMOVED AND REPLACED SLAT PER MM.SDR SWAA094896Girt Bar · looseDURING SCHEDULED 2HC2 CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE GIRT BAR LOOSE. SECURED GIRT BAR PER MM.SDR SWAA094895Girt Bar · looseDURING SCHEDULED 2HC2 CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE GIRT BAR LOOSE. SECURED GIRT BAR PER MM.SDR SWAA093324Slide · out of positionL1 DOOR EMERGENCY EVAC SLIDE FELL OUT OF CASE, DID NOT DEPLOY. SECURED SLIDE PER MT.SDR SWAA092201Window · arcedR1 COCKPIT WINDOW ARCED. REMOVED AND REPLACED WINDOW PER MM.
Back to N604SW, cancelled Aug 5, 2019