Boeing 737-3Y0
Service difficulty reports · 3,007
Newest first. General aviation reporting is voluntary.
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 aircraft_model_key = '7373Y0' 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 aircraft_model_key = '7373Y0' 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 USAA2009060191363Skin · crackedSAL - C19 - MAJOR REPAIR - NR 6176110 - 2 CRACKS ON RIGHT HAND PYLON OUTBOARD SIDE AT ACCESS PANEL CUTOUT 5824R. REPAIRED RIGHT HAND PYLON OUTBOARD SIDE AT ACCESS PANEL CUTOUT 5824R IAW US AIRWAYS TYPICAL REPAIR 54-10-07.SDR USAA2009060191362Skin · delaminatedSAL - C19 - MAJOR REPAIR - NR 6177486 - DELAMINATION LEFT WING INBOARD AFT FLAP TRAILING EDGE LOWER SURFACE, OUTBOARD SIDE. REPAIRED LEFT WING INBOARD AFT FLAP TRAILING EDGE LOWER SURFACE IAW B737 SRM 51-70-10.SDR USAA2009052991335Frame · crackedSAL - C19 - MAJOR REPAIR - NR 6175807 - CRACK IN FUSELAGE FRAME AT BS360 BETWEEN S8L TO S9L. REPAIRED FUSELAGE FRAME AT BS360 BETWEEN S8L TO S9L IAW US AIRWAYS ENGINEERING CARD M1C53002.SDR USAA2009052891329Frame · crackedSAL - C19 - MAJOR REPAIR - NR 6175810 - CRACK ON FUSELAGE FRAME AT BS907 BETWEEN S8R TO S9R. REPAIRED FUSELAGE FRAME AT BS907, BETWEEN S8R TO S9R IAW US AIRWAYS TASK CARD M1C53002. SAL - C19 - MAJOR REPAIR - NR 6175810 - CRACK ON FUSELAGE FRAME AT BS907, BETWESDR USAA2009052891328Frame · crackedSAL - C19 - MAJOR REPAIR - NR 6175809 - CRACK ON FUSELAGE FRAME AT BS907, BETWEEN S8L TO S9L. REPAIRED FUSELAGE FRAME AT BS907, BETWEEN S8L TO S9L IAW US AIRWAYS TASK CARD M1C53002.SDR USAA2009052891327Frame · crackedSAL - C19 - MAJOR REPAIR - NR 6175808 - CRACK ON FUSELAGE FRAME AT BS400, BETWEEN S8R TO S9R. REPAIRED FUSELAGE FRAME AT BS400, BETWEEN S8R TO S9R IAW US AIRWAYS TASK CARD M1C53002.SDR USAA2009060391386Tab · crackedSAL - C19 - MAJOR REPAIR - CRACKS ON LEFT ELEVATOR TAB LEADING EDGE AT ELEV STA 93.5. REPAIRED LEFT ELEVATOR TAB LEADING EDGE AT ELEV STA 93.5 IAW B737 SRM 51-70-17.SDR USAA2009052991336Floorbeam · corrodedSAL - C19 - MAJOR REPAIR - NR 6201895 - CORROSION ON FLOOR SUPPORT BEAM BETWEEN BS986.5 TO BS1006 & ALSO BETWEEN RBL9 TO RBL20. REPLACED FLOOR SUPPORT BEAM BETWEEN BS986.5 TO BS1006 & ALSO BETWEEN RBL9 TO RBL20 IAW B737 SRM 51-10-02 & BOEING DRAWING 65-46812SDR USAA2009052891326Tie Clip · crackedSAL - C19 - MAJOR REPAIR - NR 6177472 - CRACK ON STRINGER TIE AT BS400, S27L. REPLACED STRINGER TIE AT BS400, S27L IAW B737 SRM 51-10-02.SDR USAA2009052891324Angle · corrodedSAL - C19 - MAJOR REPAIR - NR 6201890 - CORROSION ANGLE AT BS994.5 BETWEEN RBL16 TO RBL44. REPLACED ANGLE AT BS994.5 BETWEEN RBL16 TO RBL44 IAW B737 SRM 51-10-02.SDR USAA2009052791301Stringer Clip · crackedSAL - C19 - MAJOR REPAIR - NR 6177471 - CRACK ON STRINGER TIE AT BS400, S28L. REPLACED STRINGER TIE AT BS400, S28L IAW B737 SRM 51-10-02.SDR USAA2009052791300Angle · corrodedSAL - C19 - MAJOR REPAIR - NR 6201897 - GALVANIC CORROSION ON LOWER ANGLE IN AREA OF LOWER SILL BETWEEN BS967 TO BS986.5, LBL 48. REPLACED LOWER ANGLE IN AREA OF LOWER SILL BETWEEN BS967 TO BS986.5, LBL 48 IAW B737 SRM 51-10-02 & BOEING DRAWING 65-52878.SDR USAA2009052691276Floor Support · corrodedSAL - C19 - MAJOR REPAIR - NR 6202238 - CORROSION ON FLOOR SUPPORT AT BS949, LBL46. REPLACED FLOOR SUPPORT AT BS949, LBL46 IAW B737 SRM 51-10-02.SDR SWAA093178Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND SKIN CRACKED AT BS 931, STR 25R. REPAIRED SKIN PER SRM.SDR SWAA093177Slide · out of adjustDURING SCHEDULED HC1 CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MT.SDR SWAA092884Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND SKIN CRACKED AT BS 798, RBL 34. REPAIRED SKIN PER EA.SDR SWAA092883Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 400, BETWEEN STR 13L TO STR 14L. REPAIRED FRAME PER EA.SDR SWAA092882Skin · corrodedDURING SCHEDULED 22Y CHECK, FOUND SKIN CORRODED AT BS 817, STR 26R. REPAIRED SKIN PER EA.SDR SWAA092881Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE RADIO ALTIMETER BELLY SKIN CUTOUT CRACKED AT BS 413, RBL 13. REPAIRED SKIN PER EA.SDR SWAA092729Shear Tie · corrodedDURING SCHEDULED 22Y CHECK, FOUND SHEAR TIE CORRODED AT BS 967, BETWEEN STR 17R TO STR 18R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA092728Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND E&E OVERBOARD EXHAUST CUTOUT CRACKED AT BS 380, BL 0. REPAIRED SKIN PER SRM.SDR SWAA092727Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 663, RBL 24.8. REPAIRED BEAM PER EA.SDR SWAA092726Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND RADIO ALTIMETER BELLY SKIN CUTOUT CRACKED AT BS 426, RBL 1.5. REPAIRED SKIN PER EA.SDR SWAA092725Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR LOWER HINGE CUTOUT, BS 291, BETWEEN WL 233 TO WL 234. REPAIRED SKIN PER EA.SDR SWAA092724Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 660, BBL 0.0. REPAIRED BEAM PER SI.SDR SWAA092723Stringer · corrodedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CORRODED BETWEEN BS 815 TO BS 840, STR 26R. REMOVED AND REPLACED STRINGER PER SRM.SDR SWAA092722Stringer · corrodedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CORRODED AT BS 803, STR 26R. REMOVED AND REPLACED STRINGER PER SRM.SDR SWAA092721Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND L1 COCKPIT WINDOW AT O/B POST CRACKED UPPER CORNER. REPAIRED SKIN PER SRM.SDR SWAA092720Stringer · corrodedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CORRODED AT BS 967, STR 20R. REPAIRED STRINGER PER SRM.SDR SWAA092719Stringer · corrodedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CORRODED BETWEEN BS 867 TO BS 887, STR 26R. REPAIRED STRINGER PER SRM.SDR SWAA092718Stringer · corrodedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CORRODED AT BS 860, STR 26R. REPAIRED STRINGER PER SRM.SDR SWAA092529Shear Tie · corrodedDURING SCHEDULED 22Y CHECK, FOUND SHEAR TIE CORRODED AT BS 847, STR 26L. REPAIRED SHEAR TIE PER SRM.SDR SWAA092528Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE SKIN CRACKED AT L1 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER EA.SDR SWAA092527Slat · crackedDURING SCHEDULED 22Y CHECK, FOUND RT WING NR 5 SLAT L/E CRACKED. REPAIRED SLAT PER SRM.SDR SWAA092309Control Unit · faultyDIVERSION, DISCHARGED AFT CARGO FIRE BOTTLE DUE TO FALSE FIRE WARNING INDICATION. FOUND SCU FAILED. REMOVED AND REPLACED SCU PER MM.SDR SWAA092350Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 887, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA092349Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA092348Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 727E, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA092347Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 887, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA092346Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 787, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA092318Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 294, STR 13L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA092390Flap · delaminatedDURING SCHEDULED MV2 CHECK, FOUND RT WING I/B FORE FLAP DELAMINATED. REMOVED AND REPLACED FORE FLAP PER MM.SDR SWAA092254Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA092253Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA092252Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 807, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA092185Stringer Splice · corrodedDURING SCHEDULED 22Y CHECK, FOUND STRINGER SPLICE CORRODED BETWEEN BS 360 TO BS 363, STR 28L. REMOVED AND REPLACED SPLICE PER SRM.SDR SWAA092168Bear Strap · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE BEAR STRAP SKIN CRACKED AT R1 DOOR UPPER HINGE CUTOUT, BS 291, WL 259. REPAIRED SKIN PER ER.SDR SWAA092167Bear Strap · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE BEAR STRAP SKIN CRACKED AT R1 DOOR LOWER HINGE CUTOUT, BS 291, WL 233. REPAIRED SKIN PER ER.SDR SWAA092166Bear Strap · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE BEAR STRAP SKIN CRACKED AT L1 DOOR LOWER HINGE CUTOUT, BS 303, WL 238. REPAIRED SKIN PER ER.SDR SWAA092165Flap · delaminatedDURING SCHEDULED 22Y CHECK, FOUND RT WING O/B FORE FLAP DELAMINATED. REPAIRED FORE FLAP PER SRM.
Back to Boeing 737-3Y0