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 SWAA2013032113907Slide · out of adjustR1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MT.SDR SWAA2013032113910Slide · out of adjustR2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MT.SDR SWAA2013031913776Spoiler · brokenLEFT WING GROUND SPOILER O/B ATTACHMENT POINT FOR ACTUATOR BROKEN. REMOVED AND REPLACED SPOILER PER MM.SDR SWAA2013031913842Slide · low pressureR2 DOOR EMERGENCY EVAC SLIDE PRESSURE LOW. REMOVED AND REPLACED SLIDE PER M/M AND MT.SDR SWAA2013041614890Floorbeam · crackedFLOORBEAM CRACKED AT BS 947.5, LBL 53. REPAIRED CHORD PER EA.SDR SWAA2013041514820Skin · crackedFORWARD GALLEY DOOR CUTOUT AFT LOWER CORNER BETWEEN BS 332.1, STR 17R+3 CRACKED. REPAIRED SKIN IAW EA AND EO.SDR SWAA2013041014668Frame · corrodedFRAME CORRODED AT BS 847, BETWEEN STR 27L AND STR 27R. REPAIRED FRAME IAW SRM AND DWG.SDR SWAA2013040914619Frame · crackedFRAME CRACKED AT BS 947.5, BETWEEN STR 24R TO STR 25R. REMOVED AND REPLACED FRAME IAW SRM AND DRAWING.SDR SWAA2013040914618Stringer Splice · corrodedSTRINGER SPLICE CORRODED AT BS 887+17, STR 25L. REMOVED AND REPLACED SPLICE IAW SRM AND DWG.SDR SWAA2013040914603Angle · crackedLEFT WING INTERNAL ANGLE FIXED TRAILING EDGE CAVITY CRACKED AT RSS 533 +15. REMOVED AND REPLACED ANGLE IAW SRM AND DRAWING.SDR SWAA2013040914602Frame · corrodedFRAME CORRODED AT BS 727B, BETWEEN STR 26L AND STR 25L. REPAIRED FRAME IAW SRM.SDR SWAA2013040914599Web · corrodedWEB CORRODED BETWEEN BS 727A AND BS 727B, STR 26L. REPAIRED WEB IAW SRM AND DRAWING.SDR SWAA2013040914598Frame · corrodedFRAME CORRODED AT BS 747, BETWEEN STR 26R AND STR 27R. REPAIRED FRAME PER SRM.SDR SWAA2013040914596Frame · corrodedFRAME CORRODED AT BS 727E, BETWEEN STR 27R AND STR 27L. REPAIRED FRAME IAW.SDR SWAA2013040914595Frame · corrodedFRAME CORRODED AT BS 907, BETWEEN STR 27R AND STR 27L. REPAIRED FRAME IAW SRM.SDR SWAA2013040914587Tie Clip · corrodedTIE CLIP CORRODED AT BS 807, STR 27R. REMOVED AND REPLACED TIE CLIP IAW SRM AND DRAWING.SDR SWAA2013040914545Fitting · crackedCLIP CRACKED AT BS 348.2, STR 15L. REMOVED AND REPLACED CLIP IAW BAC DWG.SDR SWAA2013040314464Structure · crackedNLG WHEEL WELL CRACKED AT BS 243.7+2, WL 169.1. REPAIRED WHEEL WELL IAW SRM.SDR SWAA2013040314460Fitting · crackedINTERCOSTAL CLIP CRACKED AT BS 348.2, STR 16L. REMOVED AND REPLACED CLIP IAW SRM.SDR SWAA2013040314459Intercostal · crackedINTERCOSTAL CRACKED AT BS 348.2, STR 16L. REMOVED AND REPLACED INTERCOSTAL IAW SRM AND BAC DWG.SDR SWAA2013040314431Frame · crackedFRAME CRACKED AT BS 500B, BETWEEN STR 20L AND STR 21L. REPAIRED FRAME IAW SRM.SDR SWAA2013040314430Stiffener · crackedSTIFFENER CRACKED AT BS 727, STR 27L. REMOVED AND REPLACED STIFFENER PER SRM AND DWG.SDR SWAA2013040314429Tie Clip · corrodedTIE CLIP CORRODED AT BS 867, STR 27R. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2013040314428Channel · crackedCHANNEL CRACKED AT BS 540, BETWEEN BL 0 TO LBL 24.75. REMOVED AND REPLACED CHANNEL IAW SRM AND DRAWING.SDR SWAA2013040314427Angle · crackedANGLE CRACKED AT BS 947.5, STR 24R. REMOVED AND REPLACED ANGLE IAW SRM AND DWG.SDR SWAA2013040214350Frame · crackedFRAME CRACKED AT BS 500B, BETWEEN STR 20L AND STR 21L. REPAIRED FRAME IAW SRM.SDR SWAA2013040214349Shear Tie · corrodedSHEAR TIE CORRODED AT BS 827, BETWEEN STR 25R AND STR 26R. REMOVED AND REPLACED SHEAR TIE IAW SRM AND DRAWING.SDR SWAA2013040114337Channel · crackedCHANNEL CRACKED AT BS 540, BETWEEN BL 0 TO RBL 24.75. REMOVED AND REPLACED CHANNEL IAW SRM AND DRAWING.SDR SWAA2013040114290Tie Clip · corrodedTIE CLIP CORRODED AT BS 867, STR 27L. REMOVED AND REPLACED TIE CLIP PER SRM AND DRAWING.SDR SWAA2013040114289Angle · crackedFRAME ANGLE CRACKED AT BS 947.5, STR 24L. REMOVED AND REPLACED ANGLE IAW SRM AND DWG.SDR SWAA2013032614114Strap · crackedSTRAP CRACKED AT BS 328, LBL 11. REMOVED AND REPLACED STRAP IAW SRM.SDR SWAA2013032614113Strap · crackedSTRAP CRACKED AT BS 328, LBL 45. REMOVED AND REPLACED STRAP IAW SRM.SDR SWAA2013032614129Strap · crackedSTRAP CRACKED AT BS 328, RBL 31.6. REMOVED AND REPLACED STRAP IAW SRM.SDR SWAA2013032614115Strap · crackedSTRAP CRACKED AT BS 312, BL 0. REMOVED AND REPLACED STRAP IAW SRM.SDR SWAA2013032113913Skin · crackedFUSELAGE SKIN CRACKED AT BS 597+5, STR 9R. REPAIRED SKIN IAW EA.SDR SWAA2013031913805Slide · out of positionR2 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MT.SDR SWAA2013031913794Slide · low pressureL1 DOOR EMERGENCY EXIT SLIDE PRESSURE LOW. REMOVED AND REPLACED SLIDE IAW MT.SDR SWAA2013031913793Lens · missingAFT CABIN CEILING EMERGENCY EXIT LIGHT LENS MISSING. REMOVED AND REPLACED LENS ASSY IAW AMM.SDR SWAA2013042415184Pressure Deck · crackedMAIN WHEEL WELL PRESSURE DECK WEB CRACKED AT BS 664, LBL 39.5. REPAIRED WEB IAW EA.SDR SWAA2013041214801Fitting · crackedANGLE CLIP CRACKED AT BS 540 AND AT LEVEL FWD CARGO COMPARTMENT. REMOVED AND REPLACED CLIP IAW SRM AND DRAWING.SDR SWAA2013040914594Support Angle · crackedRIGHT WING SUPPORT ANGLE CRACKED AT RSS 533+12" FIXED TRAILING EDGE. REMOVED AND REPLACED ANGLE IAW SRM AND DRAWING.SDR SWAA2013040914593Angle · crackedRIGHT WING CRACK ON ANGLE RSS 533+12" FIXED TRAILING EDGE. REMOVED AND REPLACED ANGLE IAW SRM AND DRAWING.SDR SWAA2013040914586Angle · crackedANGLE CRACKED AT BS 927, STR 25L. REMOVED AND REPLACED ANGLE IAW SRM AND DRAWING.SDR SWAA2013040914567Retainer · crackedRIGHT WING SEAL RETAINER CRACKED AT AFT EDGE OF FLAP TRACK FAIRING ACCESS #3601R. REMOVED AND REPLACED RETAINER IAW SRM AND DRAWING.SDR SWAA2013040914566Stringer Splice · corrodedSTRINGER SPLICE CORRODED AT BETWEEN BS 492 TO BS 500, STR 21R. REMOVED AND REPLACED SPLICE IAW SRM AND DRAWING.SDR SWAA2013040314463Angle · crackedANGLE CRACKED AT BS 947.5, STR 25R. REMOVED AND REPLACED ANGLE PER SRM AND DWG.SDR SWAA2013040314462Angle · crackedANGLE CRACKED AT BS 947.5, STR 25L. REMOVED AND REPLACED ANGLE PER SRM AND DWG.SDR SWAA2013040114336Tie Clip · crackedTIE CLIP CRACKED AT BS 500A, STR 22R. REMOVED AND REPLACED TIE CLIP IAW SRM AND DRAWING.SDR SWAA2013040114335Tie Clip · crackedTIE CLIP CRACKED AT BS 500, STR 18L. REMOVED AND REPLACED TIE CLIP IAW SRM AND DRAWING.SDR SWAA2013032814217Shear Tie · crackedSHEAR TIE CRACKED AT BS 927, BETWEEN STR 4L AND STR 5L. REMOVED AND REPLACED SHEAR TIE IAW SRM.
Back to Boeing 737-3H4