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 SWAA2014021024981Shear Tie · corrodedSHEAR TIE CORRODED AT BS 500, BETWEEN STRINGER 27R TO STRINGER 28R. R & R SHEAR TIE IAW SRM & DRAWING.SDR SWAA2014021024980Shear Tie · corrodedSHEAR TIE CORRODED AT BS 500, BETWEEN STRINGER 26R TO STRINGER 27R. R & R SHEAR TIE IAW SRM & DRAWING.SDR SWAA2014021024973Strap · crackedFWD GALLEY AREA UNDER FLOOR STRUCTURE STRAP CRACKED AT BS 328, RBL 45. R & R STRAP IAW SRM & DRAWING.SDR SWAA2014021024972Strap · crackedFWD GALLEY AREA UNDER FLOOR STRUCTURE STRAP CRACKED AT BS 312, BL 0. R & R STRAP IAW SRM & DRAWING.SDR SWAA2014020624899Fitting · crackedCLIP CRACKED AT BS 360, STRINGER 8L. R & R CLIP IAW SRM & DRAWING.SDR SWAA2014020624898Plate · crackedFWD ENTRY DOOR LOWER HINGE CUT OUT PLATE CRACKED AT BS 303, BETWEEN STRINGER 13L TO STRINGER 14L. R & R PLATE IAW SRM & DRAWING.SDR SWAA2014013024678Lens · brokenFWD SERVICE DOOR EMERGENCY LIGHT LENS BROKEN. R & R LENS IAW MM.SDR SWAA2014022125374Frame · crackedFRAME CRACKED AT BS 500C, BETWEEN STRINGER 20L TO STRINGER 21L. REPAIRED FRAME IAW SRM.SDR SWAA2014020424834Tie Clip · crackedTIE CLIP CRACKED AT BS 380, STRINGER 14L. R & R TIE CLIP IAW SRM & DRAWING.SDR SWAA2014013024682Strap · crackedFLOOR BEAM STABILIZER STRAP CRACKED AT BS 312 LBL 12. REPAIRED STRAP IAW SRM.SDR SWAA2014022725613Skin · crackedL2 DOOR SKIN CUTOUT FWD LOWER CORNER CRACKED AT BS 947.5+14.5, STRINGER 17L. REPAIRED SKIN IAW EA & EO.SDR SWAA2014022725612Skin · crackedL2 DOOR SKIN CUTOUT FWD LOWER CORNER CRACKED AT BS 947.5+13.5, STRINGER 17L. REPAIRED SKIN IAW EA & EO.SDR SWAA2014022525518Pressure Deck · crackedMAIN WW PRESS DECK WEB CRACKED AT BS 663.75+9, LBL 24.5+14. REPAIRED WEB IAW EA.SDR SWAA2014022525517Pressure Deck · crackedMAIN WW PRESS DECK WEB CRACKED AT BS 663.75+1, LBL 24.5+6. REPAIRED WEB IAW EA.SDR SWAA2014022525516Skin · crackedFUSELAGE SKIN CRACKED AT BS 328, STRINGER 16R. REPAIRED SKIN IAW SRM.SDR SWAA2014022525515Skin · crackedSKIN CRACKED AT BS 794.5+4, STRINGER 24R. REPAIRED SKIN IAW EA.SDR SWAA2014022425447Pressure Deck · crackedMAIN WW PRESS DECK WEB CRACKED AT BS 663.75+9, RBL 24.5+17. REPAIRED WEB IAW EA.SDR SWAA2014022425446Pressure Deck · crackedMAIN WW PRESS DECK WEB CRACKED AT BS 663.75+9, RBL 24.5+14. REPAIRED WEB IAW EA.SDR SWAA2014022425445Pressure Deck · crackedMAIN WW PRESS DECK CRACKED AT BS 663.75+1, RBL 24.5+14. REPAIRED WEB IAW EA.SDR SWAA2014022425444Skin · crackedFUSELAGE SKIN CRACKED AT BS 328, STRINGER 16R. REPAIRED SKIN IAW EA.SDR SWAA2014022425443Skin · crackedFUSELAGE SKIN CRACKED AT BS 328+4.5, STRINGER 17R. REPAIRED SKIN IAW EA.SDR SWAA2014022025343Skin · crackedFUSELAGE SKIN CRACKED AT BS 967-6.5, STRINGER 17R. REPAIRED SKIN IAW SRM.SDR SWAA2014022025342Skin · crackedSKIN CRACKED AT BS 967-5.5, STRINGER 17R. REPAIRED SKIN IAW SRM.SDR SWAA2014022025341Skin · crackedFUSELAGE SKIN CRACKED AT BS 947.5+12.5, STRINGER 17R. REPAIRED SKIN IAW SRM.SDR SWAA2014021925318Floor Support · crackedLONGITUDINAL FLOOR BEAM WEB CRACKED AT BS 714, RBL 24.8. REPAIRED WEB IAW EA.SDR SWAA2014021925317Floor Support · crackedLONGITUDINAL FLOOR BEAM WEB CRACKED AT BS 713, RBL 24.8. REPAIRED WEB IAW EA.SDR SWAA2014021925316Floor Support · crackedLONGITUDINAL FLOOR BEAM WEB CRACKED AT BS 709, RBL 24.8. REPAIRED WEB IAW EA.SDR SWAA2014021925315Floor Support · crackedLONGITUDINAL FLOOR BEAM WEB CRACKED AT BS 713, RBL 24.8. REPAIRED WEB IAW EA.SDR SWAA2014021925314Floor Support · crackedLONGITUDINAL FLOOR BEAM WEB CRACKED AT BS 712, RBL 24.8. REPAIRED WEB IAW EA.SDR SWAA2014021925313Floor Support · crackedLONGITUDINAL FLOOR BEAM WEB CRACKED AT BS 710, RBL 24.8. REPAIRED WEB IAW EA.SDR SWAA2014021925312Floor Support · crackedLONGITUDINAL FLOOR BEAM WEB CRACKED AT BS 709, RBL 24.8. REPAIRED WEB IAW EA.SDR SWAA2014021325122Support Angle · crackedLT PYLON ACCESS PANEL 5758L SUPPORT ANGLE CRACKED AT INTERNAL CAVITY. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014021325121Support Angle · crackedLT PYLON ACCESS PANEL 5757L SUPPORT ANGLE CRACKED AT INTERNAL CAVITY. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014012924669Skin · crackedSKIN CRACKED AT BS 500D+11 STRINGER 10R. REPAIRED SKIN IAW EA.SDR SWAA2014012924662Holder · looseR1 DOOR EMERGENCY EVAC SLIDE GIRT BAR HOLDER LOOSE. SECURED HOLDER IAW SIP.SDR SWAA2014022725611Skin · crackedL2 DOOR SKIN CUTOUT FWD LOWER CORNER CRACKED AT BS 960, STRINGER 17L. REPAIRED SKIN IAW EA & EO.SDR SWAA2014022625559Frame · crackedFRAME CHORD CRACKED AT BS 727, STRINGER 18A LT. R & R CHORD IAW EA.SDR SWAA2014022525514Floorbeam · crackedFLOOR BEAM CRACKED BETWEEN BS 666 TO BS 670, LBL 24.5. REPAIRED BEAM IAW EA.SDR SWAA2014022525513Floorbeam · crackedFLOOR BEAM CRACKED AT BS 669, LBL 24.5. REPAIRED BEAM IAW EA.SDR SWAA2014022525512Frame · crackedFRAME CHORD CRACKED AT BS 727, STRINGER 18A. R & R CHORD IAW EA.SDR SWAA2014021925311Floor Support · crackedLONGITUDINAL FLOOR BEAM WEB CRACKED BETWEEN BS 707 TO BS 708, RBL 24.8. REPAIRED WEB IAW EA.SDR SWAA2014021825269Floor Support · crackedLONGITUDINAL FLOORBEAM WEB CRACKED AT BS 705+3.5, LBL 24.8. REPAIRED WEB IAW EA.SDR SWAA2014021125052Angle · crackedLT MAIN WW ANGLE CRACKED AT BS 727, BETWEEN STRINGER 26L TO STRINGER 27L. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014012824631Lens · looseLT OVERWING EMERGENCY EXIT LIGHT LENS LOOSE. R & R LIGHT ASSEMBLY IAW MM.SDR SWAA2014012724605Structure · crackedCHORD CRACKED AT BS 727 STRINGER 18A RT. REPAIRED CHORD IAW SWA EA.SDR SWAA2014022625558Frame · crackedFRAME CHORD CRACKED AT BS 727, STRINGER 18A RT. R & R CHORD IAW EA.SDR SWAA2014022125372Frame · crackedFRAME CRACKED AT BS 328, STRINGER 20R. REPAIRED FRAME IAW EO & EA.SDR SWAA2014021725229Plate · crackedRT WING ACCESS PANEL 3678R PLATE CRACKED AT BS 727, STRINGER 22R. R & R PLATE IAW SRM & DRAWING.SDR SWAA2014021725247Skin · crackedRT WING LE SKIN CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014021325120Frame · corrodedFRAME CORRODED AT BS 787, BETWEEN STRINGER 27R TO STRINGER 27L. REPAIRED FRAME IAW SRM.
Back to Boeing 737-3H4