N526SW, cancelled Mar 27, 2018
Service difficulty reports · 422
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 = 'N526SW' AND deregistration_id = 'N526SW-2018-03-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 = 'N526SW' AND deregistration_id = 'N526SW-2018-03-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 SWAA118586Shear Tie · crackedDURING SCHEDULED 20Y CHECK, FOUND SHEAR TIE CRACKED AT BS 520, BETWEEN STR 21L TO STR 22L. REPAIRED SHEAR TIE IAW SRM.SDR SWAA118585Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND SKIN CRACKED BETWEEN BS 760 TO BS 765, STR 22L. REPAIRED SKIN IAW SRM.SDR SWAA118526Flap · delaminatedDURING SCHEDULED 20Y CHECK, FOUND RT WING I/B FORE FLAP DELAMINATED. REPAIRED FORE FLAP PER MM.SDR SWAA20111212325Mount · looseDURING SCHEDULED 20Y CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE FWD ATTACH MOUNT LOOSE. R&R MOUNT PER SOPM.SDR SWAA117425Charger · inoperativeDURING SCHEDULED MV1 CHECK, FOUND RT FWD EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY CHARGER PER MM.SDR SWAA117424Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND RT HORIZONTAL STABILIZER LOWER INSPAR SKIN CRACKED. REPAIRED SKIN IAW EA.SDR SWAA117229Battery · dischargedL1 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA117045Charger · inoperativeDURING SCHEDULED CV CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY CHARGER PER MM.SDR SWAA116193Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 752, STR 24L. REPAIRED SKIN PER SRM.SDR SWAA2013090919962Skin · crackedFS SKIN CRACKED BETWEEN STATION 747 TO STATION 767, STRINGER 22L. REPAIRED SKIN IAW SRM.SDR SWAA116161Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 727E+18, STR 22L. REPAIRED SKIN PER SRM.SDR SWAA114791Frame · crackedDURING SCHEDULED 2HC2 CHECK, FOUND R1 DOOR STUB FRAME CRACKED AT UPPER CORNER. REPAIRED FRAME PER EA AND DWG.SDR SWAA113189Coffeemaker · faultyON DESCENT FLIGHT ATTENDANT REPORTED A STRONG ELECTRICAL SMELL IN AFT GALLEY. REMOVED AND REPLACED COFFEEMAKER PER MM.SDR SWAA107619Skin · crackedDURING SCHEDULED OTS CHECK, FOUND FUSELAGE SKIN CRACKED AT L2 DOOR FWD LOWER CORNER CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA107618Battery Pack · dischargedDURING SCHEDULED OTS CHECK, FOUND RT OVERWING EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA107489Skin · crackedDURING SCHEDULED OTS CHECK, FOUND SKIN CRACKED AT BS 882, STR 25R. REPAIRED SKIN PER SRM.SDR SWAA107281Skin · crackedDURING SCHEDULED 2HC1 CHECK, FOUND SKIN CRACKED AT BS 870, STR 23R. REPAIRED SKIN PER SRM.SDR SWAA107280Skin · crackedDURING SCHEDULED 2HC1 CHECK, FOUND SKIN CRACKED AT BS 870, STR 24R. REPAIRED SKIN PER SRM.SDR SWAA107279Skin · crackedDURING SCHEDULED 2HC1 CHECK, FOUND SKIN CRACKED AT BS 872, STR 25R. REPAIRED SKIN PER SRM.SDR SWAA107278Skin · crackedDURING SCHEDULED 2HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT L2 DOOR FWD HINGE CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA107277Skin · crackedDURING SCHEDULED 2HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT L2 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA107150Actuator · leakingIN CRUISE FLIGHT HYDRAULIC B QUANTITY DECREASED. "B" ENGINE DRIVEN PUMP LOW PRESSURE LIGHT ILLUMINATED. REMOVED AND REPLACED FLIGHT SPOILER ACTUATOR PER MM.SDR SWAA106908Slide · looseDURING SCHEDULED MV2 CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE LOOSE. SECURED SLIDE PER MM.SDR SWAA106532Controller · failedDECLARED EMERGENCY, CABIN ALTITUDE HORN SOUNDED IN CRUISE, 34,000FT, CABIN ALTITUDE SHOWED 10,000 CLIMBING FORM 1,000FPM. NO AUTO FAIL LIGHT. COMPLIED WITH QRH. FOUND PRESSURE CONTROLLER FAILED PER MT. REMOVED AND REPLACED CONTROLLER PER MM.SDR SWAA105240Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND OVERHEAD BULLNOSE EMERGENCY EXIT LIGHT INOP BETWEEN ROW 6 TO ROW 7. RELAMPED PER MM.SDR SWAA102804Slide · out of positionR1 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MT.SDR SWAA102329Slide · looseL2 DOOR EMERGENCY EVAC SLIDE LOOSE. SECURED SLIDE PER MM.SDR SWAA100053Fitting · looseDURING SCHEDULED 18Y CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR FITTING LOOSE. SECURED FITTING PER MM.SDR SWAA100052Fitting · looseDURING SCHEDULED 18Y CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR FITTING LOOSE. SECURED FITTING PER MM.SDR SWAA100050Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FWD CARGO BAY FRAME CRACKED AT BS 482B, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER AAR EA.SDR SWAA100030Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 947.5, STR 24R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA100029Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND SKIN CRACKED BETWEEN BS 360 TO BS 399, BETWEEN STR 27L TO STR 27R. REPAIRED SKIN PER AAR EA.SDR SWAA100028Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FWD CARGO BAY FRAME CRACKED AT BS 482, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER SRM.SDR SWAA098126Strap · crackedDURING SCHEDULED 18Y CHECK, FOUND L1 DOOR CUTOUT STRINGER STRAP CRACKED AT BS 303, STR 13L. REMOVED AND REPLACED STRAP PER SRM.SDR SWAA098147Mount Bracket · brokenDURING SCHEDULED 18Y CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR FLOOR MOUNT BRACKET BROKEN. REMOVED AND REPLACED BRACKET PER MM.SDR SWAA098146Skin · crackedDURING SCHEDULED 18Y CHECK, FOUND SKIN CRACKED AT BS 750, STR 23L. REPAIRED SKIN PER SRM.SDR SWAA098145Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FRAME CRACKED AT BS 482A, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER SRM.SDR SWAA098144Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FRAME CRACKED AT BS 482B, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER SRM.SDR SWAA098132Slide · out of positionDURING SCHEDULED 18Y CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MT.SDR SWAA098108Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 747, STR 23L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA098107Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 294.5, STR 11L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA098106Shear Tie · crackedDURING SCHEDULED 18Y CHECK, FOUND SHEAR TIE CRACKED BETWEEN BS 286 TO BS 288, STR 13L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA097998Shear Tie · crackedDURING SCHEDULED 18Y CHECK, FOUND SHEAR TIE CRACKED AT BS 482B, STR 19R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA096967Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND SKIN CRACKED AT BS 934, STR 24L. REPAIRED SKIN PER EA.SDR SWAA094752Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 847, STR 5R. REPAIRED SKIN PER SWA EA.SDR SWAA094140Skin · crackedDURING SCHEDULED SPV, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER ER.SDR SWAA094139Skin · crackedDURING SCHEDULED SPV, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER ER.SDR SWAA093004Light · looseEEPLS STRIP LOOSE AT ROW 7. SECURED EEPLS PER MM.SDR SWAA091200Bear Strap · corrodedDURING SCHEDULED 16Y CHECK, FOUND FWD CARGO DOOR BEAR STRAP SKIN CUTOUT CORRODED AT BS 450, STR 24R. REPAIRED SKIN PER ER.SDR SWAA091008Bear Strap · corrodedDURING SCHEDULED 16Y CHECK, FOUND AFT CARGO BAY BEAR STRAP SKIN CORRODED AT BS 847, BETWEEN STR 26R TO STR 27R. REPAIRED SKIN PER ER.
Back to N526SW, cancelled Mar 27, 2018