N620SW, cancelled Nov 15, 2018
Service difficulty reports · 407
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 = 'N620SW' AND deregistration_id = 'N620SW-2018-11-15' 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 = 'N620SW' AND deregistration_id = 'N620SW-2018-11-15' 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 SWAA2015100744657Shear Tie · corrodedFRAME SHEAR TIE, CORRODED AT BS 480, STRINGER 27R. R & R SHEAR TIE IAW DWG.SDR SWAA2015100544579Bracket · corrodedAFT CARGO COMPARTMENT BRACKET CORRODED AT BS 887, BETWEEN STRINGER 23L - 25L. REPAIRED BRACKET IAW SRM & DWG.SDR SWAA2015112346282Frame · corrodedFRAME CORRODED AT BS 727E, LBL 7. R & R FRAME IAW EA & DWG.SDR SWAA2015100944762Frame · crackedFRAME STUB BEAM INNER CHORD LOWER FASTENER HOLE CRACKED AT BS 616, STRINGER 17R. REPAIRED CHORD IAW EA.SDR SWAA2015101144628Intercostal · crackedR1 DOOR INTERCOSTAL WEB CRACKED, BETWEEN BS 277 - 291.5, STRINGER 14R. R & R WEB IAW EA.SDR SWAA2015112446403Stringer · corrodedSTRINGER CORRODED AT BS 420, STRINGER 25R. R & R STRINGER IAW SRM & DWG.SDR SWAA2015112346304Stringer · corrodedFORWARD CARGO COMPARTMENT, FWD OF DOOR CUT OUT CORRODED, BETWEEN BS 420 - 440, STRINGER 25R. R & R STRINGER IAW SRM.SDR SWAA2015111846170Fitting · corrodedR1 DOOR AFT GIRT BAR FLOOR BRACKET FITTING CORRODED. R & R FITTING IAW AMM.SDR SWAA2015111846169Fitting · corrodedR1 DOOR ESCAPE SLIDE GIRT BAR FLOOR BRACKET FITTING CORRODED. R & R FITTING IAW AMM.SDR SWAA2015101645018Skin · delaminatedLEFT WING OTBD LE NR 2 SLAT, AFT WEDGE UPPER SURFACE SKIN DELAMINATED AT INBD END. REPAIRED SKIN IAW SRM.SDR SWAA2015100644627Fitting · corrodedCLIP CORRODED AT BS 500C, BETWEEN STRINGER 28R - STRINGER. R & R CLIP IAW DWG.SDR SWAA2015082643232Light · inoperativeAFT GALLEY EMER EXIT LIGHT INOPERATIVE, OTBD OF THE G4 GALLEY. R & R LIGHT ASSEMBLY IAW AMM.SDR SWAA2015080243015Slat · delaminatedLEFT WING NR 3 SLAT DELAMINATED INBD AFT WEDGE. REPAIRED NR 3 SLAT IAW SRM.SDR SWAA2015081942969Skin · crackedLEFT WING TE UPPER SKIN CRACKED AT STATION 254.97 FROM FASTENER TO EDGE OF SKIN. REPAIRED SKIN IAW EA.SDR SWAA2015081442849Skin · delaminatedLEFT WING AFT OTBD TE FLAP SKIN DELAMINATED OTBD LOWER SURFACE. REPAIRED FLAP SKIN IAW SRM.SDR SWAA2015081542884Slat · delaminatedLEFT WING NR 3 SLAT DELAMINATED INBD AFT WEDGE. REPAIRED NR 3 SLAT IAW SRM.SDR SWAA2015080642566Wedge · delaminatedLEFT WING NR 3 SLAT DELAMINATED INBD AFT WEDGE. REPAIRED WEDGESDR SWAA2015071441930Slide · out of positionR1 DOOR EMER EVAC SLIDE GIRT BAR INADVERTENTLY PULLED OUT OF CONTAINER, DID NOT DEPLOY, STILL OPERATIONAL. REINSTALLED SLIDE IAW TC.SDR SWAA2015052039872Cover · brokenFORWARD ENTRY DOOR EXIT LIGHT COVER BROKEN. SECURED COVER IAW SIP.SDR SWAA2015051439678Control Rod · looseRIGHT ELEVATOR TAB INBD CONTROL ROD BOLT LOOSE IN TAB MAST FITTING. R & R CONTROL ROD IAW EA.SDR SWAA2015051439677Sign · loosePASSENGER CABIN CEILING EXIT SIGN LOOSE AT ROW 2. SECURED SIGN IAW MM.SDR SWAA2015051439676Glowstrip · damagedRIGHT PAX CABIN PHOTO LUMINESCENT FLOOR STRIP DAMAGED AT ROW 4. R & R STRIP IAW MM.SDR SWAA2015051439675Glowstrip · damagedRIGHT PAX CABIN PHOTO LUMINESCENT FLOOR STRIP DAMAGED AT ROW 3. R & R STRIP IAW MM.SDR SWAA2015032437747Battery · dischargedLEFT EMER LIGHTS INOPERATIVE BETWEEN ROWS 10 - 18. R & R BATTERY IAW AMM.SDR SWAA2015020636393Bracket · crackedRIGHT WING AILERON CLOSEOUT BAY BRACKET CRACKED AT REAR SPAR STATION 545. R & R BRACKET IAW SRM.SDR SWAA2015020636392Flap · delaminatedLEFT WING OTBD AFT FLAP DELAMINATED AT OTBD END. R & R AFT FLAP IAW AMM.SDR SWAA2015020636391Support Bracket · crackedRIGHT WING NR 6 FLAP TRACK FAIRING, UPPER FIXED TE PANEL SUPPORT BRACKET, CRACKED ON OTBD SIDE. R & R BRACKET IAW SRM.SDR SWAA2015012736119Skin · crackedFUSELAGE SKIN CRACKED AT BS 727D+14.5, BETWEEN STRINGER 27L TO 27R. REPAIRED SKIN IAW EA.SDR SWAA2014110533811Cover · crackedFORWARD ENTRY DOOR EMER LIGHT COVER CRACKED. R & R COVER IAW SIP.SDR SWAA2014100632662Battery · dischargedLEFT EEPLS INOPERATIVE AT ROW 22. R & R BATTERY IAW AMM.SDR SWAA2014100632661Crease Beam · crackedCREASE BEAM INNER CHORD CRACKED AT STATION 348.2 STRINGER 17L FWD LOWER FASTENER UNDER CLOSURE PANEL. R & R CHORD IAW EA.SDR SWAA2014072130134Mount · crackedR2 DOOR EMER EVAC SLIDE AFT MOUNT CRACKED. R & R MOUNT IAW SRM.SDR SWAA2014010223727Tail Cone · delaminatedAPU TAIL CONE DELAMINATED. R & R TAIL CONE IAW AMM.SDR SWAA2013122023574Stiffener · crackedRT WING AILERON INBD STIFFENER CRACKED. R & R STIFFENER IAW SRM.SDR SWAA2013122023573Door Frame · crackedR1 DOOR FRAME CRACKED AT LOWER AFT CORNER. R & R R1 DOOR IAW MM.SDR SWAA2013110521958Computer · faultyDECLARED EMERGENCY SMOKE EMANATING FROM CAPTAINS RADIO ALTIMETER. R & R B FCC IAW AMM.SDR SWAA2013100820974Light · inoperativeRT OVERWING EXIT SIGN BULBS INOPERATIVE. RELAMPED BULBS IAW AMM.SDR SWAA2013100720878Retainer · brokenRT OVER WING EXIT EMERGENCY LIGHT BULB RETAINERS BROKEN. R & R LIGHT IAW SOPM.SDR SWAA2013100320754Bear Strap · crackedFWD ENTRY DOOR UPPER FWD CORNER SKIN CUTOUT CRACKED IN THE BEAR STRAP. REPAIRED SKIN IAW ATS ER & EA.SDR SWAA2013092320386Angle · crackedLT TE WING INBD NO STEP FWD INBD ANGLE CRACKED. R & R ANGLE IAW SOPM & SRM.SDR SWAA2013100720877Pressure Deck · crackedMAIN WW PRESSURE CRACKED AT BS 665.25 LBL 39.25. REPAIRED DECK IAW EA.SDR SWAA2013100720876Frame · crackedFRAME CRACKED AT BS 727 STRINGER 18A LT SIDE. R & R FRAME IAW SWA EA.SDR SWAA2013100720875Door Frame · crackedFWD CARGO DOOR FWD FRAME CRACKED AT LOWER STOP FITTING UPPER SIDE AT FASTENER HOLE LOCATION. R & R FRAME IAW SRM & DRAWING.SDR SWAA2013092620525Shear Tie · corrodedBS 500 FRAME CORRODED AT BS 500 BETWEEN STRINGER 8R TO STRINGER 27R. R & R SHEAR TIE IAW SRM.SDR SWAA2013092420450Shear Tie · corrodedFRAME CORRODED AT BS 500D, BETWEEN STRINGER 28R TO STRINGER 28L. R & R SHEAR TIE IAW SRM & DRAWING.SDR SWAA2013081519254Lens · missingPASSENGER CABIN FORWARD ENTRY DOOR EMERGENCY EXIT LIGHT LENS MISSING. INSTALLED LENS IAW SIP.SDR SWAA2013062017448Actuator · shearedLT WING I/B SPOILER O/B ACTUATOR ROD END SHEARED. R&R ACTUATOR IAW MM.SDR SWAA2013061717184Sign · missingFORWARD ENTRY EMERGENCY EXIT SIGN MISSING. INSTALLED SIGN IAW MM.SDR SWAA2013050315562Support · crackedE&E COMPARTMENT, FLOORBEAM SUPPORT STRAP CRACKED BETWEEN STA 312 & STA 328, LBL 45. REMOVED AND REPLACED STRAP PER SRM.SDR SWAA2013050315561Support · crackedE&E COMPARTMENT, FLOORBEAM SUPPORT STRAP CRACKED BETWEEN STA 312 & STA 328, LBL 12. REMOVED AND REPLACED STRAP PER SRM.
Back to N620SW, cancelled Nov 15, 2018