N635SW, cancelled Nov 28, 2018
Service difficulty reports · 319
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 = 'N635SW' AND deregistration_id = 'N635SW-2018-11-28' 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 = 'N635SW' AND deregistration_id = 'N635SW-2018-11-28' 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 SWAA2015113046539Reveal · crackedFORWARD GALLEY AREA REVEAL CRACKED AT BS 344 AT AFT LOWER LT. R & R REVEAL IAW SRM.SDR SWAA2015111646102Strap · crackedFORWARD GALLEY AREA STRAP CRACKED AT BS 328, RBL 44. R & R STRAP IAW SRM & DWG.SDR SWAA2015111646101Strap · crackedFORWARD GALLEY AREA STRAP CRACKED AT BS 328, LBL 44. R & R STRAP IAW SRM & DWG.SDR SWAA2015111646100Intercostal · crackedWEB INTERCOSTAL CRACKED, BETWEEN BS 344 - 360, BL 0. R & R INTERCOSTAL IAW SRM.SDR SWAA2015111646091Strap · crackedFORWARD GALLEY AREA STRAP CRACKED AT BS 328, RBL 31. R & R STRAP IAW SRM & DWG.SDR SWAA2015113046580Skin · delaminatedRIGHT WING NR 5 SLAT SKIN DELAMINATED, INBD EDGE. REPAIRED SKIN IAW SRM.SDR SWAA2015120946915Angle · crackedLEFT WING ANGLE CRACKED ON TE AT WBL 183.40. R & R ANGLE IAW SRM & DWG.SDR SWAA2015120946914Skin · crackedRIGHT WING NR 5 SLAT SKIN, CRACKED ON LOWER INBD EDGE. REPAIRED SKIN IAW SRM.SDR SWAA2015113046498Skin · delaminatedRIGHT WING NR 5 SLAT UPPER SKIN DELAMINATED AT OTBD EDGE. REPAIRED SKIN IAW SRM.SDR SWAA2015121147038Support Angle · crackedL1 DOOR SUPPORT ANGLE, CRACKED AFT LOWER EDGE STRUCTURE AT AFT GALLEY AREA. R & R ANGLE IAW SRM & DWG.SDR SWAA2015121147001Angle · crackedENTRY DOOR AFT UPPER EDGE, STRUCTURE ANGLE CRACKED AT FWD GALLEY AREA. R & R ANGLE IAW SRM & DWG.SDR SWAA2015121147000Door Frame · crackedAFT CARGO COMPARTMENT DOOR ASSEMBLY FRAME CRACKED ON LOWER EDGE. R & R DOOR ASSEMBLY IAW AMM.SDR SWAA2015120946913Stiffener · crackedREAR SPAR VERTICAL STIFFENER, CRACKED AT MAIN WW AT BS 663.75, RBL 6.15. R & R STIFFENER IAW ACO.SDR SWAA2015120746766Bracket · crackedBRACKET CRACKED AT BS 727, LOWER FUSELAGE AT LOWER FUSELAGE LT SIDE. R & R BRACKET IAW SRM & DWG.SDR SWAA2015120746765Skin · crackedTAIL CONE EXTERNAL SKIN DELAMINATED AT BS 1156, BL 0. REPAIRED SKIN IAW SRM.SDR SWAA2015123147563Skin · crackedRIGHT WING FIXED LE SKIN CRACKED AT STATION 208. REPAIRED SKIN IAW EA.SDR SWAA2015123147562Skin · crackedLEFT WING FIXED LE SKIN CRACKED AT STATION 208. REPAIRED SKIN IAW EA.SDR SWAA2015122347395Floor Support · crackedLONGITUDINAL FLOORBEAM CRACKED AT STATION 727B, LBL 45.5. REPAIRED BEAM IAW EA.SDR SWAA2015112346245Bulkhead · crackedDOME CAP WEB CRACKED AT BS 1016, LBL 1.5. REPAIRED DOME CAP WEB IAW SRM.SDR SWAA2015111346045Floor Support · crackedCENTER WING BOX, LONGITUDINAL FLOORBEAM, UPPER CHORD CRACKED AT BS 727B, RBL 24.50. REPAIRED CHORD IAW EA.SDR SWAA2015111246012Skin · crackedGROUND AIR HOOK UP DOOR CUT OUT SKIN CRACKED AT BS 520+7, LOWER LT SIDE. REPAIRED SKIN IAW EA.SDR SWAA2015081742892Sign · unsecureRIGHT OVERWING EMER EXIT ROW SIGN FELL OFF. SECURED SIGN IAW AMM.SDR SWAA2015063041221Lens · missingL1 DOOR EMER EXIT LIGHT LENS MISSING. REPLACED LENS IAW MM.SDR SWAA2015031037306Bottle · low pressureR1 DOOR EMER EVAC SLIDE BOTTLE PRESS LOW. R & R SLIDE IAW MT.SDR SWAA2014123035315Lens · looseL1 DOOR ENTRY EMER EXIT LIGHT LENS LOOSE. R & R LIGHT ASSEMBLY IAW MM.SDR SWAA2014052228287Lens · looseLEFT OVERWING EMERGENCY EXIT DOOR LIGHT LENS LOOSE. REPAIRED LENS IAW EA.SDR SWAA2014041427103Slide · out of positionR2 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW MM.SDR SWAA2014032426441Sign · inoperativeINTERIOR EMERGENCY EXIT SIGN LIGHT INOPERATIVE. RELAMPED SIGN ASSEMBLY IAW AMM.SDR SWAA2014032426440Sign · inoperativeLEFT AFT EMERGENCY EXIT SIGN ASSEMBLY INOPERATIVE. R & R SIGN ASSEMBLY IAW AMM.SDR SWAA2014031025900Light · inoperativeLT EMERGENCY LIGHTS INOPERATIVE AT ROW 2. RELAMPED LIGHT IAW MM.SDR SWAA2014031025899Light · inoperativeR1 DOOR EMERGENCY LIGHTS INOPERATIVE AT ROW 2. RELAMPED LIGHT IAW MM.SDR SWAA2014030725854Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 500A, STRINGER 2R. R & R CLIP IAW SRM & DRAWING.SDR SWAA2014030425745Splice · crackedSPLICE CRACKED AT BS 908, STRINGER 4R. R & R SPLICE IAW SRM & DRAWING.SDR SWAA2014030325716Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 400, STRINGER 8L. R & R CLIP IAW SRM & DRAWING.SDR SWAA2014030325715Stringer · damagedSTRINGER DAMAGED AT BS 450, STRINGER 6L. REPAIRED STRINGER IAW SRM.SDR SWAA2014030325714Stringer · damagedSTRINGER DAMAGED AT BS 379, STRINGER 6L. REPAIRED STRINGER IAW SRM.SDR SWAA2014031225988Skin · crackedRT BS 380+10 UPPER FWD WINDOW CORNERS SKIN CUTOUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014031225984Skin · crackedRT BS 400+10 UPPER FWD WINDOW CORNERS SKIN CUTOUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014022425469Forging · crackedLT BS 747+10 WINDOW FORGING CRACKED AT HOLE NR 7. R & R FORGING IAW DRAWING.SDR SWAA2014031225987Skin · crackedRT BS 400+10 UPPER FWD WINDOW CORNER SKIN CUTOUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014031025886Skin · crackedRT BS 500A+10 LOWER AFT WINDOW CORNER SKIN CUTOUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014030725853Skin · crackedRT BS 500C+10 LOWER AFT WINDOW CORNER SKIN CUTOUT CRACKED. REPAIR CUTOUT IAW EA.SDR SWAA2014030725846Skin · crackedRT BS 360+10 LOWER AFT WINDOW CORNER SKIN CUTOUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014030525763Skin · crackedRT BS 380+10 UPPER FWD WINDOW CORNER SKIN CUTOUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014030425744Skin · crackedLT BS 887+10 UPPER AFT WINDOW CORNER SKIN CUTOUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014030425743Skin · crackedRT BS 520+10 LOWER AFT WINDOW CORNER SKIN CUTOUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014030425742Skin · crackedRT BS 520+10 UPPER FWD WINDOW CORNER SKIN CUTOUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014030325713Skin · crackedRT BS 440+10 UPPER FWD WINDOW CORNER SKIN CUTOUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014022725629Skin · crackedLT BS 480+10 UPPER FWD WINDOW CORNER SKIN CUTOUT CRACKED. REPAIRED SKIN IAW SB.SDR SWAA2014022725628Skin · crackedLT BS 460+10 UPPER FWD WINDOW CORNER SKIN CUTOUT CRACKED. REPAIRED SKIN IAW SB.
Back to N635SW, cancelled Nov 28, 2018