N688SW, cancelled Nov 16, 2012
Service difficulty reports · 306
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 = 'N688SW' AND deregistration_id = 'N688SW-2012-11-16' 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 = 'N688SW' AND deregistration_id = 'N688SW-2012-11-16' 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 SWAA092203Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 947, STR 24R. REPAIRED SKIN PER SWA EA.SDR SWAA091389Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 447, STR 16R. REPAIRED SKIN PER SWA EA.SDR SWAA091388Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 486, STR 16R. REPAIRED SKIN PER SWA EA.SDR SWAA090560Bracket · looseDURING SCHEDULED HC1 CHECK, FOUND L1 DOOR EMERGENCY EVACUATION SLIDE COVER FWD GIRT BAR ATTACH BRACKET LOOSE. SECURED BRACKET PER MM.SDR SWAA084711Skin · delaminatedDURING SCHEDULED 24Y CHECK, FOUND LT WING OUTBOARD T/E FLAP DELAMINATED AT INBOARD END. REMOVED AND REPLACED FLAP PER MM.SDR SWAA084710Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 787, STR 27R. REPAIRED SHEAR TIE PER SRM.SDR SWAA084673Slide · low pressureDURING SCHEDULED 24Y CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE PRESSURE GAUGE INDICATED OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE PER MM.SDR SWAA084640Light · crackedDURING SCHEDULED 24Y CHECK, FOUND R2 DOOR EMERGENCY EXIT LIGHT ASSY CRACKED. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA084619Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 939, STR 9R. REPAIRED FRAME PER SRM.SDR SWAA084618Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 188, STR 17R. REPAIRED FRAME PER SRM.SDR SWAA084617Light · brokenDURING SCHEDULED 24Y CHECK, FOUND L1 DOOR EMERGENCY EXIT LIGHT BROKEN. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA084600Fitting · crackedDURING SCHEDULED 24Y CHECK, FOUND LT WING NR 4 SPOILER OUTBOARD LUG FITTING CRACKED. REPAIRED FITTING PER SWA EA.SDR SWAA084599Crease Beam · crackedDURING SCHEDULED 24Y CHECK, FOUND CREASE BEAM WEB CRACKED AT BS 188, STR 17L. REPAIRED WEB PER SRM.SDR SWAA084598Crease Beam · crackedDURING SCHEDULED 24Y CHECK, FOUND CREASE BEAM WEB CRACKED AT BS 188, STR 17R. REPAIRED WEB PER SRM.SDR SWAA084570Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 767, BETWEEN STR 25L AND STR 27L. REPAIRED FRAME PER SRM.SDR SWAA084569Lens · crackedDURING SCHEDULED 24Y CHECK, FOUND R1 DOOR EMERGENCY EXIT LIGHT LENS CRACKED. REMOVED AND REPLACED LIGHT LENS PER MM.SDR SWAA084521Stringer Splice · corrodedDURING SCHEDULED 24Y CHECK, FOUND STRINGER SPLICE CORRODED AT BS 360, STR 28L. REPAIRED SPLICE PER SRM.SDR SWAA084520Stringer Splice · corrodedDURING SCHEDULED 24Y CHECK, FOUND STRINGER SPLICE CORRODED AT BS 380, STR 28L. REPAIRED SPLICE PER SRM.SDR SWAA084519Stringer Splice · corrodedDURING SCHEDULED 24Y CHECK, FOUND STRINGER SPLICE CORRODED AT BS 380, STR 27L. REPAIRED SPLICE PER SRM.SDR SWAA084518Stringer Splice · corrodedDURING SCHEDULED 24Y CHECK, FOUND STRINGER SPLICE CORRODED AT BS 360, STR 27L. REPAIRED SPLICE PER SRM.SDR SWAA084503Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 559, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA084502Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 887, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA084501Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA084444Bulkhead · crackedDURING SCHEDULED 24Y CHECK, FOUND BULKHEAD FWD SIDE CRACKED AT BS 1016, STR 6R. REPAIRED BULKHEAD PER SRM.SDR SWAA084443Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 277, STR 10R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA084442Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 639, STR 17R. REPAIRED FRAME PER SRM.SDR SWAA084441Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 706, STR 10R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA084440Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 685, STR 4R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA084439Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 716, STR 4R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA084438Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, STR 14L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA084437Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 716, STR 10L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA084436Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 460, STR 28R. REPAIRED FRAME PER SRM.SDR SWAA084435Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 500, STR 28R. REPAIRED FRAME PER SRM.SDR SWAA084434Shear Tie · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE SHEAR TIE CRACKED AT BS 380, STR 15L. REPAIRED SHEAR TIE PER SRM.SDR SWAA084426Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 986, STR 25L. REPAIRED SHEAR TIE PER SRM.SDR SWAA084394Stringer · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER 15L CRACKED AT BS 380. REPAIRED STRINGER PER SRM.SDR SWAA084393Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND RT WING NR 4 L/E SLAT CRACKED AT INBOARD END. REPAIRED SLAT PER SRM.SDR SWAA084308Cable · misroutedDURING SCHEDULED 24Y CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE CABLE MISROUTED. REROUTED CABLE PER MM.SDR SWAA084237Bulkhead · crackedDURING SCHEDULED 24Y CHECK, FOUND AFT PRESSURE BULKHEAD WEB CRACKED AT BS 1016, STR 6R. REPAIRED WEB PER SRM.SDR SWAA084236Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 887, STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA084235Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 344, STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA084234Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 460, STR 28R TO STR 28L. REPAIRED FRAME PER SRM.SDR SWAA084159Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 380, STR 7R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA084072Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA084090Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA084091Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA084097Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA084093Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 559, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA084096Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA084092Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME PER SWA EA.
Back to N688SW, cancelled Nov 16, 2012