N376SW, cancelled Jan 6, 2020
Service difficulty reports · 376
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 = 'N376SW' AND deregistration_id = 'N376SW-2020-01-06' 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 = 'N376SW' AND deregistration_id = 'N376SW-2020-01-06' 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 SWAA2015102245221Skin · crackedR1 DOOR EXTERNAL FUSELAGE SKIN LOWER HINGE CUT OUT ON BEAR STRAP CRACKED, BETWEEN BS 294.5 - 312, BETWEEN STRINGER 12L - 15L. R & R SKIN IAW SRM.SDR SWAA2015110445744Skin · crackedAFT CARGO DOOR FUSELAGE SKIN CUT OUT CRACKED AT BS 807-10, BETWEEN STRINGER 23R - 26R. REPAIRED SKIN IAW EA.SDR SWAA2015102645319Intercostal · crackedINTERCOSTAL WEB CRACKED, BETWEEN BS 277 TO BS 277, STRINGER 14R. R & R WEB IAW EA.SDR SWAA2015101945071Strap · crackedRIGHT WING, NR 6 FAIRING FLAP TRACK STRAP CRACKED. R & R STRAP IAW DWG.SDR SWAA2015101945070Reveal · crackedENTRY DOOR CUT OUT REVEAL CRACKED, BETWEEN BS 303.9 - BS 312, BETWEEN STRINGER 6L - 7L. R & R REVEAL IAW SRM & DWG.SDR SWAA2015110245591Skin · crackedRIGHT MLG DOOR INNER SKIN CRACKED. R & R DOOR IAW AMM.SDR SWAA2015102945483Frame · crackedFRAME INNER CHORD CRACKED AT BS 639, BETWEEN STRINGER 14R - 18R. REPAIRED FRAME IAW EA.SDR SWAA2015102845435Frame · crackedFRAME CRACKED AT BS 344, STRINGER 6L. REPAIRED FRAME IAW EO & EA.SDR SWAA2015101945069Channel · crackedFORWARD CARGO COMPARTMENT, FLOOR STRUCTURE CHANNEL CRACKED AT BS 540, BETWEEN BL 0 TO RBL 24.75. R & R CHANNEL IAW SRM & DWG.SDR SWAA2015101644993Scuff Plate · crackedFORWARD CARGO COMPARTMENT, CTR SCUFF PLATE CRACKED. REPAIRED SCUFF PLATE IAW EA.SDR SWAA2015101644992Scuff Plate · crackedFORWARD CARGO COMPARTMENT, AFT CORNER SCUFF PLATE CRACKED. REPAIRED SCUFF PLATE IAW EA.SDR SWAA2015092844311Channel · crackedFORWARD CARGO COMPARTMENT CHANNEL CRACKED AT BS 540, BETWEEN BL 0 TO LBL 24.75. R & R CHANNEL IAW SRM & DWG.SDR SWAA2015110245590Flap · crackedRIGHT WING LE KRUEGER FLAP AREA, CRACKED ON BS 208. REPAIRED KRUEGER FLAP IAW SRM.SDR SWAA2015102345273Glowstrip · deterioratedAFT CABIN STRIP PHOTO LUMINESCENT FLOOR PROXIMITY LIGHTING DETERIORATED. R & R STRIP IAW AMM.SDR SWAA2015101444896Reveal · crackedL1 DOOR CUT OUT REVEAL CORNER CRACKED, BETWEEN BS 328 - 344. R & R CORNER IAW SRM & DWG.SDR SWAA2015102845434Web · crackedRIGHT NOSE WW WEB CRACKED, BETWEEN BS 230 - 260, ABOVE WL 169.1. REPAIRED WEB IAW EO & EA.SDR SWAA2015101945068Floorbeam · corrodedFLOORBEAM UPPER CHORD, CORRODED AT BS 328, BETWEEN LBL 50 TO RBL 65. REPAIRED FLOORBEAM IAW SRM.SDR SWAA2015092444239Angle · corrodedAFT GALLEY AREA, LOWER SILL STRINGER Z ANGLE CORRODED, BETWEEN BS 907 - 1008, STRINGER 17R. R & R Z ANGLE IAW SRM.SDR SWAA2015070941595Lens · unsecureCOCKPIT DOOR EXIT SIGN LENS FELL OFF INFLIGHT. R & R LENS IAW SIP.SDR SWAA2015060140234Lens · brokenEXIT SIGN LENS BROKEN AT FWD FLIGHT ATTENDANT`S SEAT. R & R LENS IAW MM.SDR SWAA2015030337050Casting · brokenLEFT WING INBD GND SPOILER OTBD HINGE CASTING BROKEN. R & R GND SPOILER IAW AMM.SDR SWAA2014121234976Nut Plate · brokenL1 DOOR EMER EVAC SLIDE INADVERTENTLY FELL OUT, DID NOT DEPLOY, STILL OPERATIONAL. FOUND NUTPLATE BROKEN. R & R NUTPLATE IAW MM.SDR SWAA2014100632656Spindle · corrodedRIGHT WING NR 8 FLAP SPINDLE CORRODED. R & R MID FLAP CARRIAGE IAW MT.SDR SWAA2014093032449Skin · delaminatedLEFT WING OTBD AFT FLAP LOWER SURFACE DELAMINATED. R & R AFT FLAP IAW AMM.SDR SWAA2014092232180Attach Fitting · crackedATTACH FITTING CRACKED AT BS 727 LBL 44.5. R & R FITTING IAW SRM.SDR SWAA2014093032460Frame · crackedFRAME OTBD CHORD CRACKED AT BS 727 STRINGER 18A LT. REPAIRED CHORD IAW EA.SDR SWAA2014093032459Frame · crackedFRAME OTBD CHORD CRACKED AT BS 727 STRINGER 18A RT. REPAIRED CHORD IAW EA.SDR SWAA2014091832091Frame · crackedFRAME INNER CHORD CRACKED AT BS 348 STRINGER 17L. R & R CHORD IAW EA.SDR SWAA2014081930978Skin · crackedRIGHT WING LOWER SKIN CRACKED EMANATING FROM UNDER THE PYLON MID SPAR LUG OTBD OF PYLON. REPAIRED SKIN CRACK IAW EA.SDR SWAA2014050527647Pump · failedDIVERSION, DECLARED EMERGENCY. DURING CLIMB OUT A SYS HYD SYS FAILED. R & R NR 3 FLT SPOILER TEST PORT CAP, O RING & ENG DRIVEN PUMP IAW MM.SDR SWAA2014050527718Actuator · faultyRED NOSE GEAR LIGHT ILLUMINATED WITH GEAR HANDLE UP. NOSE GEAR EXTENDS TO DOWN POSITION WITH GEAR HANDLE IN THE OFF POSITION. CYCLED GEAR DOWN THEN UP TWICE. R & R NLG RETRACT ACTUATOR IAW MM.SDR SWAA2014042227260O-Ring · damagedDIVERSION, A SYS HYD QTY FELL. DID NOT GET ANY LOW PRESS LIGHTS. R & R NR 3 SPOILER O RING IAW MM.SDR SWAA2014030325710Lens · looseRT EMERGENCY EXIT LENS LOOSE. R & R LENS IAW MM.SDR SWAA2014022525508O-Ring · damagedAIR TURN BACK DECLARED EMERGENCY LOST A SYS INFLIGHT ENG PUMP LOW PRESS AT QUANTITY ZERO. R & R O RING IAW MM.SDR SWAA2014021325119Sign · looseRT OVERWING EMERGENCY EXIT SIGN LOOSE. SECURED SIGN IAW SIP.SDR SWAA2014010223722Battery Pack · dischargedAFT CABIN EMERGENCY EXIT LIGHT INOPERATIVE. R&R BATTERY PACK IAW MM.SDR SWAA2013122323590Priority Valve · faultyDURING GEAR RETRACTION NLG RED LIGHT REMAINED ILLUMINATED WITH GEAR HANDLE UP. NLG EXTENDED WITH GEAR HANDLE IN NEUTRAL POSITION. R & R NLG PRIORITY VLV MODULAR UNIT & LOCK ACTUATOR IAW MM.SDR SWAA2013112622758Battery Pack · faultyEMERGENCY LIGHTS IN AFT SECTION OF ACFT FAULTY. R & R BATTERY PACK IAW MM.SDR SWAA2013102821536Battery · dischargedLT WING AFT EMERGENCY EXIT LIGHT INOPERATIVE. R & R BATTERY IAW MM.SDR SWAA2013100720868Support Fitting · crackedLT WING GROUND SPOILER SUPPORT FITTING CRACKED AT WBL 119.25. R & R FITTING IAW DRAWING & SRM.SDR SWAA2013100320732Support Angle · crackedRT WING NR 6 TE INBD SIDE FLAP TRACK SUPPORT ANGLE CRACKED. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2013093020564Web · crackedFWD CARGO COMPARTMENT WEB CRACKED BETWEEN BS 400 TO BS 420 STRINGER 26L. R & R WEB IAW SRM & DRAWING.SDR SWAA2013100320731Support Angle · crackedWING TO BODY FAIRING SUPPORT ANGLE CRACKED AT BS 540 BETWEEN STRINGER 22R & STRINGER 23R. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2013100320730Rib · crackedRT WING LOWER CHORD RIB CRACKED AT WBL 135.50 BETWEEN STRINGER 2 TO STRINGER 3. REPAIRED CHORD IAW EA.SDR SWAA2013093020563Angle · crackedVERTICAL ANGLE CRACKED AT BS 312 BL O. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2013093020562Angle · crackedFWD CARGO COMPARTMENT ANGLE CRACKED AT BS 400 STRINGER 26L. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2013092420456Strap · crackedSTRAP CRACKED AT BS 314 RBL 31 UNDER FLOOR STRUCTURE INTERNAL AREA EE COMPARTMENT. R & R STRAP IAW SRM & DRAWING.SDR SWAA2013092320365Angle · crackedANGLE CRACKED AT BS 334, STRINGER 20L. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2013092320364Angle · crackedANGLE CRACKED AT BS 328, STRINGER 20L. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2013100720867Angle · crackedANGLE CRACKED AT BS 540 RBL 1. R & R ANGLE IAW SRM & DRAWING.
Back to N376SW, cancelled Jan 6, 2020