Boeing 737-5H4
Service difficulty reports · 8,230
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 = '7375H4' 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 = '7375H4' 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 SWAA2013111122148Skin · crackedFUSELAGE SKIN CRACKED AT BS 747+13, STRINGER 18L. REPAIRED SKIN IAW SRM.SDR SWAA2013111122147Skin · crackedFUSELAGE SKIN CRACKED AT BS 807+13.5, STRINGER 23L. REPAIRED SKIN IAW SRM.SDR SWAA2013111122146Skin · crackedSKIN CRACKED AT BS 747+ 4.5, STRINGER 25L. REPAIRED SKIN IAW SRM.SDR SWAA2013111122088Skin · crackedFUSELAGE SKIN CRACKED AT BS 787+13, STRINGER 24L. REPAIRED SKIN IAW SRM.SDR SWAA2013111122087Skin · crackedSKIN CRACKED AT BS 460+17, STRINGER 16L. REPAIRED SKIN IAW EA.SDR SWAA2013111122086Flap · crackedRT WING KRUGER FLAP CRACKED LE STATION 208.00. REPAIRED FLAP IAW SRM.SDR SWAA2013110722023Skin · crackedFUSELAGE SKIN CRACKED AT BS 787+12.5, STRINGER 17L. REPAIRED SKIN IAW SRM.SDR SWAA2013110722022Skin · crackedFUSELAGE SKIN CRACKED AT BS 827+1, STRINGER 17L. REPAIRED SKIN IAW SRM.SDR SWAA2013110421818Angle · crackedEXHAUST TAIL CONE ANGLE CRACKED. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2013112622788Frame · crackedFUSELAGE FRAME CRACKED AT BS 348, STRINGER 16L. REPAIRED FRAME IAW SWA EA.SDR SWAA2013111422385Seat Track · corrodedSEAT TRACK CORRODED BETWEEN BS 727B TO BS 947, LBL 45. R & R SEAT TRACK IAW SRM & DRAWING.SDR SWAA2013111122083Intercostal · crackedFRAME SHEAR WEB CRACKED AT BS 348, STRINGER 16L. R & R INTERCOSTAL IAW SRM.SDR SWAA2013110421830Seat Track · corrodedSEAT TRACK CORRODED BETWEEN BS 727B TO BS 947, LBL 25. R & R SEAT TRACK IAW SRM.SDR SWAA2013110421815Seat Track · corrodedSEAT TRACK CORRODED BETWEEN BS 727B TO BS 947, RBL 45. R & R SEAT TRACK IAW SRM & DRAWING.SDR SWAA2013103121718Structure · corrodedCHORD CORRODED AT BS 270, BETWEEN LBL 10 TO RBL10. R & R CHORD IAW SRM & DRAWING.SDR SWAA2013102821574Stringer Clip · crackedSTRINGER CLIP CRACKED AT STATION 360, STRINGER 15L. R & R CLIP IAW SRM.SDR SWAA2013102321417Intercostal · corrodedNLG INSPECTION WINDOW INTERCOSTAL CORRODED. R & R INTERCOSTAL IAW SRM & DRAWING.SDR SWAA2013112622787Skin · crackedFUSELAGE SKIN CRACKED AT L1 DOOR AFT LOWER CUTOUT. REPAIRED SKIN IAW SWA EA.SDR SWAA2013111322301Frame · crackedFRAME CRACKED AT BS 482, STRINGER 14L. REPAIRED FRAME IAW EA.SDR SWAA2013102221346Strap · crackedL1 DOOR UPPER HINGE H STRAP CRACKED AFT LOWER END IN RADIUS. R & R STRAP IAW SRM & DRAWING.SDR SWAA2013111122082Pressure Deck · crackedMAIN WW PRESSURE DECK CRACKED BETWEEN BS 672.5 TO BS 673, RBL41. REPAIRED DECK IAW SRM.SDR SWAA2013110421833Skin · crackedSKIN CRACKED BETWEEN BS 933 TO 934.4, STRINGER 22R. REPAIRED SKIN IAW SRM.SDR SWAA2013100820969Light · looseLT EEPLS LOOSE BETWEEN ROWS 8 TO ROW 9. SECURED EEPLS IAW AMM.SDR SWAA2013112622786Skin · crackedFUSELAGE SKIN CRACKED TA BS 392.5 TO BS 396, STRINGER 1. REPAIRED SKIN IAW SWA EA.SDR SWAA2013112222726Lens · crackedAFT LAVATORY EMERGENCY EXIT LIGHT LENS COVER BROKEN. R & R LENS IAW MM.SDR SWAA2013110421832Skin · crackedSKIN CRACKED BETWEEN BS 783.4 TO BS 784.5, STRINGER 21L. REPAIRED SKIN IAW EA.SDR SWAA2013110421831Skin · crackedSKIN CRACKED BETWEEN BS 892 TO BS 894.5, STRINGER 24R. REPAIRED SKIN IAW SRM.SDR SWAA2013103121717Skin · crackedLT WING NR 3 SLAT ACTUATOR CUTOUT INNER SKIN CRACKED. REPAIRED SKIN IAW SRM.SDR SWAA2013102821577Skin · crackedSKIN CRACKED AT BS 908, STRINGER 4L. REPAIRED SKIN IAW EA.SDR SWAA2013101721252Skin · crackedSKIN CRACKED BETWEEN BS 942.3 TO BS 944, STRINGER 22L. REPAIRED SKIN IAW SRM.SDR SWAA2013101421126Skin · crackedCHEM MILL SKIN CRACKED AT BS 891, STRINGER 25R. REPAIRED SKIN IAW EA & ER.SDR SWAA2013100820972Light · inoperativeRT EEPLS INOPERATIVE AT ROW 5. R & R BULB IAW AMM.SDR SWAA2013102821589Skin · crackedSKIN CRACKED AT BS 847, STRINGER 19L. REPAIRED SKIN IAW EO & EA.SDR SWAA2013101821281Frame · crackedFUSELAGE FRAME CRACKED AT BS 520, STRINGER 20L. REPAIRED FRAME IAW SRM.SDR SWAA2013101421125Skin · crackedCHEM MILL SKIN CRACKED AT BS 930, STRINGER 22R. REPAIRED SKIN IAW EA & ER.SDR SWAA2013101421124Skin · crackedSUB SURFACE CHEM-MILL SKIN CRACKED AT BS 443, STRINGER 2R. REPAIRED SKIN IAW EA & ER.SDR SWAA2013101421123Skin · crackedVERTICAL SUB SURFACE CHEM-MILL SKIN CRACKED BS 360, STRINGER 2L. REPAIRED SKIN IAW ER & EA.SDR SWAA2013101421122Skin · crackedSKIN CRACKED AT BS 360, STRINGER 2L. REPAIRED SKIN IAW EA & ER.SDR SWAA2013101121084Skin · crackedSKIN CRACKED AT BS 895, STRINGER 18L. REPAIRED SKIN IAW SRM & EA.SDR SWAA2013100820970Skin · crackedSKIN CRACKED AT BS 824.5, STRINGER 25L. REPAIRED SKIN IAW SRM & EA.SDR SWAA2013112222725Slide · crackedL1 DOOR ESCAPE SLIDE GIRT HAS CRACKED PLASTIC SLEEVE AT AFT END. R & R SLIDE ASSEMBLY IAW MT.SDR SWAA2013112222724Skin · crackedFUSELAGE SKIN CRACKED AT BS 482B+6, STRINGER 16R. REPAIRED SKIN IAW SWA EA.SDR SWAA2013112122655Skin · crackedSKIN CRACKED AT BS 482B+14, STRINGER 16L. REPAIRED SKIN IAW EA.SDR SWAA2013112022613Cover · looseR1 DOOR EMERGENCY EVAC SLIDE COVER LOOSE. SECURED COVER IAW SRM.SDR SWAA2013112022612Frame · crackedFRAME FWD FLANGE CRACKED AT BS 727, STRINGER 18A LT. REPAIRED FLANGE IAW EA.SDR SWAA2013112022611Frame · crackedFRAME FWD FLANGE CRACKED AT BS 727, STRINGER 18A RT. REPAIRED FLANGE IAW SWA EA.SDR SWAA2013103121730Skin · crackedFUSELAGE SKIN CRACKED AT BS 425, STRINGER 17R. REPAIRED SKIN IAW ER & SWA EA.SDR SWAA2013101121083Angle · crackedLT WING INBD NO STEP PANEL ANGLE CRACKED AT AFT END. R & R ANGLE IAW SRM.SDR SWAA2013100820991Support · crackedLT WING LOWER TE PANEL SEAL SUPPORT CRACKED JUST OTBD OF THE NR 1 PYLON. REPAIRED SUPPORT IAW SRM & EA.SDR SWAA2013100320769Sensor · faultyNR 2 ENGINE WILL NOT GO TO IDLE IN DESCENT WITH THRUST LEVERS AT IDLE. R & R CIT SENSOR IAW AMM.
Back to Boeing 737-5H4