N511SW, cancelled Jan 2, 2019
Service difficulty reports · 300
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 = 'N511SW' AND deregistration_id = 'N511SW-2019-01-02' 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 = 'N511SW' AND deregistration_id = 'N511SW-2019-01-02' 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 SWAA2012040902877Web · crackedCOCKPIT FLOOR WEB CRACKED AT BS 247, RBL 23. REMOVED AND REPLACED WEB PER ACO.SDR SWAA2012022001585Wire · damagedEMERGENCY EXIT LIGHT ON G-4 GALLEY INOPERATIVE. REMOVED AND REPLACED WIRE IAW SWPM AND AMM.SDR SWAA2012022001584Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 767, STR 22 L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA2012022001583Shear Tie · crackedSHEAR TIE CRACKED AT BS 787, BETWEEN STR 19 TO STR 20L. REMOVED AND REPLACED SHEAR TIE PER DWG, SRM AND AMM.SDR SWAA2012021401437Skin · crackedCRACK IN SKIN AT CHEM MILL AT BS 758.5, STR 23 LT. REPAIRED SKIN PER SRM.SDR SWAA2012021301380Skin · crackedCRACK IN FUSELAGE SKIN AT BS 832.25, STR 17L. REMOVED SKIN IAW SRM.SDR SWAA1201077Skin · crackedCRACK IN FUSELAGE SKIN AT CHEM-MILL AT BS 764 ABOVE STR 21L. REPAIRED SKIN PER SRM.SDR SWAA1201076Skin · crackedCRACK IN FUSELAGE SKIN AT CHEM-MILL BS 841.75 ABOVE STR 17L. REPAIRED SKIN PER SRM.SDR SWAA1201075Skin · crackedCRACK IN FUSELAGE SKIN AT CHEM-MILL BS 769.5 BELOW STR 19L. REPAIRED SKIN PER SRM.SDR SWAA2012022001582Skin · corrodedFUSELAGE SKIN IS CORRODED AROUND FASTENERS AT THE LWR AFT CORNER OF THE FWD LAV SERVICING DOOR CUTOUT. REPAIRED SKIN IAW ER AND EA.SDR SWAA2012022001581Skin · crackedSKIN CRACKED AT BS 807+3, STR 17L. REPAIRED SKIN IAW ER AND EA.SDR SWAA2012021301379Skin · crackedSKIN CRACKED AT BS 867, STR 23R. REPAIRED SKIN IAW SRM.SDR SWAA2012021001319Skin · delaminatedLT WING I/B FORE FLAP DELAMINATED AT UPPER SURFACE. REPAIRED FORE FLAP IAW SRM.SDR SWAA201201200Skin · crackedFUSELAGE SKIN CRACK (CHEM-MILL) S19L, AT BS 787+6 CRACKED. REPAIRED SKIN PER SRM.SDR SWAA201201199Skin · crackedSKIN CRACKED AT BS 867, STR 24R. REPAIRED SKIN PER SRM.SDR SWAA1201074Skin · crackedFUSELAGE SKIN (CHEM-MILL) CRACKED ABOVE S 24R AT BS 867+6". REPAIRED SKIN PER SRM.SDR SWAA1201073Skin · crackedFUSELAGE SKIN CRACK (CHEM-MILL) BELOW S 19L AT BS 807+3" CRACKED. REPAIRED SKIN PER SRM.SDR SWAA2012022001573Skin · crackedSKIN CRACKED AT BS. 809+3, STR 17R. REPAIRED SKIN PER SRM.SDR SWAA2012022001571Skin · crackedSKIN CRACKED AT BS 867+3, STR 23R. REPAIRED SKIN PER SRM.SDR SWAA2012020201572Skin · crackedSKIN CRACKED AT BS 867+3, STR 24R. REPAIRED SKIN PER SRM.SDR SWAA117576Slat · damagedDURING SCHEDULED HC2 CHECK, FOUND RT WING NR 6 SLAT I/B CAN DAMAGED. REMOVED AND REPLACED SLAT CAN PER EA.SDR SWAA117575Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND SKIN CRACKED BETWEEN BS 435 TO BS 436, STR 1. REPAIRED SKIN PER EA.SDR SWAA115823Flap · delaminatedDURING SCHEDULED MV1 CHECK, FOUND RT WING O/B AFT FLAP DELAMINATED. REMOVED AND REPLACED AFT FLAP PER MM.SDR SWAA115315Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED BETWEEN BS 765 TO BS 767.5, STR 22L. REPAIRED SKIN PER SRM.SDR SWAA113321Flap · delaminatedDURING SCHEDULED MV2 CHECK FOUND DELAMINATION LT OUTBD AFT FLAP. REMOVED AND REPLACED FLAP PER MM.SDR SWAA112847Battery Pack · dischargedDURING SCHEDULED SPV CHECK, FOUND LT OVERWING EXTERIOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA112846Battery Pack · dischargedDURING SCHEDULED SPV CHECK, FOUND RT OVERWING EXTERIOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA112736Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 907, STR 4L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA112636Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO DOOR CUTOUT FWD FRAME CRACKED AT BS 440 AT UPPER STOP FITTING. REPAIRED FRAME PER SRM.SDR SWAA112635Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 460, STR 10L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA112634Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CHORD CRACKED AT BS 616, WL 208. REMOVED AND REPLACED CHORD PER EA.SDR SWAA112633Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 420, STR 4L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA112550Battery · dischargedDURING SCHEDULED SPV CHECK, FOUND L2 DOOR EXTERIOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA112503Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND SKIN CRACKED AT BS 400+12, STR 1. REPAIRED SKIN PER EA.SDR SWAA110293Gasper Fan · faultySTRONG ODOR COMING FROM ENVIRONMENTAL SYSTEM. REMOVED AND REPLACED GASPER FAN PER MM.SDR SWAA105083Skin · crackedDURING SCHEDULED 2HC2 CHECK, FOUND SKIN CRACKED AT BS 791, STR 19L. REPAIRED SKIN PER EA.SDR SWAA105082Skin · crackedDURING SCHEDULED 2HC2 CHECK, FOUND SKIN CRACKED AT BS 780, STR 19L. REPAIRED SKIN PER EA.SDR SWAA105081Support Fitting · crackedDURING SCHEDULED 2HC2 CHECK, FOUND AFT CARGO DOOR FWD AND AFT DOOR STOP T-CAP WEB SUPPORT FITTING CRACKED. REMOVED AND REPLACED DOOR PER MM.SDR SWAA104181Sign · looseLT EMERGENCY EXIT SIGN LOOSE. SECURED SIGN PER MM.SDR SWAA103852Light · inoperativeDURING SCHEDULED 20Y CHECK, FOUND L2 DOOR EXTERIOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA103816Sign · damagedDURING SCHEDULED 20Y CHECK, FOUND FWD ENTRY EMERGENCY EXIT SIGN DAMAGED. REMOVED AND REPLACED SIGN PER MM.SDR SWAA103815Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME WEB CRACKED AT BS 303.9, STR 16L. REPAIRED WEB PER ACO.SDR SWAA103783Skin · corrodedDURING SCHEDULED 20Y CHECK, FOUND LT WING WING ROOT I/B SKIN CORRODED. REPAIRED SKIN PER AAR EA.SDR SWAA103768Fitting · crackedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO COMPARTMENT BULKHEAD FITTING CRACKED BS 727, RBL 6.5. REMOVED AND REPLACED FITTING PER SRM BAC DWG.SDR SWAA103707Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 482A, STR 20R. REPAIRED FRAME PER SRM.SDR SWAA103670Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 927, STR 26R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA103669Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND SKIN CRACKED AT BS 522, RBL 4.5. REPAIRED SKIN PER AAR EA.SDR SWAA103527Wedge · delaminatedDURING SCHEDULED 20Y CHECK, FOUND RT WING NR 6 SLAT I/B WEDGE DELAMINATED. REPAIRED WEDGE PER SRM.SDR SWAA103468Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 927, STR 25R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA103467Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 294, STR 13L. REMOVED AND REPLACED CLIP PER SRM.
Back to N511SW, cancelled Jan 2, 2019