N646SW, cancelled Nov 20, 2017
Service difficulty reports · 356
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 = 'N646SW' AND deregistration_id = 'N646SW-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 = 'N646SW' AND deregistration_id = 'N646SW-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 SWAA2016061352808Fitting · crackedLEFT PYLON INTERNAL STRUCTURE ON ACCESS PANEL 5747L CLIP CRACKED. R & R CLIP IAW SRM.SDR SWAA2016072254137Frame · crackedFRAME CRACKED AT BS 500D, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME IAW SRM.SDR SWAA2016071153657Frame · crackedFRAME CRACKED AT BS 500C, BETWEEN STRINGER 20 - 21L. REPAIRED THE FRAME IAW SRM.SDR SWAA2016070753587Screw · corrodedRIGHT EMERGENCY EXIT ESCAPE STRAP HATCH HOOK SCREW CORRODED. R & R THE SCREW IAW DWG.SDR SWAA2016070753586Screw · corrodedLEFT EMERGENCY EXIT ESCAPE STRAP HATCH HOOK SCREW CORRODED. R & R THE SCREW IAW DWG.SDR SWAA2016072554204Bracket · brokenRIGHT EMERGENCY EXIT HATCH FRAME BRACKET BROKEN. R & R BRACKET IAW SRM.SDR SWAA2016040450566Slide · out of positionL1 DOOR EMER EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW MT.SDR SWAA2016031649948Flap · debondedRIGHT WING INBD FORE FLAP DISBONDED. R & R FLAP IAW MM.SDR SWAA2015123147574Lens · brokenR2 DOOR EXIT LIGHT LENS BROKEN. R & R LIGHT ASSEMBLY IAW MM.SDR SWAA2015082443111Cover · looseR1 DOOR EXIT LIGHT COVER LOOSE. R & R BASE ASSEMBLY IAW AMM.SDR SWAA2015070841489Slide · out of positionR1 DOOR SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW MT.SDR SWAA2015061640696Slat · delaminatedLEFT WING NR 2 SLAT DELAMINATED BOTH UPPER INBD & OTBD TE CORNERS. R & R NR 2 SLAT IAW AMM.SDR SWAA2015070941664Slat · delaminatedLEFT WING, NR 2 LEADING SLAT DELAMINATED AT OTBD UPPER CORNER. REPAIRED NR 2 SLAT IAW EA.SDR SWAA2015060240283Slat · delaminatedNUMBER 5 LE SLAT DELAMINATED AT INBD UPPER CORNER. R & R SLAT IAW MM.SDR SWAA2015060240282Slat · delaminatedNUMBER 4 LE SLAT DELAMINATED AT INBD UPPER CORNER. R & R SLAT IAW MM.SDR SWAA2015031237386Battery · dischargedAFT CABIN EMER FLASHLIGHT INOPERATIVE. R&R BATTERY IAW AMM.SDR SWAA2015011235689Wire · brokenLEFT EMER EXIT LIGHT ERRATIC. FOUND WIRE BROKEN, REPAIRED IAW AMM.SDR SWAA2015011235651Wire · brokenRIGHT EMER EXIT LIGHT ERRATIC. FOUND WIRE BROKEN, REPAIRED IAW AMM.SDR SWAA2015011335720Battery Pack · faultyCLIMB OUT FROM MCI FLIGHT ATTENDANT ADVISED THAT ALL EMER LIGHTS FROM OVERWING EXIT AFT WERE ILLUMINATED. FLIGHT DECK SWITCH WAS IN ARMED POSITION & AFT FLIGHT ATTENDANT SWITCH IN NORMAL POSITION. LIGHTS FWD OF OVERWING EXIT REMAINED OFF. R & R BATTERY PACKSDR SWAA2015011335719Connector · not seatedAFT CABIN EMER EXIT LIGHTS CAME ON. COCKPIT EMER EXIT SWITCH IN ARMED POSITION & AFT GALLEY SWITCH OFF. EMERGENCY EXIT LIGHTS IN FWD CABIN REMAINED OFF. RESEATED CONNECTORS AT EMER LIGHT CHARGERS IAW MM.SDR SWAA2015010935587Battery Pack · faultyON CLIMB, ALL EMER LIGHTS FROM OVERWING EXIT AFT WERE ILLUMINATED. FLIGHT DECK SWITCH WAS IN ARMED POSITION & AFT FLIGHT ATTENDANT SWITCH IN NORMAL POSITION. LIGHTS FWD OF OVERWING EXIT REMAINED OFF. R & R BATTERY PACK ASSEMBLY IAW MM.SDR SWAA2014123035313Charger · faultyEMERGENCY EXIT LIGHTS ILLUMINATED IN CABIN DURING APPROACH. R & R BATTERY CHARGER ASSEMBLY IAW MM.SDR SWAA2014120434674Charger · inoperativeAFT EMER LIGHT FAULTY AT BS 727+17, WL 213. R & R BATTERY CHARGER IAW MM.SDR SWAA2014120434651Battery · dischargedEMERGENCY EXIT LIGHTS FAULTY. R & R BATTERY IAW MM.SDR SWAA2014103133580Panel · delaminatedNUMBER 6 SPOILER PANEL DELAMINATED. R & R SPOILER ASSEMBLY IAW MM.SDR SWAA2014102233308Lens · brokenFORWARD LT ESCAPE SLIDE LIGHT LENS BROKEN. R & R LENS ASSEMBLY IAW AMM.SDR SWAA2014102233306Buttstrap · crackedBUTT STRAP CRACKED AT BS 360 STRINGER 14L. REPAIRED BUTT STRAP IAW EA.SDR SWAA2014102233305Stringer · crackedSTRINGER CRACKED AT BS 375 STRINGER 14L. REPAIRED STRINGER IAW SRM.SDR SWAA2014102233227Skin · crackedSKIN CRACKED AT BS 381 STRINGER 14L. REPAIRED SKIN IAW EA.SDR SWAA2014100232564Shear Tie · crackedSHEAR TIE CRACKED AT BS 360 BETWEEN STRINGER 14L TO 15L. R & R SHEAR TIE IAW DWG.SDR SWAA2014101432924Skin · crackedSKIN CRACKED WRINKLED AT BS 360 BETWEEN STRINGER 3L TO 3R. REPAIRED SKIN IAW EA.SDR SWAA2014092932361Buttstrap · crackedBUTT STRAP CRACKED AT BS 360 STRINGER 14R. REPAIRED BUTT STRAP IAW EA.SDR SWAA2014082131062Metering Valve · faultyUPON LANDING FIRST OFFICERS BRAKE PEDALS PUSHED ALL THE WAY TO THE FLOOR. ON TAXI IN RECHECKED FIRST OFFICER'S BRAKES LT SIDE HELD, RT SIDE TO THE FLOOR WITH A SHUDDER KICK BACK. R & R RT BRAKES ALTERNATE METERING VLV IAW MM.SDR SWAA2014080130551Valve · leakingDECLARED EMER, A SYS HYD FAILURE. R & R VLV IAW MM.SDR SWAA2014072330252Slide · out of positionL1 DOOR EMER EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW MM.SDR SWAA2014070329626Skin · crackedRIGHT WING SKIN CRACKED AT NR 6 SLAT AUXILIARY TRACK CUT OUT. REPAIRED SKIN IAW SRM.SDR SWAA2014062329329Angle · crackedLEFT WING TE ANGLE CRACKED AT WBL 533. R & R ANGLE IAW SRM & DWG.SDR SWAA2014062029239Angle · crackedRIGHT WING ANGLE TE CAVITY INTERIOR RSS 545 CRACKED. R & R ANGLE IAW SRM & DWG.SDR SWAA2014061929217Bearing · crackedRIGHT WING NR 7 FRAME BEARING CRACKED. R & R BEARING IAW CMM.SDR SWAA2014062429353Flap · delaminatedLEFT WING OTBD FORE FLAP DELAMINATED. REPAIRED FORE FLAP IAW SRM.SDR SWAA2014070129550Frame · corrodedFUSELAGE FRAME CORRODED AT STATION 500C, BETWEEN STRINGER 28L & 28R. REPAIRED FRAME IAW SRM.SDR SWAA2014061929208Shear Tie · corrodedSHEAR TIE CORRODED AT BS 500D, BETWEEN STRINGER 27R TO 28R. R & R SHEAR TIE IAW SRM & DWG.SDR SWAA2014062629428Stiffener · crackedAFT PRESS BULKHEAD STIFFENER CRACKED AT STATION 1066, BETWEEN STRINGER 15R & 21R. REPAIRED STIFFENER IAW EA.SDR SWAA2014061929207Skin · crackedRIGHT WING LE SKIN AT KRUEGER FLAP CRACKED AT STATION 208. REPAIRED SKIN IAW EA.SDR SWAA2014062429352Rib · crackedRIGHT WING LOWER RIB CHORD CRACKED AT WBL 135.5, BETWEEN STRINGER 2 TO 3. REPAIRED CHORD IAW EA.SDR SWAA2014062429351Skin · crackedLEFT WING NR 3 SLAT SKIN CRACKED ON EXTERNAL LOWER SURFACE AT SLAT STATION 90.5. REPAIRED SKIN IAW SRM.SDR SWAA2014061829167Bracket · crackedBRACKET CRACKED AT BS 670, RBL 32. R & R BRACKET IAW SRM & DWG.SDR SWAA2014070229590Skin · crackedRIGHT WING LE SKIN CRACKED AT NR 6 SLAT CUT OUT. REPAIRED SKIN IAW SRM & EA.SDR SWAA2014070129547Skin · crackedRIGHT WING LE SLAT AT NR 6 ACTUATOR LOWER SKIN CRACKED. REPAIRED SKIN IAW SRM.SDR SWAA2014062329322Bulkhead · crackedAFT PRESS BULKHEAD WEB CRACKED AT BS 1016, RBL 4. REPAIRED WEB IAW SRM.
Back to N646SW, cancelled Nov 20, 2017