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 SWAA101586Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 504, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA101585Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 424, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA101584Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 795, STR 19L. REPAIRED SKIN PER SRM.SDR SWAA101583Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 795, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA101582Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 727E, STR 24L. REPAIRED SKIN PER SRM.SDR SWAA101581Flap · delaminatedDURING SCHEDULED MV2 CHECK, FOUND LT WING I/B MID FLAP T/E DELAMINATED. REPAIRED MID FLAP PER SRM.SDR SWAA100990Slide · out of positionL1 DOOR EMERGENCY EVAC SLIDE INADVERTENTLY FELL OUT DID NOT DEPLOY. RE-INSTALLED SLIDE PER MT.SDR SWAA097332Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 20L TO STR 21L. REPAIRED FRAME PER SRM AND ER.SDR SWAA097331Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500B, STR 20L TO STR 21L. REPAIRED FRAME PER SRM AND ER.SDR SWAA097330Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500B, STR 20R TO STR 21R. REPAIRED FRAME PER SRM AND ER.SDR SWAA096687Control Rod · corrodedDURING SCHEDULED MV2 CHECK, FOUND RT ELEVATOR TAB I/B CONTROL ROD CORRODED. REMOVED AND REPLACED ROD PER EA.SDR SWAA096674Control Rod · corrodedDURING SCHEDULED MV2 CHECK, FOUND LT ELEVATOR TAB O/B CONTROL ROD CORRODED. REMOVED AND REPLACED ROD ASSY PER MM.SDR SWAA096673Control Rod · corrodedDURING SCHEDULED MV2 CHECK, FOUND LT ELEVATOR TAB I/B CONTROL ROD CORRODED. REMOVED AND REPLACED ROD ASSY PER MM.SDR SWAA096672Control Rod · corrodedDURING SCHEDULED MV2 CHECK, FOUND RT ELEVATOR TAB O/B CONTROL ROD CORRODED. REMOVED AND REPLACED ROD ASSY PER MM.SDR SWAA096252Slide · out of adjustDURING SCHEDULED HC1 CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MT.SDR SWAA096251Lens · looseDURING SCHEDULED HC1 CHECK, FOUND LT EMERGENCY EXIT LIGHT LENS LOOSE. SECURED LENS PER MM.SDR SWAA094958Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND SKIN CRACKED AT BS 820, STR 16L. REPAIRED SKIN PER SWA EA.SDR SWAA093800Skin · crackedDURING SCHEDULED THRU CHECK FOUND, SKIN CRACKED AT BS 466, STR 16R. REPAIRED STRINGER PER SRM.SDR SWAA092125Fitting · damagedDURING SCHEDULED 24Y CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR FITTING BASE DAMAGED. REMOVED AND REPLACED FITTING PER MM.SDR SWAA092124Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND RT WING NR 4 SLAT O/B SKIN CRACKED. REPAIRED SKIN PER SRM.SDR SWAA092123Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND SKIN CRACKED BETWEEN BS 868 TO BS 872, STR 25L. REPAIRED SKIN PER SRM.SDR SWAA092122Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND RADIO ALTIMETER BELLY SKIN CUTOUT CRACKED AT BS 410. REPAIRED SKIN PER AAR EA.SDR SWAA092121Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 559, BETWEEN STR 13L TO STR 14L. REPAIRED FRAME PER AAR EA.SDR SWAA092120Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE BEAR STRAP SKIN CUTOUT CRACKED AT BS 305, STR 1L. REPAIRED SKIN PER AAR EA.SDR SWAA092119Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR UPPER HINGE CUTOUT, BETWEEN BS 290 TO BS 305, BETWEEN WL 231 TO WL 259. REPAIRED SKIN PER AAR EA.SDR SWAA092118Light · looseDURING SCHEDULED 24Y CHECK, FOUND EEPLS LIGHT LOOSE AT ROW 5. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA092117Light · inoperativeDURING SCHEDULED 24Y CHECK, FOUND EEPLS LIGHT INOP AT ROW 6. REMOVED AND REPLACED LIGHT PER MM.SDR SWAA092116Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 887, BETWEEN STR 13R TO STR 14R. REPAIRED FRAME PER AAR EA.SDR SWAA092115Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 907, BETWEEN STR 13R TO STR 14R. REPAIRED FRAME PER AAR EA.SDR SWAA092113Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME ANGLE CRACKED AT BS 291, STR 11R. REMOVED AND REPLACED ANGLE PER SRM.SDR SWAA092114Crease Beam · crackedDURING SCHEDULED 24Y CHECK, FOUND LT CREASE BEAM CHORD CRACKED AT BS 618. REPAIRED BEAM PER SRM.SDR SWAA092112Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 727B, BETWEEN STR 13L TO STR 14L. REPAIRED FRAME PER SRM.SDR SWAA092111Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 727B, BETWEEN STR 13R TO STR 14R. REPAIRED FRAME PER SRM.SDR SWAA092110Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FRAME CORRODED AT BS 500D, STR 27R. REPAIRED FRAME PER SRM.SDR SWAA092109Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 188, STR 17L. REPAIRED FRAME PER SWA EA.SDR SWAA092108Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 787, BETWEEN STR 13R TO STR 14R. REPAIRED FRAME PER SWA EA.SDR SWAA092067Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND SKIN CRACKED BETWEEN BS 686 TO BS 872, STR 25L. REPAIRED SKIN PER SRM.SDR SWAA092066Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT L2 DOOR LOWER HINGE CUTOUT, LOWER AFT CORNER. REPAIRED SKIN PER SRM.SDR SWAA091985Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 727B, LBL 24. REPAIRED BEAM PER AAR EA.SDR SWAA091984Bulkhead · crackedDURING SCHEDULED 24Y CHECK, FOUND BULKHEAD WEB CRACKED AT BS 178, BETWEEN RBL 1 TO RBL 3. REPAIRED WEB PER ACO.SDR SWAA091983Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE BEAR STRAP SKIN CRACKED AT BS 305, BETWEEN WL 257 TO WL 261. REPAIRED SKIN PER AAR EA.SDR SWAA091887Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 559, BETWEEN STR 13L TO STR 14L. REPAIRED FRAME PER AAR EA.SDR SWAA091706Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 380, STR 15L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA091705Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND SKIN CRACKED BETWEEN BS 868 TO BS 872, STR 25L. REPAIRED SKIN PER SRM.SDR SWAA091704Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 827, LBL 4. REPAIRED SHEAR TIE PER SRM.SDR SWAA091703Crease Beam · crackedDURING SCHEDULED 24Y CHECK, FOUND LT CREASE BEAM WEB CRACKED BETWEEN BS 636 TO BS 639, BETWEEN LBL 67 TO LBL 71. REMOVED AND REPLACED WEB PER SRM.SDR SWAA091675Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BETWEEN BS 868 TO BS 872, STR 25L. REPAIRED SKIN PER SRM.SDR SWAA091660Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 774, STR 23L. REPAIRED SKIN PER SRM.SDR SWAA091621Pressure Panel · crackedDURING SCHEDULED 24Y CHECK, FOUND NOSE WHEEL WELL CEILING WEB CRACKED AT SNUBBER ATTACHMENT, BS 253, BETWEEN RBL 7 TO LBL 7. REPAIRED WEB PER ACO.SDR SWAA091576Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 291, WL 260. REPAIRED FRAME PER AAR EA.
Back to N692SW, cancelled Sep 7, 2017