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 SWAA2014091531972Angle · crackedINTERCOSTAL WEB ANGLE CRACKED BETWEEN BS 348 TO 351, STRINGER 16L. R & R ANGLE IAW EA.SDR SWAA2014091531971Frame · crackedLEFT FRAME INNER CHORD LOWER INBD CRACKED AT BS 348 WL 208. R & R CHORD IAW EA.SDR SWAA2014091531993Frame · crackedFRAME OUTER CHORD CRACKED AT BS 348 STRINGER 16L. REPAIRED CHORD IAW EA.SDR SWAA2014091531975Fitting · crackedINTERCOSTAL CLIP CRACKED AT BS 348 STRINGER 15L. R & R CLIP IAW EA.SDR SWAA2014091531974Angle · crackedINTERCOSTAL ANGLE CRACKED AT BS 348 STRINGER 15L. R & R ANGLE IAW EA.SDR SWAA2014091131846Skin · crackedAFT CARGO DOOR CUT OUT LOWER FWD CORNER CRACKED FROM FASTENER HOLE TO CUT OUT. REPAIRED CUT OUT IAW SRM.SDR SWAA2014091131823Slat · delaminatedRIGHT WING NR 5 SLAT OTBD AFT EDGE DELAMINATED. REPAIRED NR 5 SLAT IAW SRM.SDR SWAA2014091131822Attach Fitting · crackedATTACHMENT CLIP CRACKED AT BS 639 LBL 45.5. R & R CLIP IAW SRM & DWG.SDR SWAA2014091031798Threshold · corrodedAFT CARGO PIT THRESHOLD WEB CORRODED. R & R WEB IAW SRM & DWG.SDR SWAA2014090931686Attach Fitting · crackedLONGITUDINAL FLOORBEAM ATTACHMENT CLIP CRACKED AT BS 639 RBL 45. R & R CLIP IAW SRM & DWG.SDR SWAA2014090831630Skin · crackedFUSELAGE SKIN CRACKED AT BS 520+7, STRINGER 28R. REPAIRED SKIN IAW SRM.SDR SWAA2014090231451Light · brokenFORWARD ENTRY DOOR EMER EXIT LIGHT ASSEMBLY BROKEN. R & R LIGHT ASSEMBLY IAW MM.SDR SWAA2014090231454Ballast · malfunctionedAIR TURN BACK FLIGHT ATTENDANTS REPORTED STRONG SMELL OF BURNING RUBBER IN AFT GALLEY. R & R BALLAST IAW MM.SDR SWAA2016030349605Support Fitting · corrodedRIGHT WING NR 5 INBD TRACK BORE SUPPORT FITTING CORRODED. REPAIRED FITTING IAW EA.SDR SWAA2014092232172Web · crackedLEFT NOSE WW SIDE WEB CRACKED AT BS 243.7+ 3.5 WL 169.1. REPAIRED WEB IAW EO & EA.SDR SWAA2014091632032Light · inoperativeRIGHT EMER EXIT LAMP INOPERATIVE. R & R LAMP IAW CMM.SDR SWAA2014091031792Access Panel · crackedACCESS PANEL 9508 PLATE CRACKED. R & R PANEL IAW SRM & DWG.SDR SWAA2014090431608Slide · out of adjustR1 DOOR EMER EVAC SLIDE OUT OF ADJUSTMENT. ADJUSTED SLIDE IAW MM.SDR SWAA2014090231516Bellcrank · crackedRIGHT WING INBD K FLAP BULLNOSE LINK BELL CRANK ASSEMBLY BROKEN. R & R BELL CRANK ASSEMBLY IAW AMM.SDR SWAA2014092932361Buttstrap · crackedBUTT STRAP CRACKED AT BS 360 STRINGER 14R. REPAIRED BUTT STRAP IAW EA.SDR SWAA2014092332213Frame · crackedFRAME OTBD CHORD FWD FLANGE CRACKED AT BS 727, STRINGER 18A LT FWD LOWER HOLE. REPAIRED CHORD IAW EA.SDR SWAA2014092232171Skin · crackedSKIN CRACKED AT BS 927+3.5 STRINGER 21R. REPAIRED SKIN IAW EO & EA.SDR SWAA2014092232170Pressure Deck · crackedMAIN WW PRESS DECK WEB CRACKED AT BS 663.75 LBL 33.5. REPAIRED WEB IAW EA.SDR SWAA2014092232169Pressure Deck · crackedMAIN WW PRESS DECK WEB CRACKED AT BS 663.75 LBL 18.5. REPAIRED WEB IAW EA.SDR SWAA2014092232168Seat Track · crackedCENTER WING BOX SEAT TRACK CRACKED AT BS 727B LBL 24.8. REPAIRED SEAT TRACK IAW EA.SDR SWAA2014092232167Frame · crackedFRAME OTBD CHORD FWD FLANGE CRACKED AT BS 727 STRINGER 18A RT SIDE. R & R CHORD IAW EA.SDR SWAA2014092232166Frame · crackedFRAME OTBD CHORD FWD FLANGE CRACKED AT BS 727 STRINGER 18A LT SIDE. R & R CHORD IAW EA.SDR SWAA2014091832094Skin · crackedRIGHT WING LE SKIN ON KRUEGER FLAP LE CRACKED AT STATION 208. REPAIRED SKIN IAW EO & EA.SDR SWAA2014091531952Balance Weight · corrodedRUDDER LE STATION 131, CTR BALANCE WEIGHT CORRODED BETWEEN MOUNT FLANGE & WEIGHT. R & R RUDDER IAW AMM.SDR SWAA2014090931729Tee Fitting · corrodedRIGHT MLG WW HORIZONTAL TEE CORRODED AT BS 710. R & R TEE IAW EO & EA.SDR SWAA2014090931728Tee Fitting · corrodedRIGHT MLG WW VERTICAL TEE CORRODED AT BS 710. R & R TEE IAW EO & EA.SDR SWAA2014090931690Pressure Deck · crackedMAIN WW PRESS DECK WEB CRACKED AT BS 663.75+2, RBL 42.5. REPAIRED WEB IAW SRM.SDR SWAA2014090231480Door Frame · crackedAFT CARGO DOOR LOWER FRAME CRACKED. R & R DOOR IAW AMM.SDR SWAA2014082931436Spoiler · crackedLEFT WING INBD SPOILER CRACKED. R & R SPOILER IAW AMM.SDR SWAA2014082931434Lens · looseLEFT EMER EXIT SIGN LENS LOOSE. SECURED SIGN IAW EA.SDR SWAA2014091131841Skin · delaminatedLEFT WING INBD FORE FLAP DELAMINATED ON LOWER SKIN. REPAIRED FORE FLAP IAW SRM.SDR SWAA2014090231499Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 440 STRINGER 14L. R & R CLIP IAW SRM & DWG.SDR SWAA2014082931442Fastener · missingSTRINGER SPLICE UPPER FLANGE FASTENERS MISSING AT BS 908 STRINGER 9L. INSTALLED FASTENER IAW SRM & DWG.SDR SWAA2014082931435Mount Bracket · looseRIGHT WING INBD GND SPOILER INBD ACTUATOR FWD MOUNT BRACKET LOOSE. R & R BRACKET IAW SRM.SDR SWAA2014082931422Cover · brokenR2 DOOR EMER EVAC SLIDE FWD GIRT BAR HOLDER COVER BROKEN. R & R SLIDE COVER IAW MT.SDR SWAA2014082831391Light · inoperativeL1 DOOR EMER EXIT LIGHT INOPERATIVE. REPAIRED BULB IAW AMM.SDR SWAA2014091531964Duct · crackedDUCT ASSEMBLY CRACKED, LOCATED ABOVE RACK E1-1 AT E & E COMPARTMENT. R & R DUCT ASSEMBLY IAW SRM & DWG.SDR SWAA2014091531963Tie Clip · crackedSUPPORT TIE CLIP CRACKED AT BS 294.5 STRINGER 23L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014090931752Splice · crackedSPLICE ANGLE CRACKED AT BS 360 STRINGER 11L. R & R SPLICE IAW SRM & EA.SDR SWAA2014090231546Tie Clip · crackedTIE CLIP CRACKED AT BS 380 STRINGER 22L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014090231541Tie Clip · crackedTIE CLIP CRACKED AT BS 380 STRINGER 24L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014090231485Crease Beam · corrodedL1 DOOR FLOOR STRUCTURE CREASE BEAM CORRODED. R & R BEAM IAW SRM & DWG.SDR SWAA2014082831393Skin · crackedAFT CARGO DOOR SKIN OUTER HANDLE CUT OUT CRACKED AT RADIUS OF UPPER AFT CORNER. REPAIRED SKIN IAW EA.SDR SWAA2014091632044Web · corrodedWEB CORRODED BETWEEN BS 500A TO 500B STRINGER 17R. R & R WEB IAW SRM & DWG.SDR SWAA2014091531962Stringer Splice · corrodedSTRINGER SPLICE CORRODED AT BS 907+4 STRINGER 18L. R & R SPLICE IAW SRM & DWG.
Back to Boeing 737-3H4