N645SW, cancelled Nov 20, 2017
Service difficulty reports · 286
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 = 'N645SW' AND deregistration_id = 'N645SW-2017-11-20' 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 = 'N645SW' AND deregistration_id = 'N645SW-2017-11-20' 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 SWAA2014071430031Lens · missingRIGHT EEPLS LENS MISSING AT ROW. INSTALLED LENS IAW AMM.SDR SWAA2014072130178Frame · crackedFUSELAGE FRAME CHORD CRACKED AT BS 727 STRINGER 18A LT. REPAIRED CHORD IAW ER & EA.SDR SWAA2014072130177Frame · crackedFUSELAGE FRAME OTBD CHORD CRACKED AT BS 727, STRINGER 18A RT. REPAIRED CHORD IAW ER & EA.SDR SWAA2014071630030Skin · crackedEXTERNAL FUSELAGE SKIN CRACKED AT FWD LT CORNER OF AIR CONDITIONER DOOR CUT OUT. REPAIRED CUT OUT IAW SRM.SDR SWAA2014052728378Light · inoperativeLEFT EMERGENCY EXIT LIGHTS AT OVERHEAD BULLNOSE BIN INOPERATIVE BETWEEN ROW 6 TO ROW 22. RELAMPED LIGHTS IAW AMM.SDR SWAA2014052728377Light · inoperativeL2 DOOR EMERGENCY EXIT LIGHT SIGN OVER RT AFT DOOR INOPERATIVE. RELAMPED SIGN IAW AMM.SDR SWAA2014052728376Sign · inoperativeL2 DOOR EXTERIOR EMERGENCY AFT AISLE EXIT SIGN INOPERATIVE. RELAMPED SIGN IAW AMM.SDR SWAA2014052728375Light · inoperativeL1 DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. RELAMPED LIGHTS IAW AMM.SDR SWAA2014051628066Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 460, STRINGER 2R. R & R CLIP IAW DWG.SDR SWAA2014051928133Stringer · crackedSTRINGER CRACKED AT BS 532, STRINGER 4R. REPAIRED STRINGER IAW SB.SDR SWAA2014052728359Buttstrap · crackedBUTT STRAP CRACKED AT BS 360+.5, STRINGER 14R. REPAIRED BUTT STRAP IAW EA.SDR SWAA2014052128194Skin · crackedSKIN CRACKED AT BS 380, STRINGER 14R. REPAIRED SKIN IAW EA.SDR SWAA2014051428012Shear Tie · crackedSHEAR TIE CRACKED AT BS 540, STRINGER 10L. R & R SHEAR TIE IAW SRM & DWG.SDR SWAA2014050827812Skin · crackedLEFT BS 827+10 UPPER AFT WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014050827811Skin · crackedLEFT BS 807+10 UPPER AFT WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014050827810Skin · crackedLEFT BS 767+10 UPPER AFT WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014050827809Skin · crackedRIGHT BS 847+10 UPPER AFT WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014050827808Skin · crackedRIGHT BS 827+10 UPPER AFT WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014050827814Skin · crackedLEFT BS 807+10 LOWER FWD WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014050827813Skin · crackedLEFT BS 767+10 LOWER FWD WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014050727766Skin · crackedLEFT BS 887+10 LOWER FWD WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED SKIN IAW SB.SDR SWAA2014050727765Skin · crackedLEFT BS 827+10 LOWER FWD WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED CUT OUT IAW SB.SDR SWAA2014050727764Skin · crackedLEFT BS 867+10 UPPER AFT WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED CUT OUT IAW SB.SDR SWAA2014050727761Skin · crackedRIGHT BS 767+10 UPPER AFT WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED CUT OUT IAW SB.SDR SWAA2014050727747Skin · crackedRIGHT BS 807+10 LOWER FWD WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED CUT OUT IAW SB.SDR SWAA2014050727746Skin · crackedRIGHT BS 867+10 UPPER AFT WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED CUT OUT IAW EA.SDR SWAA2014050727745Skin · crackedRIGHT BS 807+10 UPPER AFT WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED CUT OUT IAW SB.SDR SWAA2014032026276Lens · brokenRIGHT OVERWING EMERGENCY EXIT SIGN LIGHT LENS COVER BROKEN. R & R LIGHT ASSEMBLY IAW AMM.SDR SWAA2014012324492Skin · crackedLT WING NR 2 SLAT LOWER SURFACE LE CRACKED. REPAIRED NR 2 SLAT IAW SRM.SDR SWAA2014012224423Fairing · damagedRT WING NR 8 FLAP TRACK AFT FAIRING INBD HINGE RELIEF HOLE DAMAGED. REPAIRED FAIRING IAW EA.SDR SWAA2014012224420Flap · delaminatedRT WING OTBD FORE FLAP OTBD END DELAMINATED. R & R FORE FLAP IAW AMM.SDR SWAA2014012224419Fairing · crackedLT ELEVATOR TAB UPPER FAIRING CRACKED. R & R FAIRING IAW DRAWING & SRM.SDR SWAA2014012224418Skin · delaminatedLT WING NR 0 SPOILER UPPER SURFACE DELAMINATED. R & R NR 0 SPOILER IAW AMM.SDR SWAA2013100720803Skin · delaminatedLT WING NR 1 FLIGHT SPOILER TE UPPER SURFACE DELAMINATED. R & R SPOILER IAW MM.SDR SWAA2013090519875Flap · delaminatedLT WING OTBD TE FLAP DELAMINATED. R&R AFT FLAP IAW AMM.SDR SWAA2013081919340Housing · defectiveLT EMERGENCY EXIT LIGHT INOPERATIVE AT ROW 17. R&R LIGHT HOUSING IAW AMM.SDR SWAA2013080718918Light · inoperativeLT WING AFT EMERGENCY LIGHT INOPERATIVE. RELAMPED LIGHT IAW MM.SDR SWAA2013080718917Skin · crackedSKIN CRACKED AT BS 520 + 5, STRINGER 10L. REPAIRED SKIN IAW SRM.SDR SWAA2013070817985Battery · failedAFT EMERGENCY BATTERY PACK FAILED OPERATIONS TEST. R&R BATTERY IAW AMM.SDR SWAA2013062717665Shear Tie · crackedSHEAR TIE CRACKED AT BS 211. R&R SHEAR TIE IAW EA & DRAWING.SDR SWAA2013070817984Frame · damagedFRAME OTBD T CHORD DAMAGED AT STATION 243, STRINGER 17L. R&R T CHORD IAW SRM & DRAWING.SDR SWAA2013070117805Crease Beam · missingCREASE BEAM WEB MISSING BETWEEN STA 235 TO STA 243, STR 17L. INSTALLED WEB IAW SRM AND DWG.SDR SWAA2013070817983Battery · dischargedFWD OTBD EMERGENCY FLASHLIGHT INOPERATIVE. R&R BATTERY IAW MM.SDR SWAA2013052216330Attach Fitting · brokenLT WING NR 4 GROUND SPOILER ATTACH FITTING BROKEN. R & R SPOILER IAW MM.SDR SWAA2013031513693Fire Detector · faultyAIR TURNBACK / DECLARED EMERGENCY. FWD CARGO COMPARTMENT FIRE WARN ALARM SOUNDED. C/W WITH FWD CARGO COMPT INSPECTION. NO DEFECT FOUND. REMOVED AND REPLACED FIRE WARN NR 1, 2, 3 & 4 DETECTORS PER MM.SDR SWAA2013010911319Indicator · faultyDECLARED EMERGENCY -- ON APPROACH SELECTING FLAPS 5, INDICATION STOPPED AT FLAPS 2 DEGREE. SELECTED FLAPS 10 DEGREE, INDICATION REMAINED AT FLAPS 2. SELECTED FLAPS 15 DEGREE, INDICATION REMAINED AT FLAPS 2. AFTER 2-3 MINUTES FLAPS INDICATION WENT TO FLAPS SDR SWAA2012092507954Skin · crackedFUSELAGE CRACKED AT BS 500C+11, STR 10L. REPAIRED SKIN PER EA.SDR SWAA2012071205716Engine · failedINFLIGHT SHUTDOWN/DECLARED EMERGENCY. NR 2 ENGINE ROLLED BACK TO 18 PERCENT N1 AT 34K FLT. NO RESTART ATTEMPT MADE DUE TO SUSPECTED SMOKE REPORTED BY PAX. REMOVED AND REPLACED NR 2 ENGINE PER MM.SDR SWAA2012062505269Lens · brokenL1 DOOR EMERGENCY EXIT LIGHT LENS BROKEN. REMOVED AND REPLACED LENS IAW AMM.SDR SWAA2012062505268Lens · brokenR1 DOOR EMERGENCY EXIT LIGHT LENS BROKEN. REMOVED AND REPLACED LENS IAW AMM.
Back to N645SW, cancelled Nov 20, 2017