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 SWAA2014022725627Skin · crackedLT BS 460+10 LOWER AFT WINDOW CORNER SKIN CUTOUT CRACKED. REPAIRED SKIN IAW SB.SDR SWAA2014022725626Skin · crackedLT BS 440+10 LOWER AFT WINDOW CORNER SKIN CUTOUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014022725625Skin · crackedLT BS 400+10 LOWER AFT WINDOW CORNER SKIN CUTOUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014022725624Skin · crackedLT BS 380+10 LOWER AFT WINDOW CORNER SKIN CUTOUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014022825673Skin · crackedFUSELAGE SKIN CRACKED AT LT STATION 877, LOWER FWD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SWA EA.SDR SWAA2014022825672Skin · crackedFUSELAGE SKIN CRACKED AT RT STATION 530, UPPER FWD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SWA EA.SDR SWAA2014022825671Skin · crackedFUSELAGE SKIN CRACKED AT LT STATION 410, UPPER FWD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SWA EA.SDR SWAA2014022825670Skin · crackedFUSELAGE SKIN CRACKED AT RT STATION 470, UPPER FWD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SWA EA.SDR SWAA2014022825669Skin · crackedFUSELAGE SKIN CRACKED AT RT STATION 430, UPPER FWD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SWA EA.SDR SWAA2014022625578Skin · crackedLT BS 847+10 LOWER FWD WINDOW CORNER CUTOUT CRACKED. REPAIRED CUTOUT IAW SB.SDR SWAA2014022625577Skin · crackedLT BS 807+10 LOWER FWD WINDOW CORNER CUTOUT CRACKED. REPAIRED CUTOUT IAW SB.SDR SWAA2014022625576Skin · crackedLT BS 787+10 LOWER FWD WINDOW CORNER CUTOUT CRACKED. REPAIRED CUTOUT IAW SB.SDR SWAA2014022625575Skin · crackedLT BS 767+10 LOWER FWD WINDOW CORNER CUTOUT CRACKED. REPAIRED CUTOUT IAW SB.SDR SWAA2014022625574Skin · crackedLT BS 867+10 UPPER AFT WINDOW CORNER CUTOUT CRACKED. REPAIRED CUTOUT IAW SB.SDR SWAA2014022625573Skin · crackedLT BS 500C +10 UPPER FWD WINDOW CORNER CUTOUT CRACKED. REPAIRED CUTOUT IAW SB.SDR SWAA2014022625572Skin · crackedLT BS 500B+10 UPPER FWD WINDOW CORNER CUTOUT CRACKED. REPAIRED CUTOUT IAW SB.SDR SWAA2014022625571Skin · crackedRT BS 500 +10 UPPER FWD WINDOW CORNER CUTOUT CRACKED. REPAIRED CUTOUT IAW SB.SDR SWAA2014022625569Skin · crackedLT BS 440 +10 UPPER FWD WINDOW CORNER CUTOUT CRACKED. REPAIRED CUTOUT IAW EA.SDR SWAA2014022625568Skin · crackedLT BS 500A+10 LOWER AFT WINDOW CORNER CUTOUT CRACKED. REPAIRED CUTOUT IAW SB.SDR SWAA2014022625567Skin · crackedRT BS 500B+10 LOWER AFT WINDOW CORNER CUTOUT CRACKED. REPAIRED CUTOUT IAW SB.SDR SWAA2014022625566Skin · crackedRT BS 500+10 LOWER AFT WINDOW CORNER CUTOUT CRACKED. REPAIRED CUTOUT IAW SB.SDR SWAA2014022625565Skin · crackedRT BS 440+10 LOWER AFT WINDOW CORNER CUTOUT CRACKED. REPAIRED CUTOUT IAW SB.SDR SWAA2014022625564Skin · crackedRT BS 380+10 LOWER AFT WINDOW CORNER CUTOUT CRACKED. REPAIRED CUTOUT IAW EA.SDR SWAA2014022425506Skin · crackedLT BS 887+10 UPPER AFT WINDOW CORNER CUTOUT CRACKED. REPAIRED CUTOUT IAW EA.SDR SWAA2014031025885Lens · missingOVERWING EMERGENCY EXIT LIGHT LENS MISSING. INSTALLED LENS IAW AMM.SDR SWAA2013120523038Fuse · inoperativeRT BATTERY CHARGER FUSES INOPERATIVE. R & R FUSES IAW MM.SDR SWAA2013120523051Rib · crackedLT WING RIB LOWER CHORD AT WBL 135.5 CRACKED ON AFT END BETWEEN STRINGER 2 & STRINGER 3. REPAIRED CHORD IAW EA.SDR SWAA2013120923111Skin · crackedFUSELAGE SKIN CRACKED BETWEEN BS 794.5 TO BS 796.25, STRINGER 10R. REPAIRED SKIN IAW EA.SDR SWAA2013112722806Frame · corrodedFUSELAGE FRAME CORRODED AT BS 907, BL 0, WL 164. REPAIRED FRAME IAW SRM.SDR SWAA2013112722805Pressure Panel · crackedMLG WW PRESS WEB CRACKED AT BS 665, LBL 31. REPAIRED WEB IAW SRM.SDR SWAA2013121123133Skin · crackedRT NLG WW SKIN CRACKED AT BS 258.5, APPROXIMATELY 8 INCHES DOWN FROM THE TOP OF THE DOUBLER, JUST UNDER THE FWD EDGE OF THE DOUBLER. REPAIRED SKIN IAW EA.SDR SWAA2013072418536Skin · crackedSKIN CRACKED AT STATION 767+8, STRINGER 10R. REPAIRED SKIN IAW EA.SDR SWAA2013072418535Skin · crackedSKIN CRACKED AT STATION 727G+10, STRINGER 10R. REPAIRED SKIN IAW EA.SDR SWAA2013072218436Flap · delaminatedRT WING OTBD AFT FLAP DELAMINATED. R&R AFT FLAP IAW AMM.SDR SWAA2013052816531Lens · looseFORWARD ENTRY EMERGENCY EXIT SIGN COVER LOOSE. R & R LENS IAW MM.SDR SWAA2013021812739Wire · disconnectedFOUND FWD GALLEY RIGHT SLIDE EMERGENCY LIGHT INOP. FOUND WIRES DISCONNECTED DISPLACED FWD GALLEY FOM RESTORED WIRES REINSTALLED FWD GALLEY PER MM OPS CHECK EMERGENCY LIGHT CHECK GOOD.SDR SWAA2013021112526Snubber · out of positionCREW REPORTS GALLEY DOOR HITS FUSELAGE WHEN OPENED. R & R SNUBBER IAW SRM MM.SDR SWAA2013020812453Lens · looseFORWARD ENTRY DOOR MISSING FWD EMERGENCY LIGHT LENS LOOSE. ADJUSTED PER AMMSDR SWAA2012102308723Sign · looseRIGHT EMERGENCY EXIT SIGN LOOSE. SECURED SIGN PER MM.SDR SWAA2012101908661Sign · looseRIGHT OVERWING EMERGENCY EXIT SIGN LOOSE. SECURED SIGN PER MM.SDR SWAA2012071905984Pressure Panel · crackedRIGHT WHEEL WELL BEADED WEB CRACKED AT BS 663. REPAIRED WEB IAW SRM & EA.SDR SWAA2012071605855Slide · out of adjustR2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. RE-ADJUSTED SLIDE IAW MT.SDR SWAA1201134Lens · missingRIGHT EMERGENCY SIDE MISSING EXIT SIGN. RE-INSTALLED LENS PER MM. (SUBMITTED AS A SUPPLEMENT, COULDN`T FIND ORIGINAL CONTROL NUMBER.)SDR SWAA120537Skin · crackedDURING SCHEDULED 16Y CHECK, FOUND SKIN CRACKED BETWEEN BS 312 TO BS 337, BETWEEN STR 15R TO STR 18R. REPAIRED SKIN IAW SRM.SDR SWAA120536Fitting · crackedDURING SCHEDULED 16Y CHECK, FOUND ATTACHMENT CLIP CRACKED AT BS 639, RBL 45.5. REMOVED AND REPLACED CLIP IAW EA.SDR SWAA120532Skin · crackedDURING SCHEDULED 16Y CHECK, FOUND SKIN CRACKED AT BS 379, STR 28L. REPAIRED SKIN IAW EA.SDR SWAA120531Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 1006, BETWEEN STR 20R TO STR 22R. REPAIRED FRAME IAW EO.SDR SWAA120528Floorbeam · crackedDURING SCHEDULED 16Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 670, RBL 24.5. REPAIRED CHORD IAW EO AND EA.SDR SWAA120527Floorbeam · crackedDURING SCHEDULED 16Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED BETWEEN BS 666 TO BS 670, LBL 24.5. REPAIRED CHORD IAW EO AND EA.SDR SWAA120526Skin · crackedDURING SCHEDULED 16Y CHECK, FOUND LT FUSELAGE SKIN CRACKED AT BS 213.8 WINDSHIELD UPPER AREA. REPAIRED SKIN IAW EA.
Back to N635SW, cancelled Nov 28, 2018