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 SWAA2013090519875Flap · delaminatedLT WING OTBD TE FLAP DELAMINATED. R&R AFT FLAP IAW AMM.SDR SWAA2013090419850Battery · dischargedLT EMERGENCY EXIT LIGHTS INOPERATIVE. R&R BATTERY IAW AMM.SDR SWAA2013090419842Battery · dischargedLT EEPLS INOPERATIVE. R&R BATTERY IAW AMM.SDR SWAA2013090319815Actuator · faultyAIR TURN BACK DECLARED EMERGENCY. RT MAIN GEAR LIGHT REMAINED ON AFTER GEAR LEVER IN OFF POSITION LIGHT WAS RED INDICATION DISAGREEMENT LIGHT. WENT OFF IAW QRH WHEN POSITIONED IN THE UP POSITION. R&R RT NLG UPLOCK ACTUATOR IAW MM.SDR SWAA2013090319777Battery Pack · dischargedLT OVERWING EXTERIOR EMERGENCY LIGHT INOPERATIVE. R&R BATTERY PACK IAW AMM.SDR SWAA2013090319757Cover · brokenEMERGENCY EXIT LIGHT COVER BROKEN FWD ENTRY DOOR. R&R LIGHT ASSEMBLY IAW AMM.SDR SWAA2013090319756Circuit Card · faultyON TAKEOFF THE NOSE GEAR RED LIGHT WOULD NOT EXTINGUISH WITH LANDING GEAR HANDLE UP, RECYCLED THE LANDING GEAR & ALL GEAR RETRACTION WAS NORMAL. R&R M983 CIRCUIT CARD IAW AMM.SDR SWAA2013090519868Skin · crackedSKIN CRACKED AT BS 907, STRINGER 3L. REPAIRED SKIN IAW EA & ER.SDR SWAA2013090319810Cover · crackedCOVER ON HANDLE ON EMERGENCY EXIT WINDOW ON CAPTAIN'S SIDE CRACKED. R&R COVER IAW AMM.SDR SWAA2013090619898Lens · looseFWD ENTRY LENS ON FLOOR LEVEL EMERGENCY LENS LOOSE. R&R LENS IAW SIP.SDR SWAA2013090319782Flap · delaminatedRT WING INBD TE DELAMINATED. R&R AFT FLAP IAW MT.SDR SWAA2013090319768Wire · unsecureLT FORWARD OVERHEAD BIN BULL NOSE EMERGENCY EXIT LIGHT INOPERATIVE AT STATION 430. SECURED GROUND WIRE IAW MM & WDM.SDR SWAA2013090319776Connector · looseNR 2 ENGINE FIRE LIGHT ILLUMINATED. DECLARED EMERGENCY. NR 2 ENGINE SHUT DOWN. FOUND CONNECTOR D406 & BACKSHELL OF D1208 LOOSE. SECURED CONNECTORS AND REPOSITIONED WIRE PER SWP.SDR SWAA2013090319773Web · crackedWEB CRACKED BETWEEN BS 380 TO BS 400, LBL 24. R&R WEB IAW SRM.SDR SWAA2013091220102Stringer Clip · crackedSTRINGER CLIP CRACKED AT STATION 360, STRINGER 8R. R&R CLIP IAW SRM & DRAWING.SDR SWAA2013090319767Skin · crackedLT WING NR 2 SLAT LE SKIN LOWER SECTION CRACKED AT FASTENER HOLES NEAR ACTUATOR. REPAIRED SKIN IAW SRM.SDR SWAA2013083019721Hinge · brokenLT WING NR 4 SPOILER OTBD ACTUATOR HINGE BROKEN. R&R SPOILER IAW MM.SDR SWAA2013090319789Strap · crackedINTERCOSTAL INNER TIE STRAP CRACKED AT STATION 348.2, STRINGER 16L. R&R TIE STRAP IAW SRM & DRAWING.SDR SWAA2013090319788Attach Angle · crackedINTERCOSTAL UPPER ATTACH ANGLE CRACKED AT STATION 348-2, STRINGER 16L. R&R ANGLE IAW SRM & DRAWING.SDR SWAA2013082719633Cover · missingLT EMERGENCY EXIT BULLNOSE LENS COVER MISSING AT ROW 14. INSTALLED COVER IAW AMM.SDR SWAA2013082719609Attach Fitting · brokenRT WING NR 5 GROUND SPOILER ATTACH FITTING BROKEN. R&R SPOILER IAW MM.SDR SWAA2013090319787Angle · crackedL1 DOOR INTERCOSTAL ANGLE CRACKED BETWEEN STATION 294.5 TO STATION 303.9, BETWEEN STRINGER 7L TO STRINGER 16L. R&R ANGLE IAW SRM & DRAWING.SDR SWAA2013082719632Skin · crackedFS SKIN CRACKED AT BS 724B+12 STRINGER 10L. REPAIRED SKIN IAW EA.SDR SWAA2013090319784Attach Angle · crackedINTERCOSTAL ATTACH ANGLE CRACKED AT STATION 348.2, STRINGER 6L. R&R ANGLE IAW SRM & DRAWING.SDR SWAA2013090319783Skin · crackedAFT CARGO DOOR CUTOUT SKIN CRACKED AT FASTENER HOLE STATION 799. REPAIRED DOUBLER IAW EA.SDR SWAA2013090319786Angle · crackedINTERCOSTAL INNER CHORD ANGLE CRACKED AT STATION 348.2, STRINGER 16L. R&R ANGLE IAW SRM & DRAWING.SDR SWAA2013082619498Lens · missingFWD CABIN CEILING EMERGENCY EXIT LIGHT AT ROW 2 MISSING LENS. INSTALLED LENS ASSEMBLY IAW MM.SDR SWAA2013082619497Light · inoperativeLT SIDEWALL EMERGENCY EXIT LIGHT BULB INOPERATIVE. R&R LAMP IAW MM.SDR SWAA2013082619496Slide · out of adjustL1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUSTMENT. ADJUSTED SLIDE IAW SIP.SDR SWAA2013082319475Lens · crackedLT EMERGENCY EXIT LIGHT LENS COVER CRACKED. R&R COVER IAW AMM.SDR SWAA2013082619568Flap Track · corrodedRT WING NR 7 FLAP TRACK CORRODED ON MATTING SURFACE. R&R FLAP TRACK IAW MM.SDR SWAA2013082619567Skin · crackedSKIN CRACKED AT BS 727A +5 STRINGER 4R. REPAIRED SKIN IAW EA.SDR SWAA2013082619566Skin · crackedSKIN CRACKED AT BS 767 +7 STRINGER 4R. REPAIRED SKIN IAW EA.SDR SWAA2013082319479Sign · unsecureRT OVERHEAD EMERGENCY EXIT SIGN FELL OFF. SECURED SIGN IAW SIP.SDR SWAA2013082219441Flap · delaminatedLT WING OTBD AFT FLAP DELAMINATED. REPAIRED AFT FLAP IAW SRM.SDR SWAA2013082119399Skin · delaminatedLT WING OTBD AFT FLAP DELAMINATED ON LOWER SURFACE. R&R AFT FLAP IAW AMM.SDR SWAA2013091820233Stringer · crackedRT BS 807+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED IN STRINGER AT HOLE NR 4. REPAIRED STRINGER IAW EA.SDR SWAA2013091820259Skin · crackedRT BS 767+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED IN STRINGER AT HOLE NR 4. REPAIRED STRINGER IAW EA.SDR SWAA2013090319772Forging · crackedRT BS 460+10 UPPER FORWARD CORNER OF WINDOW FORGING CRACKED AT HOLES 4-7. R&R FORGING IAW DRAWING.SDR SWAA2013090319771Forging · crackedRT BS 440+10 LOWER AFT CORNER OF WINDOW FORGING CRACKED AT HOLE NR 12. R&R FORGING IAW DRAWING.SDR SWAA2013082619557Forging · crackedRT BS 500+10 UPPER FORWARD CORNER OF WINDOW FORGING CRACKED AT HOLE NR 2. R&R WINDOW FORGING IAW BAC DWG.SDR SWAA2013082619556Forging · crackedRT BS 480+10 LOWER AFT CORNER OF WINDOW FORGING CRACKED AT HOLES 1,7 UPPER FORWARD CORNER CRACKED IN HOLES 4,7. R&R WINDOW FORGING IAW BAC DRAWING.SDR SWAA2013082019380Fairing · crackedLT WING NR 2 FLAP TRACK CANOE CRACKED AT INBD FORWARD PORTION OF CENTER SECTION OF CANOE. REPAIRED FAIRING IAW EA.SDR SWAA2013082019364Lens · missingRT SIDE OVERWING EMERGENCY EXIT SIGN LENS MISSING. INSTALLED LENS IAW MM.SDR SWAA2013082619550Flap · delaminatedLT WING OTBD AFT FLAP DELAMINATED. R&R AFT FLAP IAW MM.SDR SWAA2013091020040Stringer · crackedSTRINGER CRACKED AT STATION 380, STRINGER 8R. REPAIRED STRINGER IAW EA.SDR SWAA2013082219440Support Channel · corrodedANTENNA SUPPORT CHANNEL CORRODED AT STATION 727D+15. REPAIRED CHANNEL IAW SRM.SDR SWAA2013081919341Light · inoperativeLT EMERGENCY EXIT LIGHT JUST AFT OF WING TO BODY FAIRING INOPERATIVE. R&R LIGHT IAW AMM.SDR SWAA2013081919340Housing · defectiveLT EMERGENCY EXIT LIGHT INOPERATIVE AT ROW 17. R&R LIGHT HOUSING IAW AMM.SDR SWAA2013091820232Skin · crackedRT BS 767+10 UPPER AFT WINDOW SKIN CUTOUT CRACKED AT HOLES 2,3,4,9,10,11,12. REPAIRED SKIN IAW EA.
Back to Boeing 737-3H4