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 SWAA2014031926228Shear Tie · corrodedSHEAR TIE CORRODED AT BS 328, STRINGER 27R. R & R SHEAR TIE IAW SRM & DWG.SDR SWAA2014031926224Bracket · crackedBRACKET CRACKED BETWEEN BS 312 TO BS 328, STRINGER 27R. R & R BRACKET IAW SRM & DWG.SDR SWAA2014031926223Tie Clip · crackedTIE CLIP CRACKED AT BS 380, STRINGER 26L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014031926222Angle · crackedANGLE CRACKED AT BS 328, STRINGER 20L. R & R ANGLE IAW SRM & DWG.SDR SWAA2014031726113Support Angle · crackedSUPPORT ANGLE CRACKED BETWEEN BS 927 TO BS 951, BL 0. R & R ANGLE IAW SRM & DWG.SDR SWAA2014031426035Slide · out of adjustR1 DOOR SLIDE OUT OF ADJUSTMENT. R & R SLIDE ASSEMBLY IAW MM.SDR SWAA2014031426033Sign · looseLT OVERWING EXIT SIGN LOOSE. SECURED EXIT SIGN IAW MM.SDR SWAA2014041427052Frame · crackedFRAME CRACKED AT BS 380, STRINGER 16L. REPAIRED FRAME IAW EA.SDR SWAA2014041427047Crease Beam · crackedCREASE BEAM INNER CHORD CRACKED AT BS 500D+18, LBL 64. REPAIRED CHORD IAW EO & EA.SDR SWAA2014040826921Web · crackedWEB CRACKED AT BS 707, BETWEEN LBL 6.50 TO RBL 6.50. R & R WEB IAW SRM & DWG.SDR SWAA2014040726869Frame · crackedFRAME OUTER CHORD CRACKED AT BS 348.2, STRINGER 16L. REPAIRED CHORD IAW EA.SDR SWAA2014040726844Structure · crackedCHORD CRACKED AT BS 616 + 2.5, LBL 64. R & R CHORD IAW SRM & DWG.SDR SWAA2014040726843Shear Web · corrodedCREASE BEAM SHEAR WEB CORRODED BETWEEN BS 847 TO BS 867, STRINGER 17R. REPAIRED WEB IAW EA.SDR SWAA2014040726833Stringer · crackedSTRINGER CRACKED AT BS 500B, STRINGER 8R. R & R STRINGER IAW SRM.SDR SWAA2014040126709Frame · crackedFRAME CRACKED AT BS 188, STRINGER 17R. REPAIRED FRAME IAW SRM & DWG.SDR SWAA2014040126708Frame · crackedFRAME CRACKED AT BS 188, STRINGER 17L. REPAIRED FRAME IAW SRM & DWG.SDR SWAA2014032426336Angle · crackedANGLE CRACKED AT BS 847, BETWEEN STRINGER 1 TO STRINGER 2L. R & R ANGLE IAW SRM & DWG.SDR SWAA2014032426335Angle · crackedANGLE CRACKED AT BS 827, BETWEEN STRINGER 1 TO STRINGER 2R. R & R ANGLE IAW SRM.SDR SWAA2014032426332Angle · crackedANGLE CRACKED AT BS 827, BETWEEN STRINGER 1 TO STRINGER 2L. R & R ANGLE IAW SRM & DWG.SDR SWAA2014032426331Tie Clip · crackedTIE CLIP CRACKED AT BS 500A, STRINGER 16L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014032426330Tie Clip · crackedTIE CLIP CRACKED AT BS 480, STRINGER 16L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014032426329Tie Clip · crackedTIE CLIP CRACKED AT BS 460, STRINGER 16L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014032426328Fitting · crackedCLIP CRACKED AT BS 807, STRINGER 11R. R & R CLIP IAW SRM & DWG.SDR SWAA2014032426408Angle · crackedSUPPORT VERTICAL ANGLE CRACKED AT RACK E1 - 2 IN E & E COMPARTMENT. REPAIRED ANGLE IAW SRM & DWG.SDR SWAA2014032126309Strap · crackedE & E COMPARTMENT FUSELAGE STRAP CRACKED AT STATION 328, RBL 33. R & R STRAP IAW SRM.SDR SWAA2014032026241Angle · crackedANGLE CRACKED AT BS 847, BETWEEN STRINGER 1 TO STRINGER 2R. R & R ANGLE IAW SRM & DWG.SDR SWAA2014032026271Attach Fitting · crackedINTERCOSTAL FWD END ATTACH CLIP CRACKED BETWEEN BS 807 TO BS 827, RBL 6. R & R CLIP IAW SRM & DWG.SDR SWAA2014031926221Tie Clip · crackedTIE CLIP CRACKED AT BS 767, STRINGER 16L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014031926220Tie Clip · crackedTIE CLIP CRACKED AT BS 867, STRINGER 16R. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014031826188Tie Clip · crackedTIE CLIP CRACKED AT BS 747, STRINGER 4L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014031826187Tie Clip · crackedTIE CLIP CRACKED AT BS 727A, STRINGER 3R. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014031826186Tie Clip · crackedTIE CLIP CRACKED AT BS 520, STRINGER 16R. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014031826185Tie Clip · crackedTIE CLIP CRACKED AT BS 380, STRINGER 15R. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014031726095Tie Clip · crackedTIE CLIP CRACKED AT BS 500B, STRINGER 15L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014031726094Tie Clip · crackedTIE CLIP CRACKED AT BS 400, STRINGER 8L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014031426032Lens · looseRT OVERWING EXIT LIGHT LENS LOOSE. REINSTALLED RT OVERWING EXIT LIGHT LENS IAW MM.SDR SWAA2014031326009Panel · brokenRT INBD GND SPOILER OTBD ACTUATOR FITTING CASTING BROKEN AT SHELF PANEL ATTACH POINT. REPAIRED PANEL ASSEMBLY IAW SWA EA.SDR SWAA2014041427051Frame · crackedFRAME CRACKED AT BS 500D, BETWEEN STRINGER 20L TO STRINGER 21L. REPAIRED FRAME IAW EO & EA.SDR SWAA2014041427046Frame · crackedFRAME INNER CHORD ON LOWEST FASTENER HOLE CRACKED AT BS 348.2, STRINGER 17L. REPAIRED CHORD IAW EA.SDR SWAA2014041026979Frame · crackedFRAME CRACKED AT BS 500D, BETWEEN STRINGER 20R TO STRINGER 21R. REPAIRED FRAME IAW EO & EA.SDR SWAA2014040926949Fitting · crackedRIGHT PYLON INTERFACE FITTING CRACKED. REPAIRED FITTING IAW EA.SDR SWAA2014040726832Frame · crackedFRAME CRACKED AT BS 500C, BETWEEN STRINGER 20L TO STRINGER 21L. REPAIRED FRAME IAW SRM.SDR SWAA2014040426826Rib · crackedRIGHT WING RIB CRACKED AT STATION 114, STRINGER 2. REPAIRED RIB IAW EA.SDR SWAA2014040126707Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 947.5+4" BETWEEN STRINGERS 25-26L. R & R ANGLE IAW SRM & DWG.SDR SWAA2014033126661Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 400, STRINGER 9L. R & R CLIP IAW DWG & EA.SDR SWAA2014033126620Channel · crackedCHANNEL CRACKED AT BS 540, BETWEEN BL 0 TO LBL 24.5. R & R CHANNEL IAW SRM & DWG.SDR SWAA2014032626547Skin · delaminatedLEFT WING AFT FLAP INBD TE LOWER SKIN DELAMINATED. REPAIRED AFT FLAP IAW SRM.SDR SWAA2014032426406Bracket · crackedPRESS DECK ON CTR SECTION BRACKET CRACKED BETWEEN BS 664 TO BS 675, RBL 32. R & R BRACKET IAW SRM & DWG.SDR SWAA2014032426407Fitting · crackedCLIP CRACKED AT BS 348.2, STRINGER 16L. R & R CLIP IAW SRM & DWG.SDR SWAA2014031926227Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 334, STRINGER 20L. R & R ANGLE IAW SRM & DWG.
Back to Boeing 737-3H4