N369SW, cancelled Mar 22, 2018
Service difficulty reports · 323
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 = 'N369SW' AND deregistration_id = 'N369SW-2018-03-22' 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 = 'N369SW' AND deregistration_id = 'N369SW-2018-03-22' 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 SWAA117874Battery · dischargedFWD O/B EMERGENCY FLASHLIGHT INDICATOR INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA116903Flashlight · inoperativeAFT INBOARD FLASHLIGHT INOP. REMOVED AND REPLACED FLASHLIGHT ASSY PER MM.SDR SWAA116443Skin · crackedDURING SCHEDULED CV CHECK, FOUND SKIN CRACKED AT BS 440+1, STR 2R. REPAIRED SKIN PER EA.SDR SWAA116442Skin · crackedDURING SCHEDULED CV CHECK, FOUND SKIN CRACKED AT BS 440+3, STR 1. REPAIRED SKIN PER EA.SDR SWAA116441Skin · crackedDURING SCHEDULED CV CHECK, FOUND SKIN CRACKED AT BS 430+2, STR 1. REPAIRED SKIN PER EA.SDR SWAA116440Sign · looseDURING SCHEDULED CV CHECK, FOUND RT EMERGENCY EXIT SIGN LOOSE AT ROW 10. SECURED SIGN PER MM.SDR SWAA113788Slat · delaminatedDURING SCHEDULED HC2 CHECK FOUND, LT WING NR 2 SLAT DELAMINATED AT I/B TRAILING EDGE WEDGE. REMOVED AND REPLACED NR 2 SLAT PER MM.SDR SWAA113787Flap · delaminatedDURING SCHEDULED HC2 CHECK FOUND, LT WING I/B AFT FLAP DELAMINATED ON O/B EDGE. REMOVED AND REPLACED AFT FLAP PER MM.SDR SWAA110753Shear Tie · corrodedDURING SCHEDULED 18Y CHECK, FOUND SHEAR TIE CORRODED AT BS 500C, BETWEEN STR 27L TO STR 27R. REPAIRED SHEAR TIE PER SRM.SDR SWAA110752Flap · delaminatedDURING SCHEDULED 18Y CHECK, FOUND LT WING I/B FORE FLAP DELAMINATED. REMOVED AND REPLACED FORE FLAP PER MM.SDR SWAA110751Flap · delaminatedDURING SCHEDULED 18Y CHECK, FOUND LT WING I/B AFT FLAP O/B T/E ENDCAP DELAMINATED. REPAIRED AFT FLAP PER SRM.SDR SWAA110750Crease Beam · crackedDURING SCHEDULED 18Y CHECK, FOUND LT OVERWING CREASE BEAM WEB CRACKED AT BS 637, STR 17L. REPAIRED WEB PER SRM.SDR SWAA110749Shear Tie · corrodedDURING SCHEDULED 18Y CHECK, FOUND SHEAR TIE CORRODED AT BS 827, BETWEEN RBL 5 TO LBL 5. REPAIRED SHEAR TIE PER SRM AND SI.SDR SWAA110748Skin · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE SKIN CRACKED AT R2 DOOR LOWER CORNER. REPAIRED SKIN PER SRM.SDR SWAA105843Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND SKIN CRACKED AT BS 433, STR 1. REPAIRED SKIN PER SRM.SDR SWAA103549Lens · looseLT OVERWING EMERGENCY EXIT LIGHT LENS LOOSE. SECURED LENS PER EA.SDR SWAA103075Slide · looseL2 DOOR EVAC SLIDE LOOSE. SECURED EVAC SLIDE PER MT.SDR SWAA101961Lens · looseRT OVERWING EMERGENCY EXIT LIGHT LENS LOOSE. SECURED LIGHT PER EA AND BAC DWG.SDR SWAA101455Stringer Splice · crackedDURING SCHEDULED 2HC2 CHECK, FOUND STRINGER SPLICE CRACKED AT BS 908, STR 4L. REMOVED AND REPLACED SPLICE PER SRM.SDR SWAA101454Slide · out of adjustDURING SCHEDULED 2HC2 CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA095673Skin · delaminatedDURING SCHEDULED SPV CHECK, FOUND LT WING O/B AFT FLAP SKIN DELAMINATED. REMOVED AND REPLACED AFT FLAP PER MM.SDR SWAA095038Lens · missingRIGHT BULLNOSE EMERGENCY EXIT LIGHT LENS MISSING AT ROW 16. INSTALLED LENS PER MM.SDR SWAA093492Flap · delaminatedDURING SCHEDULED MV2 CHECK, FOUND RT WING I/B AFT FLAP DELAMINATED. REMOVED AND REPLACED AFT FLAP ASSY PER MM.SDR SWAA091667Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 727, STR 20L. REPAIRED SKIN PER ER.SDR SWAA091666Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SHEAR TIE CRACKED AT BS 360, BETWEEN STR 14R TO STR 15R. REPAIRED SHEAR TIE PER ER.SDR SWAA091665Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR LOWER HINGE CUTOUT, BS 292, WL 230. REPAIRED SKIN PER SRM.SDR SWAA091664Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR UPPER HINGE CUTOUT, BS 292, WL 255. REPAIRED SKIN PER SRM.SDR SWAA091624Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE BROKEN AT BS 520, BETWEEN STR 23R TO STR 24R. REPAIRED SHEAR TIE PER SRM.SDR SWAA091599Floorbeam · corrodedDURING SCHEDULED SPV CHECK, FOUND FLOORBEAM CORRODED AT BS 312, BL 0. REPAIRED BEAM PER SRM.SDR SWAA091552Floorbeam · corrodedDURING SCHEDULED SPV CHECK, FOUND FLOORBEAM CORRODED AT BS 986, BETWEEN LBL 5 TO RBL 18. REPAIRED BEAM PER ER.SDR SWAA091493Shear Tie · corrodedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CORRODED AT BS 807, BETWEEN STR 27L TO STR 27R. REPAIRED SHEAR TIE PER SRM.SDR SWAA091492Shear Tie · corrodedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CORRODED AT BS 787, BETWEEN STR 26R TO STR 27R. REPAIRED SHEAR TIE PER SRM.SDR SWAA091491Shear Tie · corrodedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CORRODED AT BS 747, BETWEEN STR 26R TO STR 27R. REPAIRED SHEAR TIE PER SRM.SDR SWAA091490Shear Tie · corrodedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CORRODED AT BS 827, BETWEEN STR 25L TO STR 26L. REPAIRED SHEAR TIE PER SRM.SDR SWAA091489Shear Tie · corrodedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CORRODED AT BS 807, BETWEEN STR 25L TO STR 26L. REPAIRED SHEAR TIE PER SRM.SDR SWAA091482Rib · crackedDURING SCHEDULED SPV CHECK, FOUND RT WING RIB LOWER CHORD CRACKED AT WBL 135, BETWEEN STR 3R TO STR 2R. REPAIRED CHORD PER ACO.SDR SWAA091481Fabric · wornDURING SCHEDULED SPV CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE GIRT FABRIC WORN. REMOVED AND REPLACED SLIDE PER MT.SDR SWAA091466Stringer · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CRACKED AT BS 380, STR 21L. REPAIRED STRINGER PER SRM.SDR SWAA091465Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED BETWEEN BS 402 TO BS 408, STR 24R. REPAIRED SKIN PER SRM.SDR SWAA091464Crease Beam · corrodedDURING SCHEDULED SPV CHECK, FOUND RT CREASE BEAM WEB CORRODED BETWEEN BS 887 TO BS 907. REPAIRED WEB PER SRM.SDR SWAA091398Cover · damagedDURING SCHEDULED SPV CHECK, FOUND LT EMERGENCY EXIT LIGHT COVER ON SIDEWALL DAMAGED. REMOVED AND REPLACED COVER PER MM.SDR SWAA091281Stringer Clip · crackedDURING SCHEDULED SPECIAL VISIT CHECK, FOUND STRINGER CLIP CRACKED AT BS 400, STR 19L. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA091280Stringer Clip · crackedDURING SCHEDULED SPECIAL VISIT CHECK, FOUND STRINGER CLIP CRACKED AT BS 480, STR 19L. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA091279Stringer · crackedDURING SCHEDULED SPECIAL VISIT CHECK, FOUND STRINGER 21L CRACKED AT BS 460 TO BS 500. REPAIRED STRINGER PER SRM.SDR SWAA091313Stringer Clip · crackedDURING SCHEDULED SPECIAL VISIT CHECK, FOUND STRINGER CLIP CRACKED AT BS 400, STR 23R. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA091312Stringer Clip · crackedDURING SCHEDULED SPECIAL VISIT CHECK, FOUND STRINGER CLIP CRACKED AT BS 500D, STR 22L. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA091245Stringer Clip · crackedDURING SCHEDULED SPECIAL VISIT CHECK, FOUND STRINGER CLIP CRACKED AT BS 500B, STR 16R. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA091244Stringer Clip · crackedDURING SCHEDULED SPECIAL VISIT CHECK, FOUND STRINGER CLIP CRACKED AT BS 460, STR 16R. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA091243Flap · delaminatedDURING SCHEDULED SPECIAL VISIT CHECK, FOUND LT I/B TRAILING EDGE FORE FLAP DELAMINATED AT O/B END. REPAIRED FLAP PER SRM.SDR SWAA091344Floorbeam · crackedDURING SCHEDULED SPV CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 727B, RBL 24. REPAIRED BEAM PER ER.
Back to N369SW, cancelled Mar 22, 2018