N316SW, cancelled Sep 10, 2012
Service difficulty reports · 452
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 = 'N316SW' AND deregistration_id = 'N316SW-2012-09-10' 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 = 'N316SW' AND deregistration_id = 'N316SW-2012-09-10' 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 SWAA095885Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500B, STR 20R TO STR 21R. REPAIRED FRAME PER ER.SDR SWAA095884Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 21L. REPAIRED FRAME PER ER.SDR SWAA095883Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500D, STR 20L TO STR 21L. REPAIRED FRAME PER ER.SDR SWAA095882Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, LBL 19, WL 155. REPAIRED FRAME PER ER.SDR SWAA095881Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500B, STR 20L TO STR 21L. REPAIRED FRAME PER ER.SDR SWAA095880Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 13R. REPAIRED FRAME PER ER.SDR SWAA095841Stringer Splice · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER SPLICE CRACKED AT BS 663, STR 8L. REMOVED AND REPLACED SPLICE PER BAC DWG.SDR SWAA095840Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME WEB CRACKED AT BS 500C, BETWEEN STR 20L TO STR 21L. REMOVED AND REPLACED WEB PER SRM.SDR SWAA095839Stringer · corrodedDURING SCHEDULED 24Y CHECK, FOUND STRINGER SECTION CORRODED AT BS 1008, STR 27L. REMOVED AND REPLACED STRINGER SECTION PER SRM.SDR SWAA095838Keelbeam · corrodedDURING SCHEDULED 24Y CHECK, FOUND FWD CARGO BAY RT KEEL BEAM CORRODED AT BS 500D, RBL 7. REMOVED AND REPLACED BEAM PER SRM.SDR SWAA095837Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 500A, BETWEEN RBL 8 TO RBL 15. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA095816Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME WEB CRACKED AT BS 639, LBL 65. REPAIRED FRAME PER ER.SDR SWAA095815Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND CENTER WING BOX FLOORBEAM CHORD CRACKED AT BS 663, LBL 24.8. REPAIRED BEAM PER ER.SDR SWAA095814Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FWD CARGO BAY FRAME CRACKED AT BS 500D, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER ER.SDR SWAA095813Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND SKIN CRACKED AT BS 908, BETWEEN STR 3L TO STR 4L. REPAIRED SKIN PER ER.SDR SWAA095812Wire · brokenDURING SCHEDULED 24Y CHECK, FOUND CENTER AISLE EMERGENCY EXIT LIGHT WIRE BROKEN. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA095734Flap · delaminatedDURING SCHEDULED 24Y CHECK, FOUND LT WING I/B AFT FLAP T/E DELAMINATED. REPAIRED AFT FLAP PER SRM.SDR SWAA095733Lug · brokenDURING SCHEDULED 24Y CHECK, FOUND LT WING NR 4 SPOILER O/B ACTUATOR LOWER LUG BROKEN. REMOVED AND REPLACED ACTUATOR PER MM.SDR SWAA095732Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME WEB CRACKED AT BS 259.5, STR 11L. REPAIRED WEB PER SRM.SDR SWAA095731Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 578, STR 8L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA095662Beam · crackedDURING SCHEDULED 24Y CHECK, FOUND STUB BEAM WEB CRACKED AT BS 639, LBL 65. REPAIRED WEB PER ER.SDR SWAA095659Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500B, STR 8R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA095647Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND SKIN CRACKED AT BS 908, BETWEEN STR 4R TO STR 6R. REPAIRED SKIN PER ER.SDR SWAA095646Fitting · corrodedDURING SCHEDULED 24Y CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR CLIP CORRODED. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA095589Flap · delaminatedDURING SCHEDULED 24Y CHECK, FOUND LT WING O/B AFT FLAP T/E DELAMINATED. REPAIRED AFT FLAP PER SRM.SDR SWAA095588Shear Tie · crackedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CRACKED AT BS 947, BETWEEN STR 23L TO STR 24L. REPAIRED SHEAR TIE PER SRM.SDR SWAA095564Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 747, BETWEEN STR 26L TO STR 27L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA095541Rib · corrodedDURING SCHEDULED 24Y CHECK, FOUND RT WING I/B MID FLAP RIB CORRODED. REMOVED AND REPLACED RIB PER SRM.SDR SWAA095540Rib · corrodedDURING SCHEDULED 24Y CHECK, FOUND LT WING I/B MID FLAP RIB CORRODED. REMOVED AND REPLACED RIB ASSY PER BAC DWG.SDR SWAA095539Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 380, STR 19L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA095538Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 747, BETWEEN STR 25L TO STR 26L. REPAIRED SHEAR TIE PER SRM.SDR SWAA095537Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 480, BETWEEN LBL 16 TO LBL 21. REPAIRED SHEAR TIE PER SRM.SDR SWAA095531Wedge · puncturedDURING SCHEDULED 24Y CHECK, FOUND LT WING I/B MIDFLAP T/E WEDGE PUNCTURED. REPAIRED WEDGE PER SRM.SDR SWAA095530Sign · brokenDURING SCHEDULED 24Y CHECK, FOUND R2 DOOR SIDEWALL EMERGENCY EXIT SIGN BROKEN. REMOVED AND REPLACED SIGN PER SOPM.SDR SWAA095529Sign · brokenDURING SCHEDULED 24Y CHECK, FOUND SIDEWALL EMERGENCY EXIT SIGNS BROKEN AT ROW 9. REMOVED AND REPLACED SIGNS PER SRM.SDR SWAA095357Crease Beam · crackedDURING SCHEDULED 24Y CHECK, FOUND CREASE BEAM WEB CRACKED BETWEEN BS 188 TO BS 196.5, STR 17L. REMOVED AND REPLACED WEB PER SRM.SDR SWAA095319Angle · crackedDURING SCHEDULED 24Y CHECK, FOUND ANGLE CRACKED AT BS 727B, LBL 46. REPAIRED ANGLE PER SRM.SDR SWAA095279Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 188, STR 17R. REPAIRED FRAME PER SRM.SDR SWAA095275Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 559, STR 8L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA095274Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500C, STR 26R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA095273Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 663, STR 8L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA095272Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 908, BETWEEN STR 22R TO STR 23R. REPAIRED FRAME PER SRM.SDR SWAA095215Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, STR 8R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA095191Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND STUB FRAME CHORD CRACKED AT BS 190, WL 207 LT SIDE. REPAIRED CHORD PER SRM.SDR SWAA095179Support Channel · corrodedDURING SCHEDULED 24Y CHECK, FOUND RT BULKHEAD SUPPORT CHANNEL CORRODED AT BS 1017, BL 0. REMOVED AND REPLACED CHANNEL PER SRM.SDR SWAA095086Attach Fitting · corrodedDURING SCHEDULED 24Y CHECK, FOUND LT WING NR 2 FLAP TRACK CARRIAGE FORE FLAP ATTACH FITTING CORRODED. REMOVED AND REPLACED FITTING PER OHM.SDR SWAA095085Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 685, STR 3R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094978Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 685, STR 7R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094977Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 578, STR 9L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA094976Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, STR 4L. REMOVED AND REPLACED CLIP PER SRM.
Back to N316SW, cancelled Sep 10, 2012