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 SWAA2014062029249Skin · crackedL2 DOOR SKIN CUT OUT FWD LOWER CORNER CRACKED AT BS 947.5+12, STRINGER 17L. REPAIRED SKIN IAW SRM & EA.SDR SWAA2014061629064Web · crackedLEFT NLG WW WEB CRACKED AT BS 259.5, BETWEEN WL 180 TO WL 182. REPAIRED WEB IAW SRM.SDR SWAA2014053028533Structure · crackedRIGHT SIDE NLG WW AROUND FASTENER HOLE CRACKED AT BS 243.7+3.5, WL 169.1. REPAIRED WW IAW SRM.SDR SWAA2014053028532Structure · crackedRIGHT SIDE NLG WW AROUND FASTENER HOLE CRACKED AT BS 243.7+ 3.5, WL 169.1. REPAIRED WW IAW SRM.SDR SWAA2014053028531Structure · crackedRIGHT SIDE NLG WW CRACKED AROUND FASTENER HOLE AT BS 243.7+ 3.5, WL 169.1. REPAIRED WW IAW SRM.SDR SWAA2014051528042Pressure Deck · crackedMAIN WW PRESS DECK CRACKED AT BS 665, LBL 24.5+7. REPAIRED DECK IAW SRM.SDR SWAA2014051427980Structure · crackedUPPER CHORD CRACKED AT BS 663+2, LBL 24.5. REPAIRED CHORD IAW EA.SDR SWAA2014051427979Floor Support · crackedLONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 727B, LBL 24.8. REPAIRED CHORD IAW EA.SDR SWAA2014050727751Door Frame · crackedR1 DOOR AFT EDGE FRAME CRACKED. REPAIRED FRAME IAW SRM.SDR SWAA2014042927509Plate · crackedPLATE CRACKED AT BS 328, BETWEEN STRINGER 22R TO STRINGER 24R. REPAIRED PLATE IAW SRM.SDR SWAA2014042927508Frame · corrodedFRAME LOWER FLANGE CORRODED AT BS 328, BETWEEN STRINGER 27R TO STRINGER 28R. REPAIRED FRAME IAW SRM.SDR SWAA2014042827391Light · looseEXTERNAL EMERGENCY EXIT LIGHTS LOOSE BETWEEN BS 727D TO BS 727E, BETWEEN STRINGER 22R TO STRINGER 23R. SECURE LIGHT IAW MM.SDR SWAA2014042827382Light · looseEXTERNAL EMERGENCY EXIT LIGHTS LOOSE BETWEEN BS 727D TO BS 727E, BETWEEN STRINGER 22L TO STRINGER 23L. SECURE LIGHT IAW MM.SDR SWAA2014042327325Support Bracket · crackedSUPPORT BRACKET CRACKED AT BS 380, STRINGER 20L. R & R BRACKET IAW SRM & DWG.SDR SWAA2014042227274Angle · crackedANGLE CRACKED AT BS 360, STRINGER 20L. R & R ANGLE IAW SRM & DWG.SDR SWAA2014041627153Slide · low pressureL1 DOOR EMERGENCY EVAC SLIDE LOW PRESS INDICATED. R & R SLIDE IAW MT.SDR SWAA2014041427070Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 380, STRINGER 9L. R & R CLIP IAW SRM.SDR SWAA2014041427069Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 380, STRINGER 8L. R & R CLIP IAW SRM.SDR SWAA2014042427352Support Bracket · crackedSUPPORT BRACKET CRACKED AT BS 294.5, STRINGER 23L. R & R BRACKET IAW SRM & DWG.SDR SWAA2014042227279Skin · crackedRIGHT WING LE KRUEGER FLAP SEAL DOOR SKIN CRACKED AT WBL 213. REPAIRED SKIN IAW EA.SDR SWAA2014042127234Angle · crackedANGLE CRACKED AT BS 328, STRINGER 20L. R & R ANGLE IAW SRM & DWG.SDR SWAA2014042127236Strap · crackedSTRAP CRACKED AT BS 328, LBL 12. R & R STRAP IAW SRM & DWG.SDR SWAA2014042127235Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 336, STRINGER 20L. R & R ANGLE IAW SRM & DWG.SDR SWAA2014041727198Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 312+9, STRINGER 20L. R & R ANGLE IAW SRM & DWG.SDR SWAA2014041627151Gusset · crackedSUPPORT GUSSETS CRACKED AT UPPER ATTACH POINT OF THE LT SUPPORT ROD ON FWD STAB DRUM. R & R GUSSETS IAW SRM & DWG.SDR SWAA2014041427119Light · inoperativeL1 DOOR EXTERNAL EMERGENCY LIGHT INOPERATIVE. RELAMPED LIGHT IAW AMM.SDR SWAA2014041427102Slide · out of adjustL2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUSTMENT. ADJUSTED SLIDE IAW MM & MT.SDR SWAA2014050827801Frame · crackedFRAME OUTER CHORD CRACKED AT BS 348.2, STRINGER 16L. REPAIRED CHORD IAW EA.SDR SWAA2014050827800Frame · crackedFRAME INNER CHORD CRACKED AT BS 348.2, STRINGER 17L. REPAIRED CHORD IAW EA.SDR SWAA2014050227611Attach Fitting · crackedATTACHMENT CLIP CRACKED AT BS 348.2, STRINGER 15L. R & R CLIP IAW SRM & DWG.SDR SWAA2014042427355Stringer · crackedSTRINGER CHANNEL CRACKED AT BS 727, STRINGER 22L. R & R CHANNEL IAW SRM & DWG.SDR SWAA2014042327331Stringer · crackedSTRINGER CRACKED AT BS 471, STRINGER 5L. REPAIRED STRINGER IAW SB.SDR SWAA2014041427103Slide · out of positionR2 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW MM.SDR SWAA2014041427101Sign · brokenR1 DOOR EMERGENCY EXIT SIGN BROKEN. R & R SIGN IAW MM.SDR SWAA2014041427065Skin · crackedRIGHT HORIZONTAL STABILIZER LOWER SURFACE SKIN CRACKED AT REAR SPAR STAB STATION 152.90. REPAIRED SKIN IAW EA.SDR SWAA2014041427064Skin · crackedFORWARD ENTRY DOOR INNER SKIN CRACKED AT LOWER HINGE BOX. R & R L1 DOOR IAW MM.SDR SWAA2014041427063Lens · looseRIGHT OVERWING EMERGENCY EXIT LIGHT LENS COVER LOOSE. SECURED COVER IAW AMM.SDR SWAA2014041427056Battery Pack · dischargedRIGHT LOWER EMERGENCY LIGHT INOPERATIVE AT BS 787. R & R BATTERY PACK IAW MM.SDR SWAA2014041427055Battery Pack · dischargedLEFT EMERGENCY EXIT LIGHT ON BULLNOSE INOPERATIVE. R & R BATTERY PACK IAW MM.SDR SWAA2014050727755Rib · crackedLEFT WING RIB UPPER CHORD CRACKED AT WBL 114, STRINGER 2. REPAIRED CHORD IAW EO & EA.SDR SWAA2014050527671Rib · crackedRIGHT WING UPPER CHORD RIB CRACKED AT WBL 114 AT LEVEL OF STRINGER 2. REPAIRED CHORD IAW EA.SDR SWAA2014050527670Strap · crackedSTRAP CRACKED AT BS 348.2+2, STRINGER 16L. R & R STRAP IAW SRM & DWG.SDR SWAA2014050227610Attach Fitting · crackedATTACH CLIP CRACKED AT BS 348.2, STRINGER 15L. R & R CLIP IAW SRM & DWG.SDR SWAA2014050227609Fitting · crackedCLIP CRACKED AT BS 348.2, STRINGER 15L. R & R CLIP IAW SRM & DWG.SDR SWAA2014043027572Frame · gougedFRAME GOUGED AT BS 400, STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2014042827441Floor Support · crackedLONGITUDINAL FLOORBEAM CTR SECTION WEB CRACKED AT BS 713, RBL 24.8. REPAIRED WEB IAW EA.SDR SWAA2014042827440Floor Support · crackedLONGITUDINAL FLOORBEAM CTR SECTION WEB CRACKED AT BS 709, RBL 24.8. REPAIRED WEB IAW EA.SDR SWAA2014042827439Channel · crackedCHANNEL CRACKED AT BS 727, RBL 3. R & R CHANNEL IAW SRM & DWG.SDR SWAA2014041427108Battery Pack · dischargedRIGHT STOW BIN BULLNOSE EMERGENCY EXIT LIGHTS INOPERATIVE. R & R BATTERY PACK IAW AMM.SDR SWAA2014041427095Slide · out of positionR2 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW MM.
Back to Boeing 737-3H4