N504SW, cancelled Oct 27, 2017
Service difficulty reports · 277
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 = 'N504SW' AND deregistration_id = 'N504SW-2017-10-27' 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 = 'N504SW' AND deregistration_id = 'N504SW-2017-10-27' 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 SWAA2012100108105Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 962 TO BS 964, STR 21L. REPAIRED SKIN IAW EA.SDR SWAA2012100108104Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 882 TO BS 854.5, STR 16L. REPAIRED SKIN IAW EA.SDR SWAA2012092608028Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 882 TO BS 883, STR 15L. REPAIRED SKIN IAW EA.SDR SWAA2012080706564Frame · crackedFRAME CRACKED AT BS 380, STR 15R. REPAIRED FRAME IAW EA.SDR SWAA2012080706493Skin · crackedSKIN CRACKED AT BS 460 + 6, STR 17R. REPAIRED SKIN IAW SRM.SDR SWAA2012080706492Skin · crackedSKIN CRACKED AT BS 440 + 10, STR 16R. REPAIRED SKIN IAW SRM.SDR SWAA2012052304266Seal · out of positionAIR TURNBACK - CABIN ALT WARNING HORN DURING CLIMBOUT. REMOVED AND REPLACED SEAL PER MM.SDR SWAA117476Skin · crackedDURING SCHEDULED CV CHECK, FOUND SKIN CRACKED AT BS 380+12, STR 16R. REPAIRED SKIN IAW EA.SDR SWAA115474Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 924, STR 24L. REPAIRED SKIN PER SRM.SDR SWAA115446Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 907+17, STR 24L. REPAIRED SKIN PER SRM.SDR SWAA115445Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 924, STR 24L. REPAIRED SKIN PER SRM.SDR SWAA114936Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE BEAR STRAP SKIN CRACKED BETWEEN BS 767 TO BS 847, BETWEEN STR 25R TO STR 26R. REPAIRED SKIN PER SRM.SDR SWAA114935Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE BEAR STRAP SKIN CRACKED AT BS 867, STR 25R. REPAIRED SKIN PER SRM.SDR SWAA114934Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE BEAR STRAP SKIN CRACKED AT BS 847, BETWEEN STR 26R TO STR 27R. REPAIRED SKIN PER SRM.SDR SWAA114899Bear Strap · crackedDURING SCHEDULED 22Y CHECK, FOUND RT AFT CARGO COMPARTMENT BEAR STRAP CORRODED AT BS 787, STR 26R. REPAIRED SKIN IAW EA.SDR SWAA114862Structure · corrodedDURING SCHEDULED 22Y CHECK, FOUND AFT CARGO COMPARTMENT CHORD CORRODED AT BS 727, BETWEEN STR 27L TO STR 27R. REPAIRED CHORD PER SRM.SDR SWAA114863Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND SKIN CRACKED AT BS 747+17, STR 24L. REPAIRED SKIN PER EA.SDR SWAA114864Bulkhead · corrodedDURING SCHEDULED 22Y CHECK, FOUND AFT PRESSURE BULKHEAD CORRODED AT BS 1016, BETWEEN BL 0 TO RBL 8. REPAIRED BULKHEAD PER EA, SRM, DWG, AND ACO.SDR SWAA114865Bulkhead · crackedDURING SCHEDULE 22Y CHECK, FOUND AFT PRESSURE BULKHEAD DOME CAP CRACKED AT 6 O'CLOCK POSITION. REPAIRED DOME CAP PER EA.SDR SWAA114866Stiffener · corrodedDURING SCHEDULED 22Y CHECK, FOUND AFT BULKHEAD LOWER STIFFENER CHORD CORRODED AT BS 1016, RBL 1. REPAIRED CHORD PER SRM, ACO, AND DWG.SDR SWAA114841Slide · out of positionDURING SCHEDULED 22Y CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW MT.SDR SWAA114840Light · brokenDURING SCHEDULED 22Y CHECK, FOUND FWD LAVATORY AFT WALL EMERGENCY EXIT LIGHT BROKEN. REMOVED AND REPLACED LIGHT PER MM.SDR SWAA114775Fitting · corrodedDURING SCHEDULED 22Y CHECK, FOUND RT HORIZONTAL STABILIZER HINGE HOUSING FITTING ATTACH LUGS CORRODED. REPAIRED LUGS IAW EA.SDR SWAA114774Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE SKIN CRACKED AT L2 DOOR FORWARD LOWER CORNER CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA114733Shear Tie · crackedDURING SCHEDULED 22Y CHECK, FOUND SHEAR TIE CRACKED AT BS 277, BETWEEN STR 10 TO STR 11L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA114703Skin · crackedDURING SCHEUDLED 22Y CHECK, FOUND SKIN CRACKED AT BS 492, STR 16L. REPAIRED SKIN PER EA AND ER.SDR SWAA114614Frame · crackedDURING SCHEDULED 22Y CHECK FOUND, R1 DOOR CUTOUT FWD FRAME CRACKED AT BS 294.5+6, BETWEEN STR 17R TO STR 16R. REPAIRED FRAME IAW SRM.SDR SWAA114613Shear Tie · crackedDURING SCHEDULED 22Y CHECK FOUND, SHEAR TIE CRACKED AT BS 277, BETWEEN STR 9L TO STR 10L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA114516Mount Bracket · crackedDURING SCHEDULED 22Y CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE AFT MOUTING BRACKET CRACKED. REMOVED AND REPLACED BRACKET IAW SRM AND DWG.SDR SWAA114377Web · crackedDURING SCHEDULED 22Y CHECK, FOUND E&E COMPARTMENT DOOR CUTOUT, RT WEB CRACKED AT BS 351, RBL 15. REPAIRED WEB PER SRM.SDR SWAA114376Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND SKIN CRACKED AT BS 440+15, STR 17L. REPAIRED SKIN PER EA.SDR SWAA114351Crease Beam · corrodedDURING SCHEDULED 22Y CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 482A, STR 17L. REMOVED AND REPLACED WEB IAW BAC DWG.SDR SWAA114301Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND SKIN CRACKED AT BS 843, STR 16L. REPAIRED SKIN PER EA.SDR SWAA114324Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 727B, RBL 24.8. REPAIRED CHORD PER EA.SDR SWAA114323Floorbeam · corrodedDURING SCHEDULED 22Y CHECK, FOUND T-CAP CORRODED AT BS 986, BETWEEN LBL 5 TO RBL 14. REPAIRED T-CAP PER SRM.SDR SWAA114282Floorbeam · corrodedDURING SCHEDULED 22Y CHECK, FOUND T-CAP CORRODED AT BS 986, RBL 14. REPAIRED T-CAP PER SRM.SDR SWAA114281Floorbeam · corrodedDURING SCHEDULED 22Y CHECK, FOUND T-CAP CORRODED AT BS 986, RBL 5. REPAIRED T-CAP PER SRM.SDR SWAA114280Floorbeam · corrodedDURING SCHEDULED 22Y CHECK, FOUND T-CAP CORRODED AT BS 986, LBL 5. REPAIRED T-CAP PER SRM.SDR SWAA114125Skin · delaminatedDURING SCHEDULED 22Y CHECK, FOUND RT WING O/B AFT FLAP T/E DELAMINATED. REMOVED AND REPLACED SKIN PER MM.SDR SWAA113984Shear Tie · crackedDURING SCHEDULED 22Y CHECK FOUND, SHEAR TIE CRACKED AT BS 294.5, STR 12L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA113911Stiffener · crackedDURING SCHEDULED 22Y CHECK FOUND, BULKHEAD STIFFENER ATTACH BRACKET CRACKED AT BS 728, RBL 18. REMOVED AND REPLACED T-ANGLE PER SRM.SDR SWAA113873Frame · corrodedDURING SCHEDULED 22Y CHECK, FOUND FRAME CORRODED AT BS 787, BETWEEN STR 27L TO STR 27R. REPAIRED FRAME PER SRM. REPAIRED FRAME PER SRM.SDR SWAA113811Crease Beam · crackedDURING SCHEDULED 12Y CHECK FOUND, CREASE BEAM CHORD CRACKED BETWEEN BS 663+10 TO BS 727+4, STR 17L. REMOVED AND REPLACED BEAM PER SRM.SDR SWAA113810Crease Beam · crackedDURING SCHEDULED 12Y CHECK FOUND, CREASE BEAM CRACKED BETWEEN BS 616 TO BS 639, STR 17R. REMOVED AND REPLACED BEAM PER SRM.SDR SWAA113746Stringer Clip · crackedDURING SCHEDULED 12Y CHECK FOUND, STRINGER CLIP CRACKED AT BS 787, STR 23L. REMOVED AND REPLACED CLIP PER DWG.SDR SWAA113745Stringer Clip · crackedDURING SCHEDULED 12Y CHECK FOUND, STRINGER CLIP CRACKED AT BS 787, STR 24L. REMOVED AND REPLACED CLIP PER DWG.SDR SWAA113605Attach Angle · corrodedDURING SCHEDULED 22Y CHECK FOUND, R2 DOOR STA 965 TO STA 992 CREASE BEAM ATTACHED ANGLE CORRODED. REPAIRED CHORD PER SRM.SDR SWAA113542Skin · crackedDURING SCHEDULED 22Y CHECK FOUND, FWD CARGO DOOR EXTERIOR SKIN CRACKED AT LOWER FWD CORNER, AT EDGE OF SKIN. REPAIRED SKIN PER SRM.SDR SWAA113541Stringer Clip · crackedDURING SCHEDULED 22Y CHECK FOUND, STRINGER CLIP CRACKED AT BS 277, STR 10L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA113540Stringer Clip · crackedDURING SCHEDULED 22Y CHECK FOUND, STRINGER CLIP CRACKED AT BS 706, STR 11R. REMOVED AND REPLACED CLIP PER SRM.
Back to N504SW, cancelled Oct 27, 2017