N679AA, cancelled Nov 19, 2014
Service difficulty reports · 360
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 = 'N679AA' AND deregistration_id = 'N679AA-2014-11-19' 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 = 'N679AA' AND deregistration_id = 'N679AA-2014-11-19' 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 SWAA120426Skin · crackedDURING SCHEDULED CV CHECK, FOUND SKIN CRACKED AT BS 375, STR 8L. REPAIRED SKIN IAW SRM.SDR SWAA118469Slide · out of adjustR2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. RE-ADJUSTED SLIDE PER MM.SDR SWAA115830Slide · out of positionL2 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITONED SLIDE PER MM.SDR SWAA115918Cable · misroutedDURING SCHEDULED MV2 CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE CABLE MISROUTED. REROUTED CABLE PER MM.SDR SWAA115076Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME WEB CRACKED AT BS 639, BETWEEN RBL 65 TO RBL 70. REPAIRED FRAME PER EA.SDR SWAA115075Frame · severedDURING SCHEDULED SPV CHECK, FOUND FRAME INNER CHORD SEVERED AT BS 639, RBL 65. REPAIRED CHORD PER EA.SDR SWAA115074Crease Beam · crackedDURING SCHEDULED SPV CHECK, FOUND CREASE BEAM INNER CHORD CRACKED AT BS 616, RBL 64. REPAIRED BEAM IAW EO AND ER.SDR SWAA115073Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME INNER CHORD CRACKED AT BS 616, RBL 65. REPAIRED FRAME IAW ER AND EA.SDR SWAA114815Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 270, STR 15R. REPAIRED SKIN PER SRM.SDR SWAA113573Battery · dischargedDURING SCHEDULED MV1 CHECK FOUND, AFT LT BULLNOSE EMERGENCY LIGHTS INOP AT ROW 14. INSTALLED BATTERY PER MM.SDR SWAA113285Skin · crackedDURING SCHEDULED MV3 CHECK, FOUND CRACK ON AFT GALLEY DOOR UPPER HINGE CUTOUT. REPAIRED PER SRM.SDR SWAA112931Sign · inoperativeDURING SCHEDULED MV2 CHECK, FOUND AFT CABIN OVERHEAD EMERGENCY EXIT SIGN INOP. REMOVED AND REPLACED SIGN PER MM.SDR SWAA111377Engine · oil consumptionENGINE SHUTDOWN/AIR TURNBACK/DECLARED EMERGENCY. CLIMBING OUT OF 15,000 FEET, LOW OIL PRESSURE NR 2 INDICATOR LIGHT ON. NR 2 OIL PRESSURE LESS THAN RED LINE. REMOVED AND REPLACED NR 2 ENGINE PER MT.SDR SWAA110795Skin · crackedDURING SCHEDULED 2HC2 CHECK, FOUND SKIN CRACKED AT BS 312, STR 25R. REPAIRED SKIN PER SRM.SDR SWAA110794Skin · crackedDURING SCHEDULED 2HC2 CHECK, FOUND SKIN CRACKED AT BS 580, STR 10R. REPAIRED SKIN PER AND SRM.SDR SWAA110793Skin · crackedDURING SCHEDULED 2HC2 CHECK, FOUND RT WING NR 5 SLAT L/E SKIN LOWER AFT ROW CRACKED. REPAIRED SLAT PER SRM.SDR SWAA110792Light · inoperativeDURING SCHEDULED 2HC2 CHECK, FOUND RT EMERGENCY EXIT BULLNOSE LIGHT INOP AT ROW 23. REMOVED AND REPLACED BULB PER MM.SDR SWAA104186Flap · delaminatedDURING SCHEDULED MV1 CHECK, FOUND LT WING O/B AFT FLAP DELAMINATED. REMOVED AND REPLACED AFT FLAP PER MM.SDR SWAA102057Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR LOWER CORNER CUTOUT, BS 343, STR 17L. REPAIRED SKIN PER ER.SDR SWAA102056Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR LOWER CORNER CUTOUT, BS 347, STR 16L. REPAIRED SKIN PER ER.SDR SWAA102046Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 827, LBL 18. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA102045Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 685, STR 7L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA102044Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 685, STR 8L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA102043Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND FLOORBEAM UPPER CHORD CRACKED AT BS 727B, LBL 45.5. REPAIRED BEAM PER ER.SDR SWAA102020Stringer Clip · crackedDURING SCHEDULED 20Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 907, STR 9L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA102003Flap · delaminatedDURING SCHEDULED 24Y CHECK, FOUND LT WING O/B AFT FLAP DELAMINATED. REPAIRED AFT FLAP PER SRM.SDR SWAA101902Shear Tie · crackedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CRACKED AT BS 520, BETWEEN STR 27L TO STR 28L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA101884Strap · crackedDURING SCHEDULED 24Y CHECK, FOUND SPLICE STRAP CRACKED AT BS 616, STR 10R. REMOVED AND REPLACED SPLICE STRAP PER SRM.SDR SWAA101835Shear Tie · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 500C, BETWEEN STR 27L AND STR 28L. REPAIRED SHEAR TIE PER SRM.SDR SWAA101834Keelbeam · corrodedDURING SCHEDULED 24Y CHECK, FOUND LT KEEL BEAM CORRODED AT BS 500D TO BS 540. REMOVED AND REPLACED LT KEEL BEAM SECTION PER SRM.SDR SWAA096357Sign · missingAFT OVERHEAD EMERGENCY EXIT SIGN MISSING. INSTALLED LIGHT ASSY PER MM.SDR SWAA095828Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND LT WING NR 2 SLAT LOWER SKIN CRACKED. REMOVED AND REPLACED SLAT PER MM.SDR SWAA095434Angle · crackedDURING SCHEDULED MV2 CHECK, FOUND RT WING T/E LOWER I/B ANGLE CRACKED. REMOVED AND REPLACED ANGLE PER MM.SDR SWAA094436Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND LT OVERWING EXTERIOR EMERGENCY EXIT LIGHT INOP. RELAMPED PER MM.SDR SWAA094435Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND OVERHEAD EMERGENCY EXIT LIGHT INOP BETWEEN ROW 6 TO ROW 10. RELAMPED PER MM.SDR SWAA092546Bulkhead · crackedDURING SCHEDULED SPV CHECK, FOUND MAIN CABIN UPPER SURFACE FWD SIDE PRESSURE BULKHEAD CRACKED AT BS 660, LBL 32. REPAIRED WEB PER SRM.SDR SWAA091385Slide · out of adjustDURING SCHEDULED HC1 CHECK, FOUND L2 DOOR EMERGENCY EVACUATION SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA091384Slide · out of adjustDURING SCHEDULED HC1 CHECK, FOUND R1 DOOR EMERGENCY EVACUATION SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA090415Slide · out of positionL1 DOOR EMERGENCY EVACUATION SLIDE OUT OF POSITION. ADJUSTED SLIDE PER MM.SDR SWAA087392Cover · missingDURING SCHEDULED MV2 CHECK, FOUND OVERWING RT EMERGENCY EXIT LIGHT COVER MISSING. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA087339Lens · missingRT OVERWING EMERGENCY EXIT LIGHT LENS MISSING. REPLACED LENS PER MM.SDR SWAA085482Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 500, STR 16R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA085481Floorbeam · crackedDURING SCHEDULED BRDG CHECK, FOUND FLOORBEAM CRACKED AT BS 344, RBL 38.5. REMOVED AND REPLACED BEAM PER PAE ER.SDR SWAA085451Shear Tie · crackedDURING SCHEDULED BRDG CHECK, FOUND SHEAR TIE CRACKED AT BS 400, STR 13L TO STR 14L. REPAIRED SHEAR TIE PER PAE ER.SDR SWAA085450Floorbeam · corrodedDURING SCHEDULED BRDG CHECK, FOUND FLOORBEAM CORRODED AT BS 344, RBL 12, WL 207. REPAIRED BEAM PER PAE ER.SDR SWAA085449Skin · damagedDURING SCHEDULED BRDG CHECK, FOUND L1 DOOR UPPER HINGE SKIN DAMAGED AT BS 306, STR 10L. REPAIRED SKIN PER PAE ER.SDR SWAA085379Shear Tie · crackedDURING SCHEDULED BRDG CHECK, FOUND SHEAR TIE CRACKED AT BS 500D BETWEEN STR 22L TO 23L. REMOVED AND REPLACED TIE PER SRM.SDR SWAA085362Skin · crackedDURING SCHEDULED BRDG CHECK, FOUND SKIN CRACKED AT BS 360, STR 13R TO STR 28R. REPLACED SKIN PER SRM.SDR SWAA085336Stringer Clip · crackedDURING SCHEDULED BRDG CHECK, FOUND STRINGER CLIP CRACKED AT BS 380, STR 20L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA085335Shear Tie · crackedDURING SCHEDULED BRDG CHECK, FOUND SHEAR TIE CRACKED AT 500D, STR 23L TO STR 24L. REPAIRED SHEAR TIE PER SRM.
Back to N679AA, cancelled Nov 19, 2014