N692SW, cancelled Sep 7, 2017
Service difficulty reports · 434
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 = 'N692SW' AND deregistration_id = 'N692SW-2017-09-07' 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 = 'N692SW' AND deregistration_id = 'N692SW-2017-09-07' 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 SWAA091575Bulkhead · crackedDURING SCHEDULED 24Y CHECK, FOUND VERTICAL BEAM WEB CRACKED AT BS 184, RBL 5.7. REPAIRED WEB PER SRM.SDR SWAA091574Bulkhead · crackedDURING SCHEDULED 24Y CHECK, FOUND VERTICAL BEAM WEB CRACKED AT BS 179, RBL 5.7. REPAIRED WEB PER SRM.SDR SWAA091573Frame Splice · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME SPLICE CRACKED AT BS 440, BETWEEN STR 13L TO STR 14L. REPAIRED FRAME PER SWA EA.SDR SWAA091572Crease Beam · corrodedDURING SCHEDULED 24Y CHECK, FOUND LT CREASE BEAM WEB CORRODED AT BS 370, BETWEEN LBL 61 TO LBL 63. REPAIRED WEB PER SRM.SDR SWAA091571Stringer Clip · corrodedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CORRODED AT BS 500C, STR 26. REPAIRED CLIP PER SRM.SDR SWAA091570Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FRAME CORRODED AT BS 480, RBL 13. REPAIRED FRAME PER SRM.SDR SWAA091569Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 727B, LBL 45. REPAIRED BEAM PER AAR EA.SDR SWAA091503Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME ANGLE CRACKED AT BS 291, STR 12R. REPAIRED ANGLE PER SRM.SDR SWAA091497Support Angle · corrodedDURING SCHEDULED 24Y CHECK, FOUND MLG WHEEL WELL KEEL BEAM PANEL SUPPORT ANGLE CORRODED AT BS 727, BETWEEN LBL 5 TO RBL 5. REMOVED AND REPLACED ANGLE PER SRM.SDR SWAA091478Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 360, BETWEEN STR 13R TO STR 14R. REPAIRED FRAME PER SWA EA.SDR SWAA091473Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED BS 807, BETWEEN STR 13R TO STR 14R. REPAIRED FRAME PER SRM.SDR SWAA091472Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED BS 360, STR 8R. REPAIRED FRAME PER SRM.SDR SWAA091471Crease Beam · crackedDURING SCHEDULED 24Y CHECK, FOUND CREASE BEAM WEB CRACKED BETWEEN BS 597 TO BS 578, STR 17L. REMOVED AND REPLACED WEB PER SRM.SDR SWAA091470Stringer Clip · corrodedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CORRODED AT BS 500D, STR 27L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA091469Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 500A, BETWEEN STR 26R TO STR 27R. REPAIRED SHEAR TIE PER SRM.SDR SWAA091451Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 480, STR 8R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA091450Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 907, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA091449Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 847, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA091448Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 767, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA091447Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA091446Bracket · crackedDURING SCHEDULED 24Y CHECK, FOUND R2 DOOR FWD EMERGENCY EVAC SLIDE BRACKET CRACKED. REMOVED AND REPLACED BRACKET PER MM.SDR SWAA091442Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FWD CARGO COMPARTMENT FRAME CRACKED AT BS 847, BETWEEN STR 13R TO STR 14R. REPAIRED FRAME PER SRM.SDR SWAA091441Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FWD CARGO COMPARTMENT FRAME CRACKED AT BS 500C, STR 28L. REMOVED AND REPLACED FRAME PER SRM.SDR SWAA091440Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 787, STR 22L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA091406Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 767, STR 16R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA091405Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 727B, RBL 24. REPAIRED BEAM PER AAR EA.SDR SWAA091404Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 727B, RBL 45. REPAIRED BEAM PER AAR EA.SDR SWAA091403Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND SKIN CRACKED AT BS 774, STR 23L. REPAIRED SKIN PER SRM.SDR SWAA091391Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 907, STR 8L. REMOVED AND REPLACED CLIP PER SWA EA.SDR SWAA091390Shear Tie · crackedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CRACKED AT BETWEEN BS 188 TO BS 196, WL 208. REPAIRED SHEAR TIE PER BAC DWG.SDR SWAA091320Stringer Clip · corrodedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CORRODED AT BS 787, STR 26R. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA091319Stringer Clip · corrodedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CORRODED AT BS 767, STR 26R. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA091318Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 400, STR 13R & 14R. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA091317Wedge · delaminatedDURING SCHEDULED 24Y CHECK, FOUND LT WING NR 2 L/E SLAT WEDGE DELAMINATED. REPAIRED SLAT WEDGE PER SRM.SDR SWAA091316Wedge · delaminatedDURING SCHEDULED 24Y CHECK, FOUND LT WING NR 1 L/E SLAT WEDGE DELAMINATED. REPAIRED SLAT WEDGE PER SRM.SDR SWAA091315Wedge · delaminatedDURING SCHEDULED 24Y CHECK, FOUND LT WING NR 3 L/E SLAT WEDGE DELAMINATED. REPAIRED SLAT WEDGE PER SRM.SDR SWAA091302Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 847, STR 9L. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA091301Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 807, STR 8R. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA091300Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 887, STR 8R. REPAIRED FRAME PER EA.SDR SWAA091299Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME PER EA.SDR SWAA091298Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER EA.SDR SWAA091278Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 767, STR 8L. REPAIRED FRAME PER SRM & EA.SDR SWAA091277Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727C, STR 8L. REPAIRED FRAME PER SRM & EA.SDR SWAA091276Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727A, STR 8L. REPAIRED FRAME PER SRM & EA.SDR SWAA091275Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 597, STR 8L. REPAIRED FRAME PER SRM & EA.SDR SWAA091274Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8L. REPAIRED FRAME PER SRM & EA.SDR SWAA091273Attach Angle · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM ATTACH ANGLE CRACKED AT BS 639, RBL 45.5. REMOVED AND REPLACED ANGLE PER SRM & ER.SDR SWAA091272Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 22R. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA091271Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 25L. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA091178Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME PER SRM.
Back to N692SW, cancelled Sep 7, 2017