Boeing 737-3H4
Service difficulty reports · 52,340
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 = '7373H4' 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 = '7373H4' 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 SWAA2014011624165Shear Tie · corrodedSHEAR TIE CORRODED AT BS 767 BETWEEN STRINGER 27L TO STRINGER 26L. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2014011624153Angle · crackedFWD ENTRY DOOR AFT FRAME ANGLE CRACKED AT BS 348 STRINGER 15L. REPAIRED ANGLE IAW ER & EA.SDR SWAA2014011624136Angle · crackedL1 DOOR CUTOUT REVEAL ANGLE CRACKED AT BS 312. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014011624135Stringer · crackedSTRINGER CRACKED AT BS 1006+4 STRINGER 5R. REPAIRED STRINGER IAW SRM.SDR SWAA2014011624134Angle · crackedRT WING ANGLE CRACKED AT RSS 533+12" FIXED TE. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014011424106Frame · crackedFRAME CRACKED AT BS 348.2 BETWEEN STRINGER 13L TO STRINGER 7L. REPAIRED FRAME IAW EA.SDR SWAA2014011424112Shear Tie · corrodedSHEAR TIE CORRODED AT BS 727E, BETWEEN STRINGER 27L TO STRINGER 27R. R & R SHEAR TIE IAW SRM.SDR SWAA2014011324020Angle · crackedANGLE CRACKED BETWEEN BS 277 TO BS 291.5, BETWEEN STRINGER 11R TO STRINGER 12R. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014011324019Angle · crackedRT WING NR 6 FLAP TRACK FAIRING ANGLE CRACKED. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014011324045Stringer Clip · corrodedSTRINGER CLIP CORRODED AT BS 947.5 STRINGER 26L. R & R CLIP IAW SRM.SDR SWAA2014011324044Shear Tie · corrodedSHEAR TIE CORRODED AT BS 907 BETWEEN STRINGER 27L TO STRINGER 27R. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2014011324043Shear Tie · corrodedSHEAR TIE CORRODED AT BS 907 BETWEEN STRINGER 26L TO STRINGER 27L. R & R SHEAR TIE IAW SRM.SDR SWAA2014011324042Shear Tie · corrodedSHEAR TIE CORRODED AT BS 827 BETWEEN STRINGER 25L TO STRINGER 26L. R & R SHEAR TIE IAW SRM.SDR SWAA2014011324041Stringer Clip · corrodedSTRINGER CLIP CORRODED AT BS 807 STRINGER 26L. R & R CLIP IAW SRM.SDR SWAA2014011324040Shear Tie · corrodedSHEAR TIE CORRODED AT BS 787 BETWEEN STRINGER 26L TO STRINGER 25L. R & R SHEAR TIE IAW SRM.SDR SWAA2014011324039Stringer Clip · corrodedSTRINGER CLIP CORRODED AT BS 767 STRINGER 26L. R & R CLIP IAW SRM.SDR SWAA2014011324038Stringer Clip · corrodedSTRINGER CLIP CORRODED AT BS 747 STRINGER 26L. R & R CLIP IAW SRM.SDR SWAA2014011324021Angle · crackedFWD ENTRY DOOR REVEAL ANGLE CRACKED AT BS 344 BETWEEN STRINGER 9L TO STRINGER 10L. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014011324071Intercostal · crackedINTERCOSTAL CRACKED AT BS 348 STRINGER 16L. REPAIRED INTERCOSTAL IAW EA.SDR SWAA2014011324070Frame · crackedFRAME CRACKED AT BS 348.2 BETWEEN STRINGER 13L TO STRINGER 17L. REPAIRED FRAME IAW SWA EA.SDR SWAA2014010923945Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 294.5, STRINGER 11L. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014010923937Web · crackedWEB CRACKED BETWEEN BS 294.5 TO BS 303.9 STRINGER 12L. R & R WEB IAW SRM.SDR SWAA2014010923936Tie Clip · crackedTIE CLIP CRACKED AT BS 277 STRINGER 10R. R & R TIE CLIP IAW SRM & DRAWING.SDR SWAA2014010923935Support Angle · crackedSUPPORT ANGLE CRACKED BETWEEN BS 277 TO BS 291.5 STRINGER 13R. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014010923907Angle · crackedANGLE CRACKED BETWEEN BS 277 TO BS 291.5, BETWEEN STRINGER 9R TO STRINGER 10R. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014010823868Web · crackedWEB CRACKED AT BS 303.9 STRINGER 4L. R & R WEB IAW SRM & DRAWING.SDR SWAA2014010823867Strap · crackedSTRAP CRACKED AT BS 302 STRINGER 4L. R & R STRAP IAW SRM & DRAWING.SDR SWAA2014010823866Angle · crackedANGLE CRACKED BETWEEN BS 277 TO BS 291.5, BETWEEN STRINGER 12R TO STRINGER 13R. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014010723847Stringer Clip · corrodedSTRINGER CLIP CORRODED BS 787, STRINGER 26R. R & R CLIP IAW SRM.SDR SWAA2014010723795Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 540 STRINGER 4R. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014010223715Stringer Clip · damagedSTRINGER CLIP DAMAGED AT BS 986 STRINGER 6R. R & R CLIP IAW SRM & DRAWING.SDR SWAA2014010223731Shear Tie · corrodedSHEAR TIE CORRODED AT BS 787, BETWEEN STRINGER 27L & STRINGER 27R. R & R SHEAR TIE IAW SRM.SDR SWAA2014012724579Flap · delaminatedLT WING OTBD TE AFT FLAP DELAMINATED. R & R AFT FLAP IAW MM.SDR SWAA2014012224397Bulkhead · crackedDOME CAP WEB CRACKED AT BS 1016 RBL 3.5. REPAIRED WEB IAW SRM.SDR SWAA2014012024326Keelbeam · corrodedRT KEEL BEAM CORRODED UNDER NUTPLATES BETWEEN BS 727 TO BS 717. REPAIRED BEAM IAW SRM.SDR SWAA2014012024325Floor Support · crackedLONGITUDINAL FLOOR BEAM LOWER CHORD CRACKED AT BS 662 RBL 24.8. REPAIRED CHORD IAW ER & EA.SDR SWAA2014012024227Floor Support · crackedLONGITUDINAL FLOOR BEAM VERTICAL WEB CRACKED AT BS 712.5 LBL 24.8. REPAIRED WEB IAW EA.SDR SWAA2014012024226Floor Support · crackedLONGITUDINAL FLOOR BEAM VERTICAL WEB CRACKED AT BS 710.4 LBL 24.8. REPAIRED WEB IAW EA.SDR SWAA2014012024225Floor Support · crackedLONGITUDINAL FLOOR BEAM VERTICAL WEB CRACKED AT BS 709.4 LBL 24.8. REPAIRED WEB IAW EA.SDR SWAA2014012024224Floor Support · crackedLONGITUDINAL FLOOR BEAM VERTICAL WEB CRACKED AT BS 708.4 LBL 24.8. REPAIRED WEB IAW EA.SDR SWAA2014012024223Keelbeam · corrodedLT KEEL BEAM CORRODED BETWEEN BS 727 TO BS 720. REPAIRED BEAM IAW ER & EA.SDR SWAA2014012024222Stringer · corrodedSTRINGER CORRODED BETWEEN BS 500C+10 TO BS 500C-10 AT STRINGER 26R. REPAIRED STRINGER IAW SRM.SDR SWAA2014011424094Bulkhead · crackedDOME CAP WEB CRACKED AT BS 1016 RBL 4. REPAIRED WEB IAW SRM.SDR SWAA2014010723846Shear Tie · corrodedSHEAR TIE CORRODED AT BS 500D BETWEEN STRINGER 28R TO STRINGER 28L. R & R SHEAR TIE IAW SRM & DRAWING.SDR SWAA2014012224396Spoiler · delaminatedRT WING NR 8 SPOILER DELAMINATED. R & R NR 8 SPOILER IAW AMMSDR SWAA2014012024324Pressure Deck · crackedMAIN WW PRESS DECK CRACKED AT BS 664 LBL 18. REPAIRED DECK IAW ER & EA.SDR SWAA2014012024323Pressure Deck · crackedMAIN WW PRESS DECK CRACKED AT BS 673 LBL 42. REPAIRED DECK IAW ER & EA.SDR SWAA2014012024322Pressure Deck · crackedMAIN WW PRESS DECK CRACKED AT BS 664 LBL 41. REPAIRED DECK IAW ER & EA.SDR SWAA2014012024321Floor Support · crackedLONGITUDINAL FLOOR BEAM UPPER CHORD CRACKED AT BS 727B RBL 45.5. REPAIRED CHORD IAW ER & EA.SDR SWAA2014012024221Floor Support · crackedLONGITUDINAL FLOOR BEAM UPPER CHORD CRACKED AT BS 667 LBL 24.8. REPAIRED CHORD IAW EA.
Back to Boeing 737-3H4