N527SW, cancelled Mar 27, 2018
Service difficulty reports · 374
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 = 'N527SW' AND deregistration_id = 'N527SW-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 = 'N527SW' AND deregistration_id = 'N527SW-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 SWAA2015030237012Splice · crackedBULKHEAD SPLICE ANGLE CRACKED AT BS 540, BETWEEN STRINGER 21L TO 22L. R & R ANGLE IAW EA.SDR SWAA2015021736669Flap Track · corrodedRIGHT WING NR 7 FLAP TRACK FWD OTBD FLANGE CORRODED. R & R NR 7 FLAP TRACK IAW MM.SDR SWAA2015021136534Support Fitting · crackedRIGHT WING GND SPOILER INBD SIDE SUPPORT FITTING CRACKED. R & R FITTING IAW SRM & DWG.SDR SWAA2015021036485Skin · crackedRIGHT WING AFT FLAP INBD SIDE CRACKED ON LOWER SURFACE. REPAIRED AFT FLAP IAW SRM.SDR SWAA2015021036437Angle · crackedANGLE CRACKED AT BS 887, BETWEEN STRINGER 1 - 2R. R & R ANGLE IAW SRM & DWG.SDR SWAA2015021036436Angle · crackedANGLE CRACKED AT BS 887, BETWEEN STRINGER 1 - 2L. R & R ANGLE IAW SRM & DWG.SDR SWAA2015020636387Flap · delaminatedRIGHT WING INBD AFT FLAP LOWER OTBD DELAMINATED ON TE. REPAIRED AFT FLAP IAW SRM.SDR SWAA2015020236268Fitting · crackedCLIP CRACKED AT BS 927, STRINGER 11L. R & R CLIP IAW SRM & DWG.SDR SWAA2015020236267Tie Clip · crackedTIE CLIP CRACKED AT BS 616, STRINGER 5L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2015020236266Tie Clip · crackedTIE CLIP CRACKED AT BS 616, STRINGER 5R. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2015012736117Attach Fitting · corrodedLEFT WING NR 2 FLAP TRACK ATTACH PAD CORRODED. REPAIRED ATTACH PAD IAW CMM.SDR SWAA2015030437091Beam · crackedSTUB BEAM CRACKED AT BS 616, STRINGER 17L. R & R STUB BEAM IAW EA.SDR SWAA2015021936721Web · crackedFLOOR STRUCTURE WEB CRACKED BETWEEN BS 344 TO 360, BBL 0. R & R WEB IAW SRM & DWG.SDR SWAA2015012636046Strap · crackedL1 DOOR UPPER HINGE H STRAP CRACKED AT BS 303.9, STRINGER 10L. R & R H STRAP IAW SRM & DWG.SDR SWAA2015030637189Frame · crackedFUSELAGE FRAME CRACKED AT STATION 947.5, STRINGER 19R. REPAIRED FRAME IAW EA.SDR SWAA2015030437090Beam · crackedSTUB BEAM FRAME INNER CHORD CRACKED AT BS 616, BETWEEN STRINGER 17L TO 18L. REPAIRED CHORD IAW EA.SDR SWAA2015021136533Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 294.5, STRINGER 23L. R & R ANGLE IAW SRM & DWG.SDR SWAA2015021036484Intercostal · crackedINTERCOSTAL CRACKED BETWEEN BS 294.5 - 312, BETWEEN STRINGER 28L - 27R. R & R INTERCOSTAL IAW SRM & DWG.SDR SWAA2015021036435Angle · crackedANGLE CRACKED BETWEEN BS 927 - 947.5, BL 0. R & R ANGLE IAW SRM & DWG.SDR SWAA2015012736116Flap Track · corrodedLEFT WING NR 2 FLAP TRACK AFT HOLES CORRODED. REPAIRED NR 2 FLAP TRACK IAW CMM.SDR SWAA2015012636045Angle · crackedANGLE CRACKED BETWEEN BS 887 - 907, RBL 47. R & R ANGLE IAW SRM & DWG.SDR SWAA2015012235955Angle · crackedANGLE CRACKED AT BS 947.5+10, BETWEEN STRINGER 26L TO 24L. R & R ANGLE IAW SRM & DWG.SDR SWAA2015030437089Skin · crackedFUSELAGE SKIN CORRODED BETWEEN BS 747 TO 767, BETWEEN STRINGER 27L TO 27R. REPAIRED SKIN IAW EA.SDR SWAA2015021736671Tie Clip · crackedTIE CLIP CRACKED AT BS 400, STRINGER 8R. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2015012736115Intercostal · crackedINTERCOSTAL CRACKED AT BS 540, BETWEEN BL 0 TO LBL 24.5. R & R INTERCOSTAL IAW SRM & DWG.SDR SWAA2015011635822Strap · crackedVERTICAL STABILIZER ACCESS PANEL 9501 STRAP CRACKED. R & R STRAP IAW SRM & DWG.SDR SWAA2015030437087Tee Fitting · crackedAFT CARGO COMPARTMENT DOOR T CHORD CRACKED AT BS 796.8+2.5. REPAIRED T CHORD IAW EA.SDR SWAA2015012936175Angle · crackedFORWARD ENTRY DOOR REVEAL ANGLE CRACKED ON THE LOWER FWD CORNER. R & R ANGLE IAW SRM & DWG.SDR SWAA2015022436850Skin · crackedLEFT FUSELAGE SKIN CABIN WINDOW POST C - D CRACKED AT BS 211.8, STRINGER 10L. REPAIRED SKIN IAW EO & EA.SDR SWAA2015021036483Skin · crackedLEFT WING FIXED LE SKIN CRACKED AT WBL 254.00. REPAIRED SKIN IAW SRM.SDR SWAA2015030937238Skin · corrodedSKIN CORRODED BETWEEN BS 482A TO 482B, BL 0. REPAIRED SKIN IAW EO & EA.SDR SWAA2015022436849Post · crackedLEFT WINDOW POST CRACKED ON UPPER CORNER AT BS 211.8. REPAIRED POST IAW EO & EA.SDR SWAA2014121635050Skin · crackedFUSELAGE SKIN CRACKED AT BS 380+3, STRINGER 15R. REPAIRED SKIN IAW EA.SDR SWAA2014121635049Skin · crackedFUSELAGE SKIN CRACKED AT BS 867+4, STRINGER 23R. REPAIRED SKIN IAW EA.SDR SWAA2014121034899Skin · crackedFUSELAGE SKIN CRACKED AT BS 400+14, STRINGER 1L. REPAIRED SKIN IAW EA.SDR SWAA2014120134569Hinge · brokenLEFT WING NR 4 GND SPOILER HINGE BROKEN. R & R NR 4 SPOILER IAW MM.SDR SWAA2014101332878Light · inoperativeLEFT OVERWING EMER EXIT LIGHT INOPERATIVE. RELAMPED IAW MM.SDR SWAA2014092632336Duct · damagedAIR TURN BACK, DECLARED EMER, ODOR DETECTED IN CABIN. FOUND RT HEAT EXCHANGER DUCT DAMAGED. R & R RT MIX VLV TO PACK VLV DUCT ASSEMBLY IAW MM.SDR SWAA2014092432247Acm · leakingFLIGHT ATTENDANTS AND PAXS REPORT A STRONG FOUL ODOR THROUGHOUT CABIN WHILE INFLIGHT. FOUND NR 2 AIR CYCLE MACHINE LEAKING OIL. R & R NR 2 AIR CYCLE MACHINE IAW MM.SDR SWAA2014081330818Slide · unsecureL1 DOOR EMER EVAC SLIDE INADVERTENTLY FELL OUT, DID NOT DEPLOY & STILL OPERATIONAL. REINSTALLED SLIDE IAW MT.SDR SWAA2014072130133Battery Pack · dischargedAFT EMER EXIT LIGHTS INOPERATIVE. R & R BATTERY PACK IAW AMM.SDR SWAA2014071830094Module · faultyODOR IN COCKPIT ON DECENT. R & R P5 2 FUEL OVERHEAD MODULE IAW MM.SDR SWAA2014072130132Panel · faultyON DESCENT THRU 180 AN ELEC OR CHEMICAL SMELL FILLED THE COCKPIT. R & R P5 2 MODULE FUEL PANEL IAW MM.SDR SWAA2014061128926Connector · looseAFT EMER EXITS LIGHT BATTERY PACK CONNECTOR LOOSE. SECURED CONNECTOR IAW AMM.SDR SWAA2014032426413Skin · crackedCHEM MILL SKIN CRACKED BETWEEN BS 384.7 TO BS 386.1, STRINGER 15L. REPAIRED SKIN IAW EA & ER.SDR SWAA2014012924656Support Angle · crackedLT WING INBD UPPER FIXED FAIRING INBD SUPPORT ANGLE CRACKED AT AFT END. R & R ANGLE IAW SRM.SDR SWAA2014012424537Display · faultyAIR TURN BACK ON TAKEOFF ROLL THE HEADING CARD LOCKED UP WITH HEADING FLAG ON BOTH SIDES. R & R ISDU IAW MM.SDR SWAA2013100320766Coffeemaker · faultyDURING DESCENT STRONG BURNING SMELL IN AFT GALLEY. R & R NR 2 COFFEE MAKER IAW AMM.SDR SWAA2013081419211Stringer Splice · crackedSTRINGER SPLICE CRACKED AT BS 908, STRINGER 4L. R&R SPLICE IAW SRM & DRAWING.SDR SWAA2013082619549Skin · crackedFS SKIN CRACKED AT BS 360 STRINGER 3L. REPAIRED SKIN IAW EA.
Back to N527SW, cancelled Mar 27, 2018