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 SWAA2015012636073Lens · looseR2 DOOR EMER LIGHT LENS LOOSE. R & R LIGHT ASSEMBLY IAW AMM.SDR SWAA2015031237376Flap Track · corrodedLEFT WING NR 2 FLAP TRACK CORRODED AT AFT ATTACH PAD. REPAIRED FLAP TRACK IAW AMM.SDR SWAA2015031237374Flap Track · corrodedRIGHT WING NR 8 FLAP TRACK CORRODED AT AFT ATTACH PAD UNDER SHIM. R & R FLAP TRACK IAW AMM.SDR SWAA2015022736967Flap Track · corrodedLEFT WING NR 1 FLAP TRACK CORRODED AT AFT ATTACH PAD UNDER SHIM. R & R NR 1 FLAP TRACK IAW AMM.SDR SWAA2015020536354Beam · corrodedVERTICAL BEAM CORRODED AT BS 540, LBL 15.04. REPAIRED VERTICAL BEAM IAW EA & SRM.SDR SWAA2015012836158Stringer Splice · crackedSPLICE CRACKED AT BS 908, STRINGER 5L. R & R SPLICE IAW DWG & SRM.SDR SWAA2015012736121Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 578, STRINGER 1. R & R CLIP IAW SRM & DWG.SDR SWAA2015012736120Lens · crackedL1 DOOR EMER EXIT SIGN LENS COVER CRACKED. R & R COVER IAW AMM.SDR SWAA2015012235978Lens · brokenLEFT OVERWING EMER EXIT LIGHT LENS COVER BROKEN. R & R COVER IAW MM.SDR SWAA2015012235950Plate · looseRIGHT EMER EXIT LIGHT COVER PLATE LOOSE. R & R PLATE IAW MM.SDR SWAA2015012135923Slide · out of positionR1 DOOR EMER EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW MT.SDR SWAA2015030937249Panel · corrodedRIGHT WING FUEL PANEL 8817 CORRODED AROUND ALL HARDWARE HOLES INTERNAL SKIN. R & R PANEL IAW EA.SDR SWAA2015022436858Fitting · crackedVERTICAL STABILIZER FLANGE CLIP ON PANEL 9507 CRACKED. R & R CLIP IAW SRM & AMM.SDR SWAA2015021236561Skin · crackedSKIN CRACKED AT BS 360 BETWEEN STRINGER 3R TO 4R. REPAIRED SKIN IAW EA.SDR SWAA2015020636381Shear Tie · crackedCENTER WING TANK SHEAR TIE CRACKED AT BS 540, LBL 57. R & R SHEAR TIE IAW SRM & DWG.SDR SWAA2015012235951Lens · missingLEFT EMER LIGHT LENS MISSING AT ROW 18. INSTALLED LENS IAW MM.SDR SWAA2015020336300Spoiler · delaminatedRIGHT WING NR 8 SPOILER DELAMINATED. R & R NR 8 SPOILER IAW AMM.SDR SWAA2015012035920Slide · looseR2 DOOR EMER EVAC SLIDE LOOSE OF CONTAINER. SECURED SLIDE IAW MT.SDR SWAA2015012035910Sign · looseRIGHT OVERWING EXIT SIGN LOOSE. SECURED SIGN IAW SIP.SDR SWAA2015012035903Lens · missingLEFT EMER LIGHT LENS MISSING AT ROW 10. INSTALLED LENS IAW MM.SDR SWAA2015020136527Spar · crackedLEFT WING REAR SPAR WEB CRACKED AT EACH FASTENER HOLE RSS 222.2, UPPER ROW, 4TH HOLE INBD. REPAIRED WEB IAW EA & ER.SDR SWAA2015030337066Shear Tie · crackedSHEAR TIE CRACKED AT BS 336, STRINGER 20L. R & R SHEAR TIE IAW SRM & DWG.SDR SWAA2015021736674Angle · crackedFLOORBOARD SUPPORT CHORD ANGLE STRUCTURE CRACKED AT BS 351.2, LBL 11.10. R & R ANGLE IAW SRM.SDR SWAA2015011935873Skin · delaminatedLEFT WING NR 2 FLIGHT SPOILER UPPER SURFACE DELAMINATED. R & R NR 2 SPOILER IAW AMM.SDR SWAA2015020936419Skin · crackedFUSELAGE SKIN CRACKED AT BS 360, STRINGER 6R. REPAIRED SKIN IAW EA.SDR SWAA2015012235981Splice Plate · crackedSPLICE PLATE CRACKED AT BS 540, BETWEEN STRINGER 12L - 13L. R & R SPLICE PLATE IAW DWG.SDR SWAA2015011935874Slide · low pressureR1 DOOR EMER EVAC SLIDE PRESS LOW. R & R SLIDE IAW TC.SDR SWAA2015011935872Power Supply · inoperativeL2 DOOR EXIT LIGHT INOPERATIVE. R & R POWER SUPPLY IAW AMM.SDR SWAA2015011635817Slide · looseR1 DOOR EMER EVAC SLIDE LOOSE. SECURED SLIDE ASSEMBLY IAW MT.SDR SWAA2015021836703Fitting · dirtyL1 DOOR EMER EVAC SLIDE LT FWD GIRT BAR FITTING DIRTY. CLEANED FITTING IAW MM.SDR SWAA2015012636070Slat · crackedRIGHT WING NR 5 SLAT LOWER LE 40 INCHES FROM OTBD END CRACKED. REPAIRED NR 5 SLAT IAW SRM.SDR SWAA2015012636069Slat · crackedRIGHT WING NR 5 SLAT LOWER LE 2 INCHES FROM INBD END CRACKED. REPAIRED NR 5 SLAT IAW SRM.SDR SWAA2015012135932Stringer · crackedSTRINGER CRACKED BETWEEN BS 922 TO 1016, STRINGER 9L. R & R STRINGER IAW DWG & SRM.SDR SWAA2015012135930Battery Pack · damagedLEFT EMER BATTERY PACK POWER SUPPLY CEILING OVERHEAD DAMAGED AT BS 967. R & R BATTERY PACK IAW AMM.SDR SWAA2015011935886Fairing · delaminatedRIGHT WING INBD FLAP OTBD TRACK FAIRING DELAMINATED AT OTBD SIDE. R & R FAIRING IAW AMM.SDR SWAA2015011635819Sign · out of adjustRIGHT OVERWING EXIT SIGN OUT OF ADJUSTMENT. ADJUSTED SIGN IAW AMM.SDR SWAA2015011635818Skin · delaminatedLEFT WING INBD MID FLAP TE WEDGE, LOWER INBD SKIN DELAMINATED. R & R WEDGE IAW MM.SDR SWAA2015011635816Structure · crackedRIGHT SIDE REAR HORIZONTAL STABILIZER CTR SECTION, CRACK INDICATION AROUND UPPER OTBD LOCK FASTENER COLLAR. REPAIRED STABILIZER IAW EA.SDR SWAA2015031137332Floor Support · crackedLONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 670, LBL 24.5. R & R CHORD IAW SRM & EA.SDR SWAA2015030337071Support Angle · corrodedFRAME SUPPORT ANGLE CORRODED ON AFT SIDE OF FRAME AT BS 827, STRINGER 26R. R & R ANGLE IAW SRM.SDR SWAA2015030337065Tie · crackedSTRINGER TIE CRACKED AT BS 787, STRINGER 23R. R & R TIE IAW DWG & SRM.SDR SWAA2015030237021Floor Support · crackedLONGITUDINAL FLOORBEAM CRACKED BETWEEN BS 707 TO 709, RBL 24.8. REPAIRED FLOORBEAM IAW EA.SDR SWAA2015022436857Floorbeam · crackedLONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 727B, LBL 24.8. R & R FLOORBEAM IAW SRM & DWG.SDR SWAA2015012135931Shear Tie · crackedSHEAR TIE CRACKED AT BS 440, BETWEEN STRINGER 13R TO 14R. R & R SHEAR TIE IAW DWG.SDR SWAA2015012035909Wire · damagedAFT GALLEY OVERHEAD EMER LIGHT WIRE DAMAGED AT BS 960. REPAIRED WIRE IAW AMM.SDR SWAA2015012035908Wire · damagedAFT GALLEY OVERHEAD EMER LIGHT WIRE DAMAGED AT -1' FROM CONNECTOR D2966. REPAIRED WIRE IAW AMM.SDR SWAA2015012035907Wire · damagedAFT GALLEY OVERHEAD EMER LIGHT WIRE DAMAGED AT BS 975. REPAIRED WIRE IAW AMM.SDR SWAA2015012035902Wire · damagedAFT GALLEY OVERHEAD EMER LIGHTING WIRE DAMAGED AT BULLNOSE EXIT SIGN. REPAIRED WIRE IAW WDM.SDR SWAA2015012035896Wire · damagedAFT GALLEY OVERHEAD EMER LIGHTING WIRE DAMAGED. REPAIRED WIRE IAW WDM.SDR SWAA2015011935879Stringer Splice · crackedSTRINGER SPLICE CRACKED AT BS 360, STRINGER 14R. R & R SPLICE IAW DWG.
Back to Boeing 737-3H4