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 SWAA2014021725201Support Angle · crackedFWD SUPPORT ANGLE CRACKED AT BS 328, LBL 45.6. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2014021725200Web · crackedWEB CRACKED BETWEEN BS 312 TO BS 328, RBL 31. R & R WEB IAW SRM & DRAWING.SDR SWAA2014021325119Sign · looseRT OVERWING EMERGENCY EXIT SIGN LOOSE. SECURED SIGN IAW SIP.SDR SWAA2014021325112Slide · out of positionR1 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW AMM & MT.SDR SWAA2014031225987Skin · crackedRT BS 400+10 UPPER FWD WINDOW CORNER SKIN CUTOUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014031125960Frame · crackedFRAME INNER CHORD CRACKED AT BS 616, FWD SIDE AT 1ST FASTENER ABOVE LT CREASE BEAM WEB. REPAIRED CHORD IAW ER & EA.SDR SWAA2014031025886Skin · crackedRT BS 500A+10 LOWER AFT WINDOW CORNER SKIN CUTOUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014030725853Skin · crackedRT BS 500C+10 LOWER AFT WINDOW CORNER SKIN CUTOUT CRACKED. REPAIR CUTOUT IAW EA.SDR SWAA2014030725848Frame · crackedFRAME INNER CHORD CRACKED AT BS 616, 3RD FASTENER BELOW LT CREASE BEAM WEB. REPAIRED CHORD IAW ER & EA.SDR SWAA2014030725846Skin · crackedRT BS 360+10 LOWER AFT WINDOW CORNER SKIN CUTOUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014030525781Web · crackedLT SIDE OF NLG WW WEB CRACKED AT BS. 246.2, WL 169.1. REPAIRED WEB IAW EA.SDR SWAA2014030525780Web · crackedLT SIDE OF NLG WW WEB CRACKED AT BS 239, WL 169.1. REPAIRED WEB IAW EO & EA.SDR SWAA2014030525763Skin · crackedRT BS 380+10 UPPER FWD WINDOW CORNER SKIN CUTOUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014030425744Skin · crackedLT BS 887+10 UPPER AFT WINDOW CORNER SKIN CUTOUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014030425743Skin · crackedRT BS 520+10 LOWER AFT WINDOW CORNER SKIN CUTOUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014030425742Skin · crackedRT BS 520+10 UPPER FWD WINDOW CORNER SKIN CUTOUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014030325713Skin · crackedRT BS 440+10 UPPER FWD WINDOW CORNER SKIN CUTOUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014030325704Plate · corrodedAFT GALLEY FLOOR PANEL 2472X GIRT BAR BRACKET CORRODED. R & R PLATE IAW SRM & DRAWING.SDR SWAA2014022725630Frame · crackedFRAME WEB CRACKED AT BS 616, STRINGER 16L. REPAIRED WEB IAW SRM.SDR SWAA2014022725629Skin · crackedLT BS 480+10 UPPER FWD WINDOW CORNER SKIN CUTOUT CRACKED. REPAIRED SKIN IAW SB.SDR SWAA2014022725628Skin · crackedLT BS 460+10 UPPER FWD WINDOW CORNER SKIN CUTOUT CRACKED. REPAIRED SKIN IAW SB.SDR SWAA2014022725627Skin · crackedLT BS 460+10 LOWER AFT WINDOW CORNER SKIN CUTOUT CRACKED. REPAIRED SKIN IAW SB.SDR SWAA2014022725626Skin · crackedLT BS 440+10 LOWER AFT WINDOW CORNER SKIN CUTOUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014022725625Skin · crackedLT BS 400+10 LOWER AFT WINDOW CORNER SKIN CUTOUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014022725624Skin · crackedLT BS 380+10 LOWER AFT WINDOW CORNER SKIN CUTOUT CRACKED. REPAIRED SKIN IAW EA.SDR SWAA2014022825673Skin · crackedFUSELAGE SKIN CRACKED AT LT STATION 877, LOWER FWD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SWA EA.SDR SWAA2014022825672Skin · crackedFUSELAGE SKIN CRACKED AT RT STATION 530, UPPER FWD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SWA EA.SDR SWAA2014022825671Skin · crackedFUSELAGE SKIN CRACKED AT LT STATION 410, UPPER FWD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SWA EA.SDR SWAA2014022825670Skin · crackedFUSELAGE SKIN CRACKED AT RT STATION 470, UPPER FWD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SWA EA.SDR SWAA2014022825669Skin · crackedFUSELAGE SKIN CRACKED AT RT STATION 430, UPPER FWD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SWA EA.SDR SWAA2014022825667Frame · crackedFUSELAGE FRAME CRACKED AT STATION 616, STRINGER 16L. REPAIRED FRAME IAW SRM.SDR SWAA2014022825657Skin · crackedNR 1 LE SLAT SKIN CRACKED BETWEEN OTBD MAIN TRACK & MID AUXILIARY TRACK. REPAIRED SKIN IAW SRM.SDR SWAA2014022825656Skin · crackedNR 1 LE SLAT SKIN CRACKED AT INBD END OF BULLNOSE. REPAIRED SKIN IAW SRM.SDR SWAA2014022625578Skin · crackedLT BS 847+10 LOWER FWD WINDOW CORNER CUTOUT CRACKED. REPAIRED CUTOUT IAW SB.SDR SWAA2014022625577Skin · crackedLT BS 807+10 LOWER FWD WINDOW CORNER CUTOUT CRACKED. REPAIRED CUTOUT IAW SB.SDR SWAA2014022625576Skin · crackedLT BS 787+10 LOWER FWD WINDOW CORNER CUTOUT CRACKED. REPAIRED CUTOUT IAW SB.SDR SWAA2014022625575Skin · crackedLT BS 767+10 LOWER FWD WINDOW CORNER CUTOUT CRACKED. REPAIRED CUTOUT IAW SB.SDR SWAA2014022625574Skin · crackedLT BS 867+10 UPPER AFT WINDOW CORNER CUTOUT CRACKED. REPAIRED CUTOUT IAW SB.SDR SWAA2014022625573Skin · crackedLT BS 500C +10 UPPER FWD WINDOW CORNER CUTOUT CRACKED. REPAIRED CUTOUT IAW SB.SDR SWAA2014022625572Skin · crackedLT BS 500B+10 UPPER FWD WINDOW CORNER CUTOUT CRACKED. REPAIRED CUTOUT IAW SB.SDR SWAA2014022625571Skin · crackedRT BS 500 +10 UPPER FWD WINDOW CORNER CUTOUT CRACKED. REPAIRED CUTOUT IAW SB.SDR SWAA2014022625569Skin · crackedLT BS 440 +10 UPPER FWD WINDOW CORNER CUTOUT CRACKED. REPAIRED CUTOUT IAW EA.SDR SWAA2014022625568Skin · crackedLT BS 500A+10 LOWER AFT WINDOW CORNER CUTOUT CRACKED. REPAIRED CUTOUT IAW SB.SDR SWAA2014022625567Skin · crackedRT BS 500B+10 LOWER AFT WINDOW CORNER CUTOUT CRACKED. REPAIRED CUTOUT IAW SB.SDR SWAA2014022625566Skin · crackedRT BS 500+10 LOWER AFT WINDOW CORNER CUTOUT CRACKED. REPAIRED CUTOUT IAW SB.SDR SWAA2014022625565Skin · crackedRT BS 440+10 LOWER AFT WINDOW CORNER CUTOUT CRACKED. REPAIRED CUTOUT IAW SB.SDR SWAA2014022625564Skin · crackedRT BS 380+10 LOWER AFT WINDOW CORNER CUTOUT CRACKED. REPAIRED CUTOUT IAW EA.SDR SWAA2014022425506Skin · crackedLT BS 887+10 UPPER AFT WINDOW CORNER CUTOUT CRACKED. REPAIRED CUTOUT IAW EA.SDR SWAA2014022425505Beam · crackedAFT CARGO DOOR CROSS BEAM T CHORD AFT END SURFACE CRACKED FROM 1ST & 3RD OTBD FASTENERS. R & R DOOR IAW MM.SDR SWAA2014021925305Buttstrap · crackedBUTT STRAP CRACKED AT BS 360, STRINGER 4R. R & R BUTT STRAP IAW SRM & DRAWING.
Back to Boeing 737-3H4