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 SWAA2012092107846Frame · corrodedFRAME CORRODED AT BS 767, BETWEEN STR 23L TO STR 23R. REMOVED & REPLACED FRAME IAW SRM & DWG.SDR SWAA2012092107830Skin · crackedSKIN CRACKED AT BS 1156+5, RBL 3. REPAIRED SKIN IAW SRM.SDR SWAA2012091707665Frame · corrodedFRAME CORRODED AT BS 747, BETWEEN STR 23L TO 23R. REMOVED AND REPLACED FRAME PER ER AND EA.SDR SWAA2012091707642Angle · crackedLEFT HORIZONTAL STABILIZER CENTER SECTION ANGLE CRACKED AT BS 1121, LBL 10. REMOVED AND REPLACED ANGLE IAW SRM AND DWG.SDR SWAA2012091707641Frame · corrodedFRAME CORRODED AT BS 747, BETWEEN STR 26R TO STR 27R. REPAIRED FRAME IAW SRM.SDR SWAA2012091407607Web · corrodedWEB CORRODED BETWEEN BS 420 TO BS 440, STR 17R. REMOVED AND REPLACED WEB IAW SRM AND DWG.SDR SWAA2012091407606Frame · corrodedFRAME CORRODED AT BS 747, BETWEEN STR 25R TO STR 26R. REPAIRED FRAME IAW SRM.SDR SWAA2012091207533Angle · crackedWEB ANGLE CRACKED AT BS 767+5, STR 25R. REMOVED AND REPLACED ANGLE IAW SRM AND DWG.SDR SWAA2012091107507Tie Clip · crackedTIE CLIP CRACKED AT BS 500D, STR 23R. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2012091107506Support Angle · crackedLEFT SUPPORT ANGLE CRACKED AT BS 727A. REMOVED AND REPLACED ANGLE IAW SRM.SDR SWAA2012091007499Tie Clip · crackedTIE CLIP CRACKED AT BS 500C, STR 20R. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2012090507373Tie Clip · crackedTIE CLIP CRACKED AT BS 767, STR 25R. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2012090407333Skin · crackedFUSELAGE SKIN CRACKED AT BS 827+9, STR 4L. REPAIRED SKIN PER EA.SDR SWAA2012083107209Cover · detachedRIGHT OVERHEAD EMERGENCY EXIT BULLNOSE LIGHT COVER FELL OFF AT ROW 8. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA2012083007185Sign · brokenR2 DOOR EMERGENCY EXIT SIGN BROKEN. REMOVED AND REPLACED SIGN ASSY PER M/M.SDR SWAA2012092607996Keelbeam · corrodedKEEL BEAM CORRODED BETWEEN BS 500D AND BS 520, STR 28R. REPAIRED BEAM IAW EA.SDR SWAA2012092607995Tie Clip · crackedTIE CLIP CRACKED AT BS 947.5, STR 25R. REMOVED AND REPLACED TIE CLIP IAW SRM AND EA.SDR SWAA2012092107843Skin · chafedLEFT WING NR 2 SLAT LOWER SURFACE TRAILING EDGE CHAFED AT O/B END. REMOVED AND REPLACED NR 2 SLAT PER M/M.SDR SWAA2012092107829Support Angle · corrodedSUPPORT ANGLE CORRODED AT FWD ENTRY DOOR AT LEVEL STR 17L. REMOVED AND REPLACED ANGLE IAW SRM AND DWG.SDR SWAA2012092107828Angle · crackedANGLE CRACKED AT BS 540, BETWEEN STR 21R TO STR 22R. REPAIRED ANGLE IAW SRM.SDR SWAA2012092007789Angle · crackedAFT CARGO COMPARTMENT ANGLE CRACKED AT BS 947.5, BETWEEN STR 25R TO STR 24R. REMOVED AND REPLACED ANGLE IAW SRM & DWG.SDR SWAA2012091807714Support Channel · corrodedAFT CARGO BAY SUPPORT CHANNEL CORRODED BETWEEN BS 727D TO 727E, BL 0. REMOVED AND REPLACED CHANNEL PER DWG & SRM.SDR SWAA2012091707664Skin · crackedLEFT WING NR 1 SLAT SKIN CRACKED. REPAIRED SKIN IAW SRM.SDR SWAA2012091707640Channel · corrodedCHANNEL CORRODED AT BS 859.7, LBL 8.10. REPAIRED CHANNEL IAW EA.SDR SWAA2012091707639Channel · corrodedCHANNEL CORRODED AT BS 859.7, LBL 3. REPAIRED CHANNEL IAW EA.SDR SWAA2012091707638Channel · corrodedCHANNEL CORRODED BETWEEN BS 727D TO BS 727E, LBL 8.10. REPAIRED CHANNEL IAW EA.SDR SWAA2012091707637Channel · corrodedCHANNEL CORRODED AT BS 727D+5, RBL 8.10. REPAIRED CHANNEL IAW EA.SDR SWAA2012091707636Channel · corrodedCHANNEL CORRODED AT BS 727D+5, RBL 3. REPAIRED CHANNEL IAW EA.SDR SWAA2012091707635Channel · corrodedCHANNEL CORRODED AT BS 727D+5, LBL 3. REPAIRED CHANNEL IAW EA.SDR SWAA2012091707634Stiffener · crackedPRESSURE BULKHEAD STIFFENER CRACKED AT BS 727, STR 27R. REMOVED AND REPLACED STIFFENER IAW SRM AND DWG.SDR SWAA2012091407610Skin · crackedLEFT WING NR 3 SLAT LOWER SURFACE SKIN CRACKED. REPAIRED SKIN PER SRM.SDR SWAA2012091407605Angle · crackedANGLE CRACKED AT BS 500B, STR 26L. REMOVED AND REPLACED ANGLE IAW SRM AND DWG.SDR SWAA2012091407604Angle · crackedANGLE CRACKED AT BS 400, STR 26R. REMOVED AND REPLACED ANGLE IAW SRM AND DWG.SDR SWAA2012091407603Web · crackedWEB CRACKED BETWEEN BS 400 TO BS 420, STR 26R. REMOVED AND REPLACED WEB IAW SRM AND DWG.SDR SWAA2012091407602Stiffener · crackedSTIFFENER CRACKED AT BS 727, STR 27L. REMOVED AND REPLACED STIFFENER IAW SRM AND DWG.SDR SWAA2012091207537Shear Tie · corrodedFRAME CORRODED AT BS 947, BETWEEN STR 26L TO STR 27L. REMOVED AND REPLACED SHEAR TIE IAW SRM & DWG.SDR SWAA2012091007498Tie Clip · crackedTIE CLIP CRACKED AT BS 500C, STR 27L. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2012091007497Tie Clip · crackedTIE CLIP CRACKED AT BS 480, STR 26L. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2012091007496Tie Clip · crackedTIE CLIP CRACKED AT BS 297, STR 28R. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2012091007495Tie Clip · crackedTIE CLIP CRACKED AT BS 727B, STR 25L. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2012091007452Skin · crackedAFT CARGO DOOR BEAR STRAP FWD LOWER CORNER OF CUTOUT CRACKED BETWEEN BS 787 TO BS 814 AND BETWEEN STR 22R TO STR 26R. REPAIRED SKIN PER SRM.SDR SWAA2012091007450Channel · corrodedAFT CARGO BAY FLOOR CHANNEL CORRODED AT BS 727D+6, RBL 3. REPAIRED CHANNEL IAW EA.SDR SWAA2012091007446Channel · corrodedAFT CARGO BAY FLOOR CHANNEL CORRODED AT BS 772, LBL 8. REPAIRED CHANNEL IAW EA.SDR SWAA2012090707418Tie Clip · corrodedTIE CLIP CORRODED AT BS 794, STR 26R. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2012090707414Tie Clip · crackedTIE CLIP CRACKED AT BS 947.5, STR 26L. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2012090407290Web · crackedWEB CRACKED AT BS 326.5, RBL 31. REMOVED AND REPLACED WEB IAW SRM AND DWG.SDR SWAA2012090407273Valve · faultyHYDRAULIC FLUID ODOR OBSERVED IN CABIN AND IN FLIGHT DECK. REMOVED AND REPLACED A&B SYSTEM RESERVOIR VENT VALVES IAW MM.SDR SWAA2012100108164Skin · crackedSKIN CRACKED AT BS 360+2, BETWEEN STR 5R TO STR 6R. REPAIRED SKIN IAW EA.SDR SWAA2012091107517Floorbeam · crackedLONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 665, LBL 24.5 CENTER WING BOX. REPAIRED CHORD PER EA AND EO.SDR SWAA2012083107210Skin · crackedSKIN CRACKED AT BS 440 + 4, STR 1. REPAIRED SKIN PER EA.
Back to Boeing 737-3H4