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 SWAA2013111422386Battery Pack · dischargedL1 DOOR EMERGENCY EXIT LIGHT BATTERY PACK INOPERATIVE. R & R BATTERY PACK IAW MM.SDR SWAA2013111422363Skin · crackedRT ELEVATOR TRIM TAB CRACKED ON UPPER SURFACE AT NR 3 HINGE. R & R TAB IAW MM.SDR SWAA2013111422359Battery Pack · dischargedL1 DOOR EXTERIOR EMERGENCY EXIT LIGHT BATTERY PACK INOPERATIVE. R & R BATTERY PACK IAW MM.SDR SWAA2013112122634Fairing · delaminatedRT AILERON TAB FAIRING DELAMINATED. REPAIRED FAIRING IAW SRM.SDR SWAA2013111822432Stiffener · crackedLT WING NR 3 FLAP TRACK STIFFENER CRACKED. R & R STIFFENER IAW SRM & DRAWING.SDR SWAA2013111322317Acm · malfunctionedFUMES REPORTED IN CABIN. R & R ACM IAW MM.SDR SWAA2013111322313Fuse · blownLT EMERGENCY EXIT LIGHTS BATTERY PACK INOPERATIVE. R & R FUSE IAW WDM & MM.SDR SWAA2013120322930Frame · crackedFRAME CRACKED AT BS 947.5, RBL 17.04. REPAIRED FRAME IAW EO & EA.SDR SWAA2013111822416Frame · crackedFRAME CRACKED AT BS 520, BETWEEN STRINGER 20R & 21R. REPAIRED FRAME IAW SRM.SDR SWAA2013111822415Frame · crackedFRAME CRACKED AT BS 500B, BETWEEN STRINGER 20L & 21L. REPAIRED FRAME IAW SRM.SDR SWAA2013111822414Skin · crackedSKIN CRACKED BETWEEN 345.5 TO 348.5, STRINGER 2L. REPAIRED SKIN IAW SRM.SDR SWAA2013111822413Pressure Panel · crackedPRESSURE DECK SKIN IN RT MAIN WW CRACKED AT STATION 664, RBL 41. REPAIRED SKIN IAW SRM.SDR SWAA2013111322327Light · inoperativeAFT OVERHEAD DOOR EMERGENCY EXIT SIGNS INOPERATIVE. RELAMPED SIGN IAW AMM.SDR SWAA2013111322330Skin · crackedSKIN CRACKED AT BS 526.5, STRINGER 10R. REPAIRED SKIN IAW EA.SDR SWAA2013111822431Strap · crackedSTRAP CRACKED BETWEEN BS 328 TO BS 344, LBL 45. R & R STRAP IAW SRM & DRAWING.SDR SWAA2013111222258Sign · looseLT OVERWING EMERGENCY EXIT SIGN LOOSE. SECURED SIGN IAW SIP.SDR SWAA2013111322331Skin · crackedFUSELAGE SKIN CRACKED AT BS 500B+13, STRINGER 10L. REPAIRED SKIN IAW EA.SDR SWAA2013111222249Flap Track · looseRT WING NR 7 FLAP TRACK LOOSE AT AFT ATTACH POINT. R & R NR 7 FLAP TRACK IAW MM.SDR SWAA2013111322318Access Panel · crackedVERTICAL STABILIZER ACCESS PANEL 9501L CRACKED. R & R PANEL IAW SRM & DRAWING.SDR SWAA2013111122104Lens · looseLT EMERGENCY EXIT LIGHT LENS LOOSE AT ROW 2. SECURED LENS IAW AMM.SDR SWAA2013112222713Angle · crackedANGLE CRACKED AT BS 927 TO BS 947.5 BL 0, AFT CARGO COMPARTMENT. R & R ANGLE IAW SRM.SDR SWAA2013112222712Frame · corrodedFUSELAGE FRAME CORRODED AT BS 360, STRINGER 28L & STRINGER 28R. REPAIRED FRAME IAW SRM.SDR SWAA2013112222711Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 294.5, STRINGER 23L. R & R ANGLE IAW SRM.SDR SWAA2013111822428Fuse Pin · corrodedLT PYLON INBD MID SPAR FUSE PIN CORRODED. R & R PIN IAW AMM.SDR SWAA2013111822427Web · crackedWEB CRACKED BETWEEN BS 344 TO BS 360, BL 0. R & R WEB IAW SRM & DRAWING.SDR SWAA2013111422373Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 328, LBL 45. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2013111422372Web · crackedWEB CRACKED BETWEEN BS 328 TO BS 344, LBL 45. R & R WEB IAW SRM & DRAWING.SDR SWAA2013111422371Web · crackedWEB CRACKED BETWEEN BS 312 TO BS 328, RBL. R & R WEB IAW SRM & DRAWING.SDR SWAA2013111222273Skin · delaminatedLT WING LE SLAT SKIN DELAMINATED. R & R SLAT IAW AMM.SDR SWAA2013111222250Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 328, RBL 31. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2013111222224Skin · delaminatedLT WING NR 4 SLAT LE SKIN DELAMINATED. R & R SLAT IAW MM.SDR SWAA2013111122124Angle · crackedANGLE CRACKED AT BS 312+9, STRINGER 21L. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2013111122119Angle · crackedRT WING TE ANGLE JUST FWD OF NR 2 AILERON HINGE CRACKED. R & R ANGLE IAW SRM.SDR SWAA2013111122106Lens · brokenFWD ENTRY EMERGENCY EXIT LENS OTBD OF FLIGHT ATTENDANT JUMP SEAT BROKEN. R & R LENS IAW AMM.SDR SWAA2013111122060Panel · delaminatedKEEL BEAM CLOSURE PANEL DELAMINATED JUST AFT OF A/C BAY DOORS. R & R PANEL IAW SRM.SDR SWAA2013120322954Skin · crackedRT BS 727A+10 LOWER FWD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 7. REPAIRED SKIN IAW EA.SDR SWAA2013112722802Skin · crackedFUSELAGE SKIN CRACKED AT BS 847+10, UPPER AFT WINDOW CUTOUT. REPAIRED SKIN IAW SWA EA.SDR SWAA2013112622759Rib · crackedRT WING RIB WEB CRACKED AT WBL 198.6, STRINGER 5. REPAIRED WEB IAW SWA EA.SDR SWAA2013111922585Skin · crackedRT BS 787+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 2 & 3. REPAIRED SKIN IAW SB.SDR SWAA2013111922581Skin · crackedLT BS 887+10 LOWER FWD WINDOW SKIN CUTOUT CRACKED AT HOLES 2 & 3. REPAIRED SKIN IAW SB.SDR SWAA2013111922580Skin · crackedLT BS 827+10 LOWER FWD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW SB.SDR SWAA2013111922579Skin · crackedLT BS 867+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW SB.SDR SWAA2013111922578Skin · crackedLT BS 827+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3,6 & 9. REPAIRED SKIN IAW SB.SDR SWAA2013111922577Skin · crackedRT BS 827+10 LOWER FWD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3 & 8. REPAIRED SKIN IAW SB.SDR SWAA2013111922576Skin · crackedRT BS 787+10 LOWER FWD WINDOW SKIN CUTOUT CRACKED AT HOLES 3,6 & 7. REPAIRED SKIN IAW SB.SDR SWAA2013111922575Skin · crackedRT BS 767+10 LOWER FWD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3 & 6. REPAIRED SKIN IAW SB.SDR SWAA2013111922574Skin · crackedRT BS 807+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 1-3. REPAIRED SKIN IAW SB.SDR SWAA2013111922573Skin · crackedRT BS 767+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLE NR 2, 3 & 7. REPAIRED SKIN IAW SB.SDR SWAA2013111822546Skin · crackedLT BS 807+10 LOWER FWD WINDOW SKIN CUTOUT CRACKED AT HOLE NR 3. REPAIRED SKIN IAW SB.SDR SWAA2013111822545Skin · crackedRT BS 827+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 2 & 3. REPAIRED SKIN IAW SB.
Back to Boeing 737-3H4