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 SWAA2014093032465Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 908 STRINGER 8R. R & R CLIP IAW DWG & SRM.SDR SWAA2014093032432Angle · crackedCLIP ANGLE CRACKED AT BS 348.2 STRINGER 16L. R & R ANGLE IAW SRM & DWG.SDR SWAA2014091832081Slide · looseL1 DOOR EMER EVAC SLIDE LOOSE. SECURED SLIDE IAW MT.SDR SWAA2014091732072Spoiler · delaminatedLEFT WING NR 1 FLIGHT SPOILER DELAMINATED. R & R NR 1 SPOILER IAW MM.SDR SWAA2014100932817Floor Support · crackedLONGITUDINAL FLOORBEAM WEB CRACKED AT BS 710 LBL 24.5. REPAIRED WEB IAW EA.SDR SWAA2014100932816Floor Support · crackedLONGITUDINAL FLOORBEAM WEB CRACKED AT BS 709 LBL 24.5. REPAIRED WEB IAW EA.SDR SWAA2014100932815Fitting · crackedCLIP CRACKED AT BS 947.5 BETWEEN STRINGER 24R TO 25R. R & R CLIP IAW SRM & DWG.SDR SWAA2014100932814Tie Clip · crackedTIE CLIP CRACKED AT BS 947.5 STRINGER 25R. R & R TIE CLIP IAW EA.SDR SWAA2014100832761Frame · crackedFRAME WEB CRACKED AT BS 616 STRINGER 16R. REPAIRED FRAME IAW EA & ER.SDR SWAA2014100732721Pressure Deck · crackedMAIN WW PRESS DECK WEB CRACKED AT BS 673 RBL 43. REPAIRED WEB IAW SRM.SDR SWAA2014100332618Web · crackedWEB CRACKED BETWEEN BS 986 TO 1016 LBL 45. R & R WEB IAW SRM & DWG.SDR SWAA2014100232524Angle · crackedANGLE CRACKED BETWEEN BS 927 TO 947.5 BL 0. R & R ANGLE IAW SRM & DWG.SDR SWAA2014100232523Tie Clip · crackedTIE CLIP CRACKED AT BS 907 STRINGER 1. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014092932365Stringer · corrodedSTRINGER CORRODED AT BS 1006 STRINGER 27L. REPAIRED STRINGER IAW SRM.SDR SWAA2014092532298Tie Clip · crackedTIE CLIP CRACKED AT BS 727D STRINGER 20L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014092532297Tie Clip · crackedTIE CLIP CRACKED AT BS 727B STRINGER 25L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014092532296Tie Clip · crackedTIE CLIP CRACKED AT BS 727A STRINGER 26R. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014092432250Angle · crackedANGLE CRACKED AT BS 907, BETWEEN STRINGER 1 TO 2L. R & R ANGLE IAW SRM & DWG.SDR SWAA2014092432262Angle · crackedFLOORBEAM INTERSECTION ANGLE CRACKED AT BS 727B RBL 45.5. R & R ANGLE IAW SRM & DWG.SDR SWAA2014091632031Lens · brokenAFT EMER EXIT LIGHT LENS COVER BROKEN. SECURED COVER IAW AMM.SDR SWAA2014100832758Gusset · crackedFORWARD CARGO COMPARTMENT GUSSET CRACKED AT BS 500D STRINGER 19L. R & R GUSSET IAW SRM & DWG.SDR SWAA2014100832757Gusset · crackedFORWARD CARGO COMPARTMENT GUSSET CRACKED AT BS 500D STRINGER 19R. R & R GUSSET IAW SRM & DWG.SDR SWAA2014100632643Plate · crackedLEFT HORIZONTAL STABILIZER ACCESS PANEL 9126 PLATE CRACKED. R & R PLATE IAW SRM.SDR SWAA2014100632642Support Angle · crackedFORWARD CARGO COMPARTMENT SUPPORT ZEE CRACKED AT BS 480+16 STRINGER 26L. REPAIRED SUPPORT ZEE IAW SRM.SDR SWAA2014100332617Fitting · crackedCOMPRESSION BEAM SPLICE FITTING CRACKED AT BS 727 LBL 45.5. REPAIRED FITTING IAW SRM & DWG.SDR SWAA2014100332616Fitting · crackedCOMPRESSION BEAM SPLICE FITTING CRACKED AT BS 727 RBL 45.5. REPAIRED FITTING IAW SRM & DWG.SDR SWAA2014100232522Channel · crackedSTRINGER SPLICE CHANNEL CRACKED AT BS 360 STRINGER 14L. R & R CHANNEL IAW SRM & DWG.SDR SWAA2014100232521Frame · crackedFRAME CRACKED AT BS 847 BETWEEN STRINGER 1 TO 2L. REPAIRED FRAME IAW SRM.SDR SWAA2014100232520Channel · crackedSTRINGER SPLICE CHANNEL CRACKED AT BS 360 STRINGER 14L. R & R CHANNEL IAW SRM & DWG.SDR SWAA2014100232519Stringer · crackedSTRINGER CRACKED AT BS 380 STRINGER 15R. REPAIRED STRINGER IAW SRM.SDR SWAA2014093032431Stringer Splice · crackedSTRINGER SPLICE CRACKED AT BS 907 STRINGER 4R. R & R SPLICE IAW SRM & DWG.SDR SWAA2014093032430Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 348.2 STRINGER 16L. R & R ANGLE IAW SRM & DWG.SDR SWAA2014093032429Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 348.2 STRINGER 16L. R & R ANGLE IAW SRM & DWG.SDR SWAA2014092432249Intercostal · crackedINTERCOSTAL CRACKED AT BS 540, BETWEEN BL 0 & LBL 24.5. R & R INTERCOSTAL IAW SRM & DWG.SDR SWAA2014092232184Cover · crackedAFT DOOR EMER EXIT BULLNOSE SIGN COVER CRACKED. R & R COVER IAW MM.SDR SWAA2014092232153Tie Clip · crackedTIE CLIP CRACKED AT BS 400 STRINGER 8L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014101432910Frame · corrodedAFT CARGO PIT FRAME CORRODED AT BS 907 BETWEEN RBL 5 TO LBL 5. R & R FRAME IAW SRM & DWG.SDR SWAA2014101032850Frame · crackedFUSELAGE FRAME CRACKED AT STATION 706 STRINGER 11R. REPAIRED FRAME IAW EA.SDR SWAA2014100932813Floor Support · crackedLONGITUDINAL FLOORBEAM LOWER WEB CRACKED AT BS 717 LBL 0.07. REPAIRED WEB IAW EA.SDR SWAA2014100932822Skin · crackedLEFT BS 380 LOWER AFT WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014100932821Skin · crackedLEFT BS 360 UPPER FWD WINDOW CORNER SKIN CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014100732717Skin · crackedFUSELAGE SKIN CRACKED AT BS 298 STRINGER 21R. REPAIRED SKIN IAW ER & EA.SDR SWAA2014100732716Support Fitting · corrodedRIGHT OVERWING EMER EXIT HATCH LOWER DOOR HANDLE SUPPORT FITTING CORRODED. R & R FITTING IAW SRM & DWG.SDR SWAA2014100732715Support Fitting · corrodedLEFT OVERWING EMER EXIT HATCH LOWER DOOR HANDLE SUPPORT FITTING CORRODED. R & R FITTING IAW SRM & DWG.SDR SWAA2014100732727Skin · crackedLEFT BS 500C LOWER AFT WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014100732726Skin · crackedLEFT BS 520 LOWER AFT WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014100732725Skin · crackedLEFT BS 360 LOWER AFT WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014100232561Skin · crackedLEFT BS 500A LOWER AFT WINDOW CORNER SKIN CRACKED. REPAIRED SKIN IAW SB.SDR SWAA2014100232560Skin · crackedLEFT BS 500B LOWER AFT WINDOW CORNER SKIN CRACKED. REPAIRED SKIN IAW SB.SDR SWAA2014100232559Skin · crackedLEFT BS 500 LOWER AFT WINDOW CORNER SKIN CRACKED. REPAIRED SKIN IAW SB.
Back to Boeing 737-3H4