N658SW, cancelled Mar 15, 2018
Service difficulty reports · 512
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 = 'N658SW' AND deregistration_id = 'N658SW-2018-03-15' 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 = 'N658SW' AND deregistration_id = 'N658SW-2018-03-15' 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 SWAA093389Stringer · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CRACKED AT BS 504C, STR 16L. REPAIRED STRINGER PER ER.SDR SWAA093388Shear Tie · corrodedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CORRODED AT BS 827, STR 17R. R&R SHEAR TIE PER SRM.SDR SWAA093336Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 9R. R&R CLIP PER SRM.SDR SWAA093335Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 8R. R&R CLIP PER SRM.SDR SWAA093334Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 597, STR 10R. R&R CLIP PER SRM.SDR SWAA093333Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 6R. R&R CLIP PER SRM.SDR SWAA093332Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 3R. R&R CLIP PER SRM.SDR SWAA093331Shear Tie · corrodedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CORRODED AT BS 947, BETWEEN STR 19R TO STR 20R. REPAIRED SHEAR TIE PER SRM.SDR SWAA093325Stringer · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CRACKED AT BS 412, STR 24R. REPAIRED STRINGER PER SRM.SDR SWAA093297Stringer · corrodedDURING SCHEDULED SPV CHECK, FOUND STRINGER CORRODED BETWEEN BS 860 TO BS 867, STR 20R. R&R STRINGER PER SRM.SDR SWAA093274Stringer · corrodedDURING SCHEDULED SPV CHECK, FOUND STRINGER CORRODED AT BS 908, STR 21R. REPAIRED STRINGER PER SRM.SDR SWAA093273Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 500, STR 16L. REPAIRED CLIP PER SRM.SDR SWAA093272Stringer · corrodedDURING SCHEDULED SPV CHECK, FOUND STRINGER CORRODED AT BS 475, STR 28R. REPAIRED STRINGER PER SRM.SDR SWAA093271Flap · delaminatedDURING SCHEDULED SPV CHECK, FOUND LT WING O/B FORE FLAP DELAMINATED. REPAIRED FORE FLAP PER SRM.SDR SWAA093270Stringer · corrodedDURING SCHEDULED SPV CHECK, FOUND STRINGER CORRODED AT BS 944, STR 25L. REPAIRED STRINGER PER SRM.SDR SWAA093269Stringer · corrodedDURING SCHEDULED SPV CHECK, FOUND STRINGER CORRODED AT BS 914, STR 21L. REPAIRED STRINGER PER SRM.SDR SWAA093268Stringer · corrodedDURING SCHEDULED SPV CHECK, FOUND STRINGER CORRODED AT BS 460, STR 27R. R&R STRINGER PER SRM.SDR SWAA093267Keelbeam · corrodedDURING SCHEDULED SPV CHECK, FOUND LT KEEL BEAM CORRODED AT BS 731, STR 27L. REPAIRED BEAM PER SRM.SDR SWAA093185Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, STR 5L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA093184Crease Beam · corrodedDURING SCHEDULED SPV CHECK, FOUND CREASE BEAM CORRODED AT BS 865, LBL 65, WL 208. REPAIRED BEAM PER SRM.SDR SWAA093144Frame · corrodedDURING SCHEDULED SPV CHECK, FOUND FAIL SAFE CHORD FRAME CORRODED AT BS 927, STR 19L. REPAIRED FRAME PER SRM.SDR SWAA093136Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME WEB CRACKED AT BS 303. REPAIRED FRAME PER ACO.SDR SWAA093135Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 440, STR 18L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA093134Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 420, STR 18L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA093133Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 400, STR 18L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA093132Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 500B, STR 15L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA093131Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 500D, STR 15L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA093130Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 500B, BETWEEN STR 15R TO STR 16R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA093068Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 6L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA093067Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 380, STR 15L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA093066Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 787, STR 10L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA093065Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 767, STR 10L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA093064Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727E, STR 7L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA093063Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 7R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA093062Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 578 STR 8R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA093061Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 597 STR 7R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA093060Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 9R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA093059Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 8R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA093058Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 5R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA093057Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 2R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA093056Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 8R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA093055Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 7R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA093054Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 6R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA093053Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 5R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA093052Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 747, STR 4L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA093051Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 5L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA093050Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 6L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA093049Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 3L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA093010Stringer · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CRACKED AT BS 380, STR 15L. REMOVED AND REPLACED STRINGER PER SRM.SDR SWAA093009Bulkhead · crackedDURING SCHEDULED SPV CHECK, FOUND BS 178 BULKHEAD UPPER CHORD CRACKED AT WL 135, LBL 24. REMOVED AND REPLACED CHORD PER BAC DWG.
Back to N658SW, cancelled Mar 15, 2018