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 SWAA2013121623312Attach Angle · crackedINTERCOSTAL UPPER ATTACH ANGLE CRACKED AT STATION 727 BETWEEN STRINGER 4L & STRINGER 5L. R & R ANGLE IAW SRM.SDR SWAA2013121123206Slide · out of adjustR2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUSTMENT. ADJUSTED SLIDE IAW MT.SDR SWAA2013120923094Connector · brokenEMERGENCY LIGHT CONNECTER ON FWD FACE OF AFT LAVATORY BROKEN. R & R CONNECTOR IAW MM.SDR SWAA2013120923087Skin · crackedRT HORIZONTAL LOWER STAB SKIN AT AFT SPAR CRACKED. MEASURES 1.9 INCHES & IS 60 INCHES OTBD OF FUSELAGE. REPAIRED SKIN IAW SRM.SDR SWAA2013120923079Slide · looseL2 DOOR EMERGENCY EVAC SLIDE LOOSE. SECURED SLIDE IAW MT.SDR SWAA2013120923080Angle · crackedRT WING UPPER TE PANEL ANGLE CRACKED JUST OTBD OF THE NR 2 PYLON. R & R ANGLE IAW SRM.SDR SWAA2013120923070Angle · crackedANGLE CRACKED AT BS 348.2, STRINGER 14L. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2013120523037Structure · crackedRT CHORD CRACKED AT BS 727, LOWER FASTENER ROW OF S-18A. REPAIRED CHORD IAW EA.SDR SWAA2013120523036Structure · crackedLT CHORD CRACKED AT BS 727, LOWER FASTENER ROW OF S-18A. REPAIRED CHORD IAW EA.SDR SWAA2013120523027Bracket · crackedLT PYLON PANEL 5757L CUTOUT AFT BRACKET CRACKED. R & R BRACKET IAW SRM.SDR SWAA2013121623379Stringer · crackedSTRINGER CRACKED AT STATION 440 +10, STRINGER 4R. REPAIRED STRINGER IAW EA.SDR SWAA2013121123203Carriage · corrodedRT WING INBD MID FLAP CARRIAGE CORRODED ON AFT HOLE INBD ARM. REPAIRED MID FLAP IAW CMM.SDR SWAA2013121123202Carriage · corrodedRT WING OTBD MID FLAP CARRIAGE CORRODED ON AFT HOLE INBD ARM. REPAIRED MID FLAP IAW CMM.SDR SWAA2013120923069Attach Fitting · crackedATTACHMENT CLIP CRACKED AT BS 348.2, STRINGER 15L. R & R CLIP IAW SRM & DRAWING.SDR SWAA2013120923068Attach Fitting · crackedATTACHMENT CLIP CRACKED AT BS 348.2, STRINGER 14L. R & R CLIP IAW SRM & DRAWING.SDR SWAA2013120322943Slat · delaminatedRT WING NR 5 SLAT OTBD UPPER AFT AREA DELAMINATED. R & R SLAT IAW AMM.SDR SWAA2013121123199Skin · crackedSKIN CRACKED AT BS 500C+14, STRINGER 19L. REPAIRED SKIN IAW SRM.SDR SWAA2013121123198Skin · crackedSKIN CRACKED AT BS 393, STRINGER 2R. REPAIRED SKIN IAW EA.SDR SWAA2013120923073Skin · crackedSKIN CRACKED AT BS 500A+13, STRINGER 16L. REPAIRED SKIN IAW EA.SDR SWAA2013120923072Skin · crackedSKIN CRACKED AT BS 492, STRINGER 16L. REPAIRED SKIN IAW EA.SDR SWAA2013120422983Skin · crackedSKIN CRACKED AT BS 493.5, STRINGER 16L. REPAIRED SKIN IAW SRM.SDR SWAA2013120422982Skin · crackedSKIN CRACKED AT BS 413, STRINGER 2R. REPAIRED SKIN IAW SRM.SDR SWAA2013121623286Door Frame · crackedFWD GALLEY DOOR STOP FRAME CRACKED. R & R STUB FRAME IAW SRM & DRAWING.SDR SWAA2013121123197Charger · inoperativeR2 DOOR INNER LOWER EMERGENCY LIGHT INOPERATIVE. R & R BATTERY CHARGER IAW AMM.SDR SWAA2013121123196Bulkhead · crackedAFT PRESSURE BULKHEAD DOME CAP WEB CRACKED AT BS 1016, RBL 4.5. REPAIRED WEB IAW SRM.SDR SWAA2013121123195Bulkhead · crackedAFT PRESSURE BULKHEAD DOME CAP WEB CRACKED AT BS 1016, AT RBL 3.5. REPAIRED WEB IAW SRM.SDR SWAA2013120923096Skin · crackedFUSELAGE CROWN SKIN CHEM MILL CRACKED AT BS 435, STRINGER 1L. REPAIRED SKIN IAW EA & ER.SDR SWAA2013120923095Skin · crackedFUSELAGE CROWN SKIN CHEM MILL CRACKED AT BS 399, STRINGER 2R. REPAIRED SKIN IAW SRM.SDR SWAA2013120923071Skin · crackedFUSELAGE CHEM MILL UPPER SKIN CRACKED AT BS 500B + 13, STRINGER 26L. REPAIRED SKIN IAW SRM.SDR SWAA2013120923061Skin · crackedFUSELAGE CROWN SKIN CHEM MILL CRACKED AT BS 379, STRINGER 2R. REPAIRED SKIN IAW SRM.SDR SWAA2013120423021Circuit Card · faultyAIR TURN BACK IN CRUISE BOTH RED & GREEN NOSE GEAR LIGHTS ILLUMINATED WITH GEAR HANDLE IN OFF POSITION GREEN NOSE GEAR ILLUMINATED WITH GEAR HANDLE UP NO RED, THREE GREENS NO RED WITH GEAR HANDLE IN DOWN POSITION. R & R M983 CIRCUIT CARD IAW MM.SDR SWAA2013120322937Actuator · brokenNR 4 GROUND SPOILER INBD ACTUATOR ATTACH FITTING BROKEN. R & R ACTUATOR IAW MM.SDR SWAA2013121623361Strip · crackedRT WING NR 6 FLAP TRACK STRIP CRACKED. R & R STRIP IAW SRM.SDR SWAA2013121623358Lens · damagedEMERGENCY EXIT LENS FOGGED. R & R LENS IAW AMM.SDR SWAA2013121623357Channel · crackedAFT CARGO COMPARTMENT UPPER CHANNEL CRACKED BETWEEN BS 787 TO BS 807. R & R CHANNEL IAW SRM & DRAWING.SDR SWAA2013120923067Plate · brokenRT WING INBD MID FLAP INTERNAL STRUCTURE PLATE BROKEN. R & R PLATE IAW CMM.SDR SWAA2013120322936Attach Fitting · brokenATTACH FITTING BROKEN ON NR 4 GROUND SPOILER. R & R NR 4 GROUND SPOILER IAW MM.SDR SWAA2013121823481Floorbeam · corrodedFLOOR BEAM CORRODED AT BS 986.5, BETWEEN BL 0 & RBL 4. REPAIRED BEAM IAW EA.SDR SWAA2013121723427Floorbeam · corrodedFLOOR BEAM UPPER CHORD CORRODED AT BS 986.5, BETWEEN BL 0 & LBL 44. REPAIRED BEAM IAW EA.SDR SWAA2013121723426Skin · crackedSKIN CRACKED AT BS 706+10, RBL 5. REPAIRED SKIN IAW SRM.SDR SWAA2013121623356Shear Web · crackedSHEAR WEB CRACKED AT BS 348.2 BETWEEN STRINGER 16L TO STRINGER 17L. R & R SHEAR WEB IAW SRM & DRAWING.SDR SWAA2013121623285Strap · crackedLT WING TE AREA STRAP CRACKED BETWEEN WBL 71.24 TO WBL 86. R & R STRAP IAW SRM & DRAWING.SDR SWAA2013121623282Support Angle · crackedLT WING SUPPORT ANGLE INTERNAL STRUCTURE OTBD SIDE OF FLAP TRACK CRACKED. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2013121623281Angle · crackedLT WING FIXED TE STRUCTURE ANGLE CRACKED AT RSS 533. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2013121623280Angle · crackedLT WING FIXED TE STRUCTURE ANGLE CRACKED AT RSS 533+12. R & R ANGLE IAW SRM & DRAWING.SDR SWAA2013121623277Strap · crackedFWD ENTRY DOOR STRAP CRACKED BETWEEN BS 348.20 TO BS 355, STRINGER 16L. R & R STRAP IAW SRM & DRAWING.SDR SWAA2013121123201Web · crackedWEB CRACKED BETWEEN BS 344 TO BS 360, BL 0. R & R WEB IAW SRM & DRAWING.SDR SWAA2013121123200Plate · crackedLT WING TE AREA PLATE CRACKED ON WBL 86. R & R PLATE IAW SRM & DRAWING.SDR SWAA2013121123194Stiffener · crackedLT WING NR 3 FAIRING INBD SIDE FLAP TRACK STIFFENER CRACKED. R & R STIFFENER IAW SRM & DRAWING.SDR SWAA2013121123193Beam · corrodedBEAM UPPER CHORD CORRODED AT BS 344, LBL 7. REPAIRED CHORD IAW SRM.
Back to Boeing 737-3H4