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 SWAA2014072330258Skin · crackedLEFT BS 400+10 LOWER AFT WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014072330257Skin · crackedLEFT BS 500C+10 UPPER FWD WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014072330256Skin · crackedLEFT BS 500B+10 UPPER FWD WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014072330255Skin · crackedLEFT BS 500A+10 UPPER FWD WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014072230190Skin · crackedLEFT BS 847+10 UPPER AFT WINDOW CORNER CUT OUT CRACKED. REPAIRED CUT OUT IAW EA.SDR SWAA2014072230189Skin · crackedLEFT BS 520+10 LOWER AFT WINDOW CORNER CUT OUT CRACKED. REPAIRED CUT OUT IAW EA.SDR SWAA2014071730066Skin · crackedRIGHT BS 400+10 LOWER AFT WINDOW SKIN CORNER CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014071730065Skin · crackedRIGHT BS 500A+10 UPPER FWD WINDOW SKIN CORNER CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014071730064Skin · crackedLEFT BS 380+10 UPPER FWD WINDOW SKIN CORNER CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014071630034Skin · crackedRIGHT BS 500A+10 LOWER AFT WINDOW CORNER SKIN CUT OUT CRACKED. REPAIRED SKIN IAW SB.SDR SWAA2014070829748Slide · out of positionR2 DOOR EMER EXIT SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW SIP.SDR SWAA2014072230188Structure · crackedINNER CHORD CRACKED AT BS 348.2 STRINGER 15L. R & R CHORD IAW EA.SDR SWAA2014071730062Fitting · crackedCLIP CRACKED AT BS 348.2 STRINGER 15L. R & R CLIP IAW SRM & DWG.SDR SWAA2014071429953Angle · crackedRIGHT WING TE WBL 204.40 ANGLE CRACKED. R & R ANGLE IAW SRM & DWG.SDR SWAA2014071029858Angle · crackedLEFT WING FIXED TE ANGLE CRACKED AT WBL 198.60. R & R ANGLE IAW SRM & DWG.SDR SWAA2014070829722Sleeve · looseR2 DOOR EMER EVAC SLIDE GIRT BAR SLEEVE LOOSE. SECURED SLEEVE IAW SIP.SDR SWAA0255070130350Skin · crackedSKIN CRACKED AT BS 328 STRINGER 17R. REPAIRED SKIN IAW EA.SDR SWAA2014071730061Skin · delaminatedRIGHT WING INBD FORE FLAP DELAMINATED ON UPPER SURFACE. REPAIRED FORE FLAP IAW SRM.SDR SWAA2014071730060Rib · crackedRIGHT WING FUEL TANK RIB LOWER CHORD CRACKED AT WBL 135.5 BETWEEN STRINGER 2R TO 3R. REPAIRED CHORD IAW EA.SDR SWAA2014071630048Flap · delaminatedLEFT WING INBD FORE FLAP DELAMINATED. REPAIRED FORE FLAP IAW SRM.SDR SWAA2014071630047Flap · delaminatedRIGHT WING INBD FORE FLAP DELAMINATED. REPAIRED FORE FLAP IAW SRM.SDR SWAA2014070829749Lens · missingLEFT EMER EXIT BULLNOSE LIGHT LENS MISSING AT ROW 14. INSTALLED LENS IAW AMM.SDR SWAA2014070829721Spring Assy · out of adjustR1 DOOR EMER EVAC SLIDE GIRT BAR SECURE SPRING OUT OF ADJUSTMENT. ADJUSTED SPRING ASSEMBLY IAW SIP.SDR SWAA2014071630033Light · inoperativeLEFT EMER EXIT LIGHT LAMP INOPERATIVE. R & R LAMP IAW AMM.SDR SWAA2014071630026Light · inoperativeRIGHT EMER EXIT LIGHT LAMP INOPERATIVE. R & R LAMP IAW AMM.SDR SWAA2014071429952Light · inoperativeAFT LAVATORY EMER EXIT LIGHT BULB INOPERATIVE. R & R BULB IAW MM.SDR SWAA2014071429922Bracket · crackedLEFT WING NR 1 FLAP TRACK HINGE SUPPORT ASSEMBLY OTBD BRACKET CRACKED. R & R BRACKET IAW SRM & DWG.SDR SWAA2014071429921Support Bracket · crackedRIGHT WING NR 8 FLAP TRACK ASSEMBLY OTBD CRACKED ON INTERNAL SUPPORT BRACKET. R & R BRACKET IAW SRM & DWG.SDR SWAA2014070829750Cover · looseFORWARD GALLEY EMER EXIT LIGHT COVER LOOSE. R & R COVER IAW MM.SDR SWAA2014080630633Rib · crackedRIGHT WING FORE FLAP OTBD RIB CRACKED AT WBL 213.0. REPAIRED FORE FLAP IAW EO & EA.SDR SWAA2014080630632Skin · crackedRIGHT WING FORE FLAP OTBD SKIN CRACKED. REPAIRED FORE FLAP IAW EO.SDR SWAA2014072530343Crossbeam · crackedAFT CARGO DOOR CROSSBEAM E T CHORD AFT END CRACKED. REPAIRED E T CHORD IAW EA.SDR SWAA2014072330244Angle · crackedANGLE CRACKED BETWEEN BS 348.2 TO 351.2 STRINGER 16L LOWER SURFACE. R & R ANGLE IAW SRM & DWG.SDR SWAA2014072330253Frame · crackedFRAME CHORD CRACKED AT BS 727 STRINGER 18. REPAIRED CHORD IAW EA.SDR SWAA2014072230205Frame · crackedFRAME OTBD CHORD CRACKED AT BS 727 STRINGER 8A LT. REPAIRED CHORD IAW EA.SDR SWAA2014072230204Frame · crackedFRAME OTBD CHORD CRACKED AT BS 727 BETWEEN STRINGER 18A & 27L. REPAIRED CHORD IAW EA.SDR SWAA2014072230203Frame · crackedFRAME OTBD CHORD CRACKED AT BS 727 STRINGER 18R. REPAIRED CHORD IAW EA.SDR SWAA2014071530022Frame · crackedLEFT FRAME INNER CHORD CRACKED AT BS 616 WL 202. REPAIRED CHORD IAW EA.SDR SWAA2014071530021Frame · crackedRIGHT FRAME INNER CHORD CRACKED AT BS 616 WL 208. REPAIRED CHORD IAW EA.SDR SWAA2014071129892Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 312+9, STRINGER 20L. R & R ANGLE IAW SRM & DWG.SDR SWAA2014071029852Tie · crackedSTRINGER TIE CRACKED AT BS 294.5, STRINGER 23L. R & R TIE IAW SRM & DWG.SDR SWAA2014073030481Lug · corrodedLEFT WING NR 4 FLAP TRACK AFT ATTACH POINT, OTBD LUG, OTBD FACE CORRODED ADJACENT TO BUSHING. REPAIRED LUG IAW EA.SDR SWAA2014073030464Rib · crackedRIGHT WING FUEL TANK RIB UPPER WEB CRACKED AT WBL 198.6 STRINGER 5R. REPAIRED WEB IAW EA.SDR SWAA2014072830378Angle · crackedTEE ANGLE CRACKED AT BS 540 BETWEEN STRINGER 22L TO 28L. R & R TEE ANGLE IAW DWG & SRM.SDR SWAA2014072530319Web · corrodedFORWARD CARGO DOOR CUT OUT WEB CORRODED AT BS 490, STRINGER 18R TO 19R. REPAIRED WEB IAW SRM & DWG.SDR SWAA2014080630631Door Frame · crackedFORWARD GALLEY DOOR FRAME CRACKED ON FWD LOWER CORNER. REPAIRED FRAME IAW EO.SDR SWAA2014072830377Door Frame · crackedFORWARD GALLEY DOOR FRAME CRACKED ON AFT LOWER CORNER. R & R FRAME IAW SRM & DWG.SDR SWAA2014072830376Stiffener · crackedBULKHEAD ZEE DOME STIFFENER CRACKED AT BS 1016 LBL 5. REPAIRED STIFFENER CRACKED IAW EO & EA.SDR SWAA2014072330243Angle · crackedANGLE CRACKED BETWEEN BS 348.2 TO 351.2 STRINGER 16L. R & R ANGLE IAW SRM & DWG.SDR SWAA2014072330242Strap · crackedSTRAP CRACKED AT BS 348.2 STRINGER 16L. R & R STRAP IAW SRM & DWG.
Back to Boeing 737-3H4