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 SWAA2012082707017Web · corrodedWEB CORRODED BETWEEN BS 927 TO BS 947.5, STR 21L. REMOVED AND REPLACED WEB IAW SRM AND DWG.SDR SWAA2012082707016Strap · crackedSTRAP CRACKED BETWEEN BS 312 TO BS 344, BL 0. REMOVED AND REPLACED STRAP IAW SRM AND DWG.SDR SWAA2012082707015Strap · crackedSTRAP CRACKED BETWEEN BS 312 TO BS 344, LBL 10.5. REMOVED AND REPLACED STRAP IAW SRM AND DWG.SDR SWAA2012082106866Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 887+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012082106865Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 807+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012082106864Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 887+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW TC.SDR SWAA2012082106863Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 867+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012082106862Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 727+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN PER EA.SDR SWAA2012082006826Tie Clip · crackedTIE CLIP CRACKED AT BS 727D, STR 20L. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2012081706782Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 767+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012081706781Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 807+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012081706780Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 787+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012081706779Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 767+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012081606743Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 727B+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012081606742Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 727E+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012081606741Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 727B+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012081606733Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 727A+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW TC AND EA.SDR SWAA2012081306620Battery · dischargedFORWARD INBD EMERGENCY FLASHLIGHT INOP. REMOVED AND REPLACED BATTERY PER AMM.SDR SWAA2012100308246Skin · crackedBASE OF ANTENNA CRACKED BETWEEN BS 727D TO BS 727E STR 27L TO STR 27R IN AFT CARGO COMPARTMENT. REMOVED AND REPLACED SKIN IAW EA.SDR SWAA2012100108162Skin · crackedSKIN CRACKED BETWEEN BS 727D TO BS 727E, BETWEEN STR 27R TO STR 27L. REPAIRED SKIN IAW EA AND EO.SDR SWAA2012100108161Frame · corrodedFRAME CORRODED AT BS 847 BETWEEN, STR 27L AND STR 27R. REPAIRED FRAME IAW EO AND EA.SDR SWAA2012100108160Stiffener · crackedTEE STIFFENER CRACKED AT BS 727, STR 27L. REMOVED AND REPLACED STIFFENER IAW SRM AND DWG.SDR SWAA2012092607998Frame · crackedFRAME CRACKED AT BS 500C, BETWEEN STR 20R AND STR 21R. REPAIRED FRAME IAW EO AND EA.SDR SWAA2012092407908Door Frame · crackedFRAME CRACKED AT BS 845, AROUND STOP FITTING 5 OF THE AFT CARGO DOOR. REMOVED AND REPLACED AFT CARGO DOOR IAW AMM.SDR SWAA2012092407888Frame · crackedFRAME CRACKED AT BS 500B, BETWEEN STR 20L AND STR 21L. REPAIRED FRAME IAW EA.SDR SWAA2012092107837Frame · corrodedFRAME CORRODED AT BS 907, BETWEEN STR 27R TO STR 27L. REPAIRED FRAME IAW SRM.SDR SWAA2012091907760Frame · crackedFRAME CRACKED AT BS 520, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME IAW SRM.SDR SWAA2012091807713Floorbeam · crackedLONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 727B, RBL 24.8. REPAIRED BEAM IAW EA AND EO.SDR SWAA2012091207536Frame · corrodedFRAME CORRODED AT BS 927, BETWEEN STR 27R TO STR 27L. REPAIRED FRAME IAW SRM.SDR SWAA2012090407330Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 500+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012090407329Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 420+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012090407328Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 400+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012090407327Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 420+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW BS.SDR SWAA2012090407326Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 380+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012090407325Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 400+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012090407324Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 400+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012090407323Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 360+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW REO AND EA.SDR SWAA2012090407322Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 727+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA AND REO.SDR SWAA2012090407321Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 867+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA AND REO.SDR SWAA2012090407320Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 847+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012090407319Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 727+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012090407259Frame · corrodedFRAME CORRODED AT BS 747, BETWEEN STR 26R TO STR 27R. REPAIRED FRAME IAW SRM.SDR SWAA2012090407258Frame · corrodedFRAME CORRODED AT BS 767, BETWEEN STR 27R TO STR 27L. REPAIRED FRAME IAW SRM.SDR SWAA2012083007228Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 500C+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012083007184Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 520+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012083007183Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 500A+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB .SDR SWAA2012083007182Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 360+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012083007180Stringer · puncturedSTRINGER PUNCTURED AT BS 500D+16, STR 8L. REPAIRED STRINGER IAW REO & EA.SDR SWAA2012083007179Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 360+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012083007171Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 520+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.
Back to Boeing 737-3H4