N384SW, cancelled Aug 3, 2018
Service difficulty reports · 368
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 = 'N384SW' AND deregistration_id = 'N384SW-2018-08-03' 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 = 'N384SW' AND deregistration_id = 'N384SW-2018-08-03' 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 SWAA103002Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 787, BETWEEN STR 27R TO STR 26R. REPAIRED FRAME PER SRM.SDR SWAA103001Channel · corrodedDURING SCHEDULED 16Y CHECK, FOUND AFT CARGO COMPT CHANNEL CORRODED AT BS 794, LBL 8.10. REPAIRED CHANNEL PER EA.SDR SWAA103000Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 767, BETWEEN STR 27R TO STR 27L. REPAIRED FRAME PER SRM.SDR SWAA102987Floorbeam · crackedDURING SCHEDULED 16Y CHECK, FOUND FLOORBEAM UPPER CHORD CRACKED AT BS 670, LBL 23. REPAIRED BEAM PER AEM.SDR SWAA102986Floorbeam · crackedDURING SCHEDULED 16Y CHECK, FOUND FLOORBEAM UPPER CHORD CRACKED AT BS 670, LBL 24.5. REPAIRED BEAM PER AEM.SDR SWAA102985Channel · corrodedDURING SCHEDULED 16Y CHECK, FOUND AFT CARGO COMPT CHANNEL CORRODED AT BS 751, RBL 3. REPAIRED CHANNEL PER EA.SDR SWAA102977Channel · corrodedDURING SCHEDULED 16Y CHECK, FOUND AFT CARGO COMPT CHANNEL CORRODED AT BS 813.5, RBL 3. REPAIRED CHANNEL PER EA.SDR SWAA102955Keelbeam · corrodedDURING SCHEDULED 16Y CHECK, FOUND KEEL BEAM CORRODED AT BS 522, STR 28L. REPAIRED BEAM PER AEM.SDR SWAA102954Floorbeam · crackedDURING SCHEDULED 16Y CHECK, FOUND FLOORBEAM CRACKED AT BS 727B, LBL 24.8. REPAIRED BEAM PER AEM.SDR SWAA102953Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 907, BETWEEN STR 27L TO STR 27R. REPAIRED FRAME PER SRM.SDR SWAA102952Channel · corrodedDURING SCHEDULED 16Y CHECK, FOUND AFT CARGO FLOOR CHANNEL CORRODED BETWEEN BS 860 TO BS 860.5, BETWEEN STR 27R TO STR 27L. REPAIRED CHANNEL PER EA.SDR SWAA102951Floorbeam · corrodedDURING SCHEDULED 16Y CHECK, FOUND FLOORBEAM CORRODED AT BS 845.5, BETWEEN STR 26R TO STR 27R. REPAIRED BEAM PER EA.SDR SWAA102950Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 787, BETWEEN STR 27L TO STR 27R. REPAIRED FRAME PER SRM.SDR SWAA102927Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND AFT CARGO FRAME CORRODED AT BS 733D, LBL 8.10. REPAIRED FRAME PER EA.SDR SWAA102926Channel · corrodedDURING SCHEDULED 16Y CHECK, FOUND AFT CARGO COMPT CHANNEL CORRODED AT BS 733, LBL 8.10. REPAIRED CHANNEL PER EA.SDR SWAA102925Channel · corrodedDURING SCHEDULED 16Y CHECK, FOUND AFT CARGO COMPT CHANNEL CORRODED AT BS 729.5B, LBL 3. REPAIRED CHANNEL PER EA.SDR SWAA102924Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND AFT CARGO COMPT FRAME CORRODED AT BS 500C, BETWEEN STR 28L TO STR 28R. REPAIRED FRAME PER SRM.SDR SWAA102923Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND AFT CARGO COMPT FRAME CORRODED AT BS 500, BETWEEN STR 28L TO STR 28R. REPAIRED FRAME PER SRM.SDR SWAA102922Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND AFT CARGO COMPT FRAME CORRODED AT BS 500A, BETWEEN STR 1 TO STR 28L. REPAIRED FRAME PER SRM.SDR SWAA102921Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 500B, BETWEEN STR 1 TO STR 28L. REPAIRED FRAME PER SRM.SDR SWAA102920Floorbeam · crackedDURING SCHEDULED 16Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 727B, RBL 24.8. REPAIRED BEAM PER AEM.SDR SWAA102919Channel · corrodedDURING SCHEDULED 16Y CHECK, FOUND AFT CARGO COMPT CHANNEL CORRODED AT BS 794, LBL 12.50. REPAIRED CHANNEL PER EA.SDR SWAA102918Channel · corrodedDURING SCHEDULED 16Y CHECK, FOUND AFT CARGO COMPT CHANNEL CORRODED AT BS 772, LBL 3.0. REPAIRED CHANNEL PER EA.SDR SWAA102917Channel · corrodedDURING SCHEDULED 16Y CHECK, FOUND AFT CARGO COMPT CHANNEL CORRODED AT BS 772, LBL 8.10. REPAIRED CHANNEL PER EA.SDR SWAA102916Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 747, BETWEEN STR 27R TO STR 26R. REPAIRED FRAME PER SRM.SDR SWAA102915Shear Tie · corrodedDURING SCHEDULED 16Y CHECK, FOUND SHEAR TIE CORRODED AT BS 967, BETWEEN STR 19R TO STR 20R. REMOVED AND REPLACED SHEAR TIE PER SRM AND BAC DWG.SDR SWAA102889Fitting · corrodedDURING SCHEDULED 16Y CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE GIRT BAR FITTING CORRODED. REMOVED AND REPLACED FITTING PER MT.SDR SWAA102888Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 663.75, STR 10R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA102887Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 685, STR 11L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA102886Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 578, STR 11L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA102885Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 25R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA102884Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 500B, BETWEEN STR 28R TO STR 28L. REPAIRED FRAME PER SRM.SDR SWAA102883Flap · delaminatedDURING SCHEDULED 16Y CHECK, FOUND LT WING FORE FLAP O/B END DELAMINATED. REPAIRED FORE FLAP PER SRM.SDR SWAA102882Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 927, STR 27R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA102881Beam · corrodedDURING SCHEDULED 16Y CHECK, FOUND AFT CARGO FLOOR CHANNEL BEAM CORRODED AT BS 860, BETWEEN STR 26L TO STR 27L. REPAIRED BEAM PER EA.SDR SWAA102880Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 847, BETWEEN STR 26L TO STR 27L. REPAIRED FRAME PER SRM.SDR SWAA102878Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 827, BETWEEN STR 27L TO STR 27R. REPAIRED FRAME PER SRM.SDR SWAA102877Shear Tie · corrodedDURING SCHEDULED 16Y CHECK, FOUND SHEAR TIE CORRODED AT BS 947, BETWEEN STR 26L TO STR 27L. REPAIRED SHEAR TIE PER SRM.SDR SWAA102876Shear Tie · corrodedDURING SCHEDULED 16Y CHECK, FOUND SHEAR TIE CORRODED AT BS 747, STR 25L. REPAIRED SHEAR TIE PER SRM.SDR SWAA102875Fitting · corrodedDURING SCHEDULED 16Y CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE GIRT BAR FITTING CORRODED. REMOVED AND REPLACED FITTING ASSY PER MM.SDR SWAA102848Rib · crackedDURING SCHEDULED 16Y CHECK, FOUND RT WING LOWER CHORD RIB CRACKED AT WBL 135.5, BETWEEN S2 TO S3. REPAIRED RIB PER ACO.SDR SWAA102847Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 787, BETWEEN STR 26L TO STR 27L. REPAIRED FRAME PER SRM.SDR SWAA102846Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 787, BETWEEN STR 25L TO STR 26L. REPAIRED FRAME PER SRM.SDR SWAA102845Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 747, BETWEEN STR 27R TO STR 26R. REPAIRED FRAME PER SRM.SDR SWAA102825Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 747, STR 10L. R&R CLIP PER SRM.SDR SWAA102824Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 685, STR 11R. R&R CLIP PER SRM.SDR SWAA102823Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 706, STR 11R. R&R CLIP PER SRM.SDR SWAA102822Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 706, STR 11L. R&R CLIP PER SRM.SDR SWAA102821Fitting · corrodedDURING SCHEDULED 16Y CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE GIRT BAR FITTING CORRODED. R&R FITTING ASSY PER MM.SDR SWAA102820Fitting · corrodedDURING SCHEDULED 16Y CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE GIRT BAR FITTING CORRODED. R&R FITTING ASSY PER MM.
Back to N384SW, cancelled Aug 3, 2018