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 SWAA2012072606199Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 420+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012072606198Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 400+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012072606197Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 500C+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012072606196Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 380+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012072606188Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 500B+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012072406142Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 500A+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012072406141Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 500+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012072406140Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 400+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012072406139Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 500A+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012072306087Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 400+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012072006038Web · crackedWEB CRACKED BETWEEN BS 867 TO BS 887, STR 25R. REMOVED AND REPLACED WEB IAW SRM AND DWG.SDR SWAA2012071805933Flap · delaminatedLEFT WING O/B AFT FLAP DELAMINATED. REPAIRED AFT FLAP IAW SRM.SDR SWAA2012071705925Stringer Clip · crackedSTRINGER CLIP CRACKED AT BS 400, STR 9L. REMOVED AND REPLACED CLIP IAW SRM AND DWG.SDR SWAA2012071205727Fitting · looseR1 DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR FITTING AT GALLEY FLOOR LOOSE. SECURED FITTING PER MM.SDR SWAA2012080306421Slat · delaminatedLEFT WING LEADING EDGE NR 1 SLAT DELAMINATED. REMOVED AND REPLACED IAW AMM.SDR SWAA2012080106405Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 887+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012080106404Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 847+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012080106403Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 767+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012080106384Skin · delaminatedLEFT WING NR 2 SLAT SKIN AT INBOARD SIDE DELAMINATED. REMOVED AND REPLACED SKIN IAW AMM.SDR SWAA2012072606187Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 847+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012072606184Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 767+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012072606182Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 827+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012072606181Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 807+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012072606180Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 787+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012072606157Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 807+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012072606156Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 787+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012072406138Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 827+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012072406137Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 827+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012072406136Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 807+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012072406135Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 787+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012072406134Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 767+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW BOEING SB.SDR SWAA2012072306086Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 827+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW TC.SDR SWAA2012072306085Skin · crackedRIGHT FUSELAGE SKIN CRACKED AT BS 867+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA 1-A53-14380 REV 3.SDR SWAA2012072306084Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 867+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW BOEING SB.SDR SWAA2012072306078Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 847+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW BOEING SB.SDR SWAA2012072306077Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 807+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW BOEING SB.SDR SWAA2012072306076Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 787+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012072306075Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 847+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW BOEING SB.SDR SWAA2012072006014Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 867+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012071305780Skin · crackedFUSELAGE SKIN CRACKED AT BS 500D+2, STR 8R. REPAIRED SKIN CRACK PER EA.SDR SWAA2012071005690Battery Pack · dischargedAFT CABIN EEPLS INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA2012071005684Lens · missingLEFT EMERGENCY EXIT BULLNOSE LIGHT LENS MISSING AT ROW 17. INSTALLED LENS PER MM.SDR SWAA2012071905973Support Angle · crackedSUPPORT ANGLE CRACKED BETWEEN BS 887 TO BS 907, BETWEEN STR 20R TO STR 21R. REMOVED AND REPLACED ANGLE PER SRM AND DWG.SDR SWAA2012071805950Flap · delaminatedLEFT WING O/B AFT FLAP DELAMINATED. REPAIRED AFT FLAP IAW SRM.SDR SWAA2012071805949Floorbeam · crackedFLOORBEAM CRACKED AT BS 328, RBL 59.9. REPAIRED BEAM IAW SRM.SDR SWAA2012071805935Tie Clip · crackedTIE CLIP CRACKED AT BS 380, STR 22L. REMOVED AND REPLACED TIE CLIP IAW SRM AND DWG.SDR SWAA2012071805934Web · crackedWEB CRACKED BETWEEN BS 312 AND BS 323.7, BETWEEN STR 28L TO STR 28R. REMOVED AND REPLACED WEB IAW SRM AND DWG.SDR SWAA2012071805932Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 294.5, STR 23L. REMOVED AND REPLACED ANGLE IAW SRM AND DWG.SDR SWAA2012071605838Stringer Clip · corrodedSTRINGER CLIP CORRODED AT BS 907, STR 27R. REMOVED AND REPLACED CLIP IAW DWG & SRM.SDR SWAA2012071605831Angle · crackedANGLE CRACKED AT BS 330.62+6, BETWEEN STR 20L AND STR 21L. REMOVED AND REPLACED ANGLE IAW SRM & DWG.
Back to Boeing 737-3H4