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 SWAA2013072218430Battery Pack · dischargedRT AFT EMERGENCY LIGHT INOPERATIVE. R&R BATTERY PACK IAW AMM.SDR SWAA2013080618902Attach Fitting · corrodedRT HORIZONTAL STABILIZER FRONT SPAR LOWER ATTACH FITTING CORRODED AT REAR FACE CENTER SECTION CLEVIS. REPAIRED FITTING IAW SRM & EA.SDR SWAA2013080618901Attach Fitting · corrodedRT HORIZONTAL STABILIZER FRONT SPAR UPPER ATTACH FITTING CORRODED AT FWD FACE & ON BORE LUG CENTER SECTION CLEVIS. REPAIRED FITTING IAW SRM & EA.SDR SWAA2013080118734Panel · crackedNLG WW LT PANEL CRACKED AT BS 246. REPAIRED PANEL IAW SRM.SDR SWAA2013073118714Floorbeam · crackedFLOOR BEAM CRACKED AT BS 616, RBL 45.5. REPAIRED FLOOR BEAM IAW SWA EA.SDR SWAA2013072218438Glowstrip · dirtyCABIN FLOOR PHOTO LUMINESCENT STRIPS DIRTY. CLEANED EEPLS IAW MM.SDR SWAA2013072218429Glowstrip · loosePHOTOILLUMINESCENT STRIP ON CABIN FLOOR AT ROW 8 LOOSE. SECURED STRIP IAW AMM.SDR SWAA2013071918377Door · crackedL1 DOOR CRACKED. R&R DOOR IAW MMM.SDR SWAA2013081219109Pressure Deck · crackedMAIN WW PRESSURE DECK WEB CRACKED AT BS 664, LBL 15. REPAIRED WEB IAW ER & EA.SDR SWAA2013081219108Pressure Deck · crackedMAIN WW PRESSURE DECK WEB CRACKED AT BS 664, LBL 33. REPAIRED WEB IAW ER & EA.SDR SWAA2013081219107Structure · crackedCHORD CRACKED AT BS 727, STRINGER 18A LT IN THE LOWER FWD HOLE. REPAIRED CHORD IAW ER & EA.SDR SWAA2013081219106Structure · crackedCHORD CRACKED AT BS 727, STRINGER 18A RT IN THE LOWER FWD HOLE. REPAIRED CHORD IAW ER & EA.SDR SWAA2013080618904Shear Tie · corrodedSHEAR TIE CORRODED AT STATION 767, BETWEEN STRINGER 25L & STRINGER 26L. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2013080618900Fitting · corrodedRT HORIZONTAL STABILIZER FRONT SPAR LOWER ATTACH FITTING CORRODED ON FWD LUG CENTER SECTION CLEVIS. REPAIRED FITTING IAW SRM & EA.SDR SWAA2013080618885Shear Tie · corrodedSHEAR TIE CORRODED STATION 807, BETWEEN STRINGER 25L & STRINGER 26L. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2013080518836Skin · crackedAFT ENTRY DOOR CUT OUT FWD LOWER CORNER CRACKED. REPAIRED CUT OUT IAW SRM.SDR SWAA2013080218806Shear Tie · corrodedSHEAR TIE CORRODED AT BS 947, BETWEEN STRINGER 27L & STRINGER 27R. R&R SHEAR TIE IAW SRM.SDR SWAA2013080218805Shear Tie · damagedSHEAR TIE PILLOWING AT BS 807, BETWEEN STRINGER 26R & STRINGER 27R. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2013080218804Shear Tie · corrodedSHEAR TIE CORRODED AT BS 807, BETWEEN STRINGER 27L AND STRINGER 27R. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2013080218803Shear Tie · corrodedSHEAR TIE CORRODED AT BS 767, BETWEEN STRINGER 27R & STRINGER 26R. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2013080218802Shear Tie · corrodedSHEAR TIE CORRODED AT BS 767, BETWEEN STRINGER 27L & STRINGER 27R. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2013080218801Shear Tie · corrodedSHEAR TIE CORRODED AT BS 767, BETWEEN STRINGER 26L AND STRINGER 27L. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2013073018669Shear Tie · corrodedFRAME SHEAR TIE CORRODED AT BS 807, BETWEEN STRINGER 26L & STRINGER 27L. REPAIRED SHEAR TIE IAW SRM.SDR SWAA2013073018668Skin · crackedRT WING FIXED LE CRACKED AT STATION 213. REPAIRED SKIN IAW SWA EA.SDR SWAA2013072618580Blower · overheatedPLASTIC SMELL IN COCKPIT & NORMAL EQUIP BLOWER CIRCUIT BREAKER TRIPPED. R&R EQUIP COOLING BLOWER IAW MM.SDR SWAA2013071918364Pin · missingRT PYLON OTBD MIDSPAR FUSE PIN MISSING. INSTALLED PIN IAW MM.SDR SWAA2013071918361Pin · missingRT PYLON INBD MIDSPAR FUSE PIN MISSING. INSTALLED PIN IAW MM.SDR SWAA2013071918356Lens · missingFWD UPPER EMERGENCY EXIT SIGN LOWER RT LIGHT LENS MISSING. R&R LIGHT IAW MM.SDR SWAA2013080618903Access Panel · crackedACCESS PANEL 5864R CRACKED AT CORNER OF FASTENER HOLE. REPAIRED PANEL IAW SRM.SDR SWAA2013080518831Stringer · crackedSTRINGER CRACKED AT STATION 500D, STRINGER 8R. REPAIRED STRINGER IAW EA.SDR SWAA2013073018685Beam · crackedSTUB BEAM CRACKED AT BS 616, STRINGER 17R. REPAIRED BEAM IAW SWA EA.SDR SWAA2013072418544Bulkhead · crackedFRAME BULKHEAD WEB CRACKED AT BS 727, BETWEEN STRINGER 25R TO STRINGER 26R. REPAIRED WEB IAW SRM.SDR SWAA2013072218392Pressure Panel · crackedMLG WW BEADED WEB CRACKED AT STATION 663, BETWEEN LBL 25-LBL 45. REPAIRED WEB IAW EA.SDR SWAA2013071818324Hydraulic Line · damagedAIR TURNBACK, AFTER TAKEOFF WHILE RAISING THE GEAR MASTER CAUTION LIGHT ILLUMINATED WITH SYSTEM ENGINE & ELECTRIC HYDRAULIC LOW PRESSURE LIGHTS. REPLACED NR 2 MAIN.SDR SWAA2013071718303Lens · looseRT OVERWING EXIT SIGN LENS LOOSE. SECURED LENS IAW MM.SDR SWAA2013081619277Support Fitting · crackedSUPPORT CLIP CRACKED AT BS 927, STRINGER 25L. R&R CLIP IAW SRM & DRAWING.SDR SWAA2013080618895Frame · crackedFRAME CRACKED AT BS 328, BETWEEN STRINGER 20R TO STRINGER 21R. REPAIRED FRAME IAW EO & EA.SDR SWAA2013080618894Rib · crackedRT WING RIB LOWER CHORD CRACKED AT WBL 135.5, BETWEEN S-2 TO S-3. REPAIRED CHORD IAW EA.SDR SWAA2013080618884Slat · delaminatedRT WING NR 5 SLAT TE OTBD CORNER UPPER AREA DELAMINATED. R&R NR 5 SLAT IAW AMM.SDR SWAA2013080518833Nut Plate · crackedLT WING NUT PLATE STRIP UPPER SURFACE CRACKED BETWEEN WBL 181 TO WBL 191. R&R NUT PLATE STRIP IAW SRM & DRAWING.SDR SWAA2013080218800Glowstrip · damagedFWD PHOTO LUMINSCENT STRIP DAMAGED. R&R STRIP IAW AMM.SDR SWAA2013080118743Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 787+2, BETWEEN STRINGER 17R TO STRINGER 19R. R&R ANGLE IAW SRM & DRAWING.SDR SWAA2013080118742Frame · corrodedFRAME CORRODED AT BS 727B, BETWEEN STRINGER 27R TO STRINGER 27L. REPAIRED FRAME IAW SRM & DRAWING.SDR SWAA2013080118741Frame · corrodedFRAME CORRODED AT BS 727E, BETWEEN STRINGER 27R TO STRINGER 27L. REPAIRED FRAME IAW SRM.SDR SWAA2013080118740Frame · corrodedFRAME CORRODED AT BS 767, BETWEEN STRINGER 27L TO STRINGER 26L. REPAIRED FRAME IAW SRM & DRAWING.SDR SWAA2013073118715Frame · corrodedFS FRAME CRACKED AT BS 767, BETWEEN STRINGER 27L & STRINGER 27R. REPAIRED FRAME IAW SRM.SDR SWAA2013073018667Frame · corrodedFS FRAME CORRODED AT BS 927.5, BETWEEN STRINGER 27L & STRINGER 27R. REPAIRED FRAME IAW SRM.SDR SWAA2013073018666Frame · corrodedFS FRAME CORRODED AT BS 807, BETWEEN STRINGER 27L & STRINGER 27R. REPAIRED FRAME IAW SRM.SDR SWAA2013073018665Skin · debondedLT WING INBD FORE FLAP REPAIRED DISBONDED AT OTBD EDGE. REPAIRED SKIN IAW SRM.SDR SWAA2013072618601Frame · crackedFS FRAME CRACKED AT BS 500C, STRINGER 20R & STRINGER 21R. REPAIRED FRAME IAW SRM.
Back to Boeing 737-3H4