N364SW, cancelled Apr 26, 2016
Service difficulty reports · 302
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 = 'N364SW' AND deregistration_id = 'N364SW-2016-04-26' 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 = 'N364SW' AND deregistration_id = 'N364SW-2016-04-26' 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 SWAA2012061404919Frame · corrodedFRAME CORRODED AT BS 500D, BETWEEN STR 23L TO STR 24L. REPAIRED FRAME IAW SRM AND DWG.SDR SWAA2012061404918Frame · corrodedFRAME CORRODED AT BS 727E, BETWEEN STR 26L TO STR 27L. REPAIRED FRAME IAW SRM AND DWG.SDR SWAA2012061404881Frame · corrodedFRAME CORRODED AT BS 500, BETWEEN STR 28L TO STR 28R. REPAIRED FRAME IAW SRM & DWG.SDR SWAA2012061404880Frame · corrodedFRAME CORRODED AT BS 767, BETWEEN STR 26R TO STR 27R. REPAIRED FRAME IAW SRM & DWG.SDR SWAA2012060804756Channel · corrodedCORROSION ON CHANNEL AT BS 858 TO BS 861, LBL 3. REPAIRED CHANNEL PER EA.SDR SWAA2012060704744Frame · corrodedCORROSION ON FRAME AT BS 787, BETWEEN STR 26R & STR 27R. REPAIRED FRAME PER SRM.SDR SWAA2012060604710Frame · crackedFRAME CRACKED AT BS 500D, BETWEEN STR 22R AND STR 23R. REPAIRED FRAME IAW SRM.SDR SWAA2012060604709Tie Clip · crackedTIE CLIP CRACKED AT BS 380, STR 19L. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2012060504667Tie Clip · crackedTIE CLIP CRACKED AT BS 500D, STR 25L. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2012060504666Tie Clip · crackedTIE CLIP CRACKED AT BS 500D, STR 23L. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2012060504665Channel · corrodedCHANNEL CORRODED BETWEEN BS 858 TO BS 861, RBL 8.10. REPAIRED CHANNEL IAW EA.SDR SWAA2012060504664Channel · corrodedCHANNEL CORRODED BETWEEN BS 858 TO BS 861, LBL 8.10. REPAIRED CHANNEL IAW EA.SDR SWAA2012060504663Channel · corrodedCHANNEL CORRODED BETWEEN BS 858 TO BS 861, RBL 3. REPAIRED CHANNEL IAW EA.SDR SWAA2012060404599Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 500C, STR 26L. REMOVED AND REPLACED ANGLE IAW SRM AND DWG.SDR SWAA2012060404598Tie Clip · crackedTIE CLIP CRACKED AT BS 500C, STR 19L. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2012060104539Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 500B, STR 26L. REMOVED AND REPLACED ANGLE IAW SRM AND DWG.SDR SWAA2012060104538Stiffener · crackedLEFT HORIZONTAL STABILIZER STIFFENER CRACKED AT STA 92.70. REMOVED AND REPLACED STIFFENER IAW SRM.SDR SWAA2012053104479Channel · crackedZEE CHANNEL CRACKED BETWEEN BS 492.5 TO BS 500A, STR 26R. REMOVED AND REPLACED ZEE CHANNEL IAW SRM AND DWG.SDR SWAA2012052904442Fastener · missingFRAME FASTENERS MISSING AT BS 420, STR 26R. INSTALLED FASTENERS IAW SRM AND DRAWING.SDR SWAA2012052904405Tie Clip · crackedTIE CLIP CRACKED AT BS 500C, STR 23R. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2012060404597Web · crackedWEB CRACKED BETWEEN BS 344 TO BS 360, BL 0. REMOVED AND REPLACED WEB IAW SRM AND DWG.SDR SWAA2012061805021Skin · crackedR1 DOOR FUSELAGE SKIN CUTOUT CRACKED AT BS 328, STR 17R. REPAIRED SKIN IAW EA.SDR SWAA2012060704743Skin · crackedFUSELAGE SKIN CRACKED AT BS 987, STR 7L. REPAIRED SKIN PER SRM.SDR SWAA2012052904394Lens · brokenCEILING EMERGENCY EXIT SIGN LENS BROKEN. REMOVED AND REPLACED LENS IAW CMM.SDR SWAA2012052904393Skin · crackedSKIN CRACKED BETWEEN BS 520 TO BS 540, BETWEEN STR 28L TO STR 28R. REPAIRED SKIN IAW EA.SDR SWAA1201028Flap · damagedLEFT WING O/B TE AFT FLAP DAMAGED. REMOVED AND REPLACED AFT FLAP IAW M/M.SDR SWAA1201027Flap · damagedLEFT WING I/B TE AFT FLAP DAMAGED. REMOVED AND REPLACED AFT FLAP PER M/M.SDR SWAA120437Crease Beam · crackedDURING SCHEDULED SPV CHECK, FOUND CREASE BEAM WEB CRACKED BETWEEN BS 638 TO BS 639, LBL 64. REMOVED AND REPLACED WEB IAW DWG.SDR SWAA120397Angle · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME INNER CHORD ANGLE CRACKED AT BS 639, LBL 64. REPAIRED CHORD IAW EA.SDR SWAA120398Attach Fitting · crackedDURING SCHEDULED SPV CHECK, FOUND LONGITUDINAL FLOORBEAM ATTACH CLIP CRACKED AT BS 639, LBL 45.5. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA120073Flap · delaminatedDURING SCHEDULED 2HC2 CHECK, FOUND RT WING O/B AFT FLAP DELAMINATED. REMOVED AND REPLACED AFT FLAP PER MM.SDR SWAA120072Light · inoperativeDURING SCHEDULED 2HC2 CHECK, FOUND L1 DOOR EXTERIOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT PER MM.SDR SWAA120071Lens · looseDURING SCHEDULED 2HC2 CHECK, FOUND FWD GALLEY OVERHEAD EMERGENCY EXIT LIGHT LENS LOOSE. REMOVED AND REPLACED LENS PER MM.SDR SWAA120070Cover · crackedDURING SCHEDULED 2HC2 CHECK, FOUND FWD LAV EXTERIOR EMERGENCY EXIT LIGHT COVER CRACKED. REMOVED AND REPLACED COVER PER MM.SDR SWAA116782Light · looseDURING SCHEDULED CV CHECK, FOUND RT EEPLS LOOSE AT ROW 20. REMOVED AND REPLACED EEPLS PER MM.SDR SWAA116781Skin · delaminatedDURING SCHEDULED CV CHECK, FOUND RT WING AILERON TAB I/B UPPER SURFACE L/E DELAMINATED. REMOVED AND REPLACED TAB ASSY PER MM.SDR SWAA114560Beam · crackedDURING SCHEDULED 2HC1 CHECK, FOUND AFT CARGO DOOR CRACKED ON LOWER T BEAM COMMON TO AFT LOWER STOP FITTING. REMOVED AND REPLACED DOOR PER MM AND EA.SDR SWAA114120Slide · out of positionDURING SCHEDULED MV1 CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE FELL OUT OF CASE, DID NOT DEPLOY. RE-INSTALLED SLIDE PER MT.SDR SWAA112618Slide · out of positionL1 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MM.SDR SWAA107744Light · missingEMERGENCY EXIT NOT ARMED LIGHT MISSING. INSTALLED LIGHT PER MM.SDR SWAA107260Slide · out of adjustDURING SCHEDULED HC2 CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MT.SDR SWAA105984Latch · brokenR2 DOOR EMERGENCY EVAC SLIDE FWD FLOOR LATCH BROKEN. REMOVED AND REPLACED LATCH PER MM.SDR SWAA104658Floorbeam · crackedDURING SCHEDULED 18Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 727B, LBL 43.5. REPAIRED BEAM PER EA.SDR SWAA104590Light · inoperativeDURING SCHEDULED 18Y CHECK, FOUND FWD EEPLS BULB INOP. RELAMPED PER MM.SDR SWAA104589Fitting · looseDURING SCHEDULED 18Y CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR FITTING LOOSE. SECURED FITTING PER MM.SDR SWAA104588Fitting · looseDURING SCHEDULED 18Y CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR FITTING LOOSE. SECURED FITTING PER MM.SDR SWAA104587Pressure Panel · crackedDURING SCHEDULED 18Y CHECK, FOUND LT FWD PRESSURE DECK CRACKED BETWEEN BS 664 TO BS 673, BETWEEN LBL 40 TO LBL 42. REPAIRED WEB PER EA.SDR SWAA104586Keelbeam · corrodedDURING SCHEDULED 18Y CHECK, FOUND RT KEEL BEAM LOWER CHORD LOWER SURFACE CORRODED BETWEEN BS 706 TO BS 727. REPAIRED BEAM PER EA.SDR SWAA104482Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FRAME CRACKED AT BS 671, RBL 43.5. REPAIRED FRAME PER ACO.SDR SWAA104481Pressure Panel · crackedDURING SCHEDULED 18Y CHECK, FOUND PRESSURE DECK AT O/B EDGE BEAD CRACKED AT BS 664, RBL 40. REPAIRED WEB PER SRM.
Back to N364SW, cancelled Apr 26, 2016