Boeing 737-3Y0
Service difficulty reports · 3,007
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 = '7373Y0' 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 = '7373Y0' 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 SWAA103936Light · looseL1 DOOR EMERGENCY EXIT LIGHT LOOSE. REPAIRED LIGHT PER MM.SDR SWAA103838Hinge Fitting · brokenDURING SCHEDULED MV2 CHECK, FOUND LT WING NR 4 GROUND SPOILER HINGE FITTING BROKEN. REMOVED AND REPLACED SPOILER PER MM.SDR SWAA103390Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND EXTERIOR L1 DOOR EMERGENCY EXIT LIGHT INOP. RELAMPED PER MM.SDR SWAA103389Lens · missingDURING SCHEDULED MV2 CHECK, FOUND L1 DOOR EMERGENCY EXIT LIGHT LENS MISSING. INSTALLED LENS PER MM.SDR SWAA103288Lens · looseDURING SCHEDULED SPV CHECK, FOUND LT EMERGENCY EXIT LINER AFT LIGHT LENS LOOSE. REMOVED AND REPLACED SIGN PER MM.SDR SWAA103234Skin · crackedDURING SCHEDULED 2HC2 CHECK, FOUND SKIN CRACKED AT BS 309.5, STR 23R. REPAIRED SKIN PER SRM.SDR SWAA103233Skin · crackedDURING SCHEDULED 2HC2 CHECK, FOUND SKIN CRACKED AT BS 943, STR 24L. REPAIRED SKIN PER SRM.SDR SWAA103232Skin · crackedDURING SCHEDULED 2HC2 CHECK, FOUND SKIN CRACKED AT BS 913, STR 25L. REPAIRED SKIN PER SRM.SDR SWAA103210Proximity Switch · faultyDECLARED EMERGENCY, IN CRUISE NOSE GEAR RED LIGHT ON. WHEN GEAR DOWN NOSE RED UNSAFE LIGHT ON. REMOVED AND REPLACED M1214 & M983 PROX SWITCH RING.SDR SWAA103209Sensor · faultyNOSE WHEEL LIGHT RED AT CRUISE ON APPROACH WITH GEAR DOWN NO GREEN LIGHT FOR NOSE WHEEL - GEAR HANDLE TO OFF MANUAL EXTENSION - STILL NO GREEN LIGHT FOR ABOUT A MINUTE. REMOVED AND REPLACED NLG LOCK SENSOR PER MM.SDR SWAA103208Relay · faultyDECLARED EMERGENCY, ON APPROACH HAD AN UNSAFE GEAR INDICATION NOSE WHEEL RED, NO MAIN LIGHTS. REMOVED AND REPLACED RELAY AND PC CARD.SDR SWAA103092Lens · brokenFWD F/A STA EMERGENCY EXIT LIGHT LENS BROKEN. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA102871Uplock Sensor · out of adjustAIR TURNBACK, UNSAFE GEAR INDICATION RT MLG AFTER TAKEOFF WITH GEAR HANDLE OFF. WITH GEAR HANDLE DOWN NORMAL INDICATIONS AND NORMAL LANDING WEIGHT. ADJUSTED RT UPLOCK SENSOR, TARGET AND GAP PER MM.SDR SWAA102738Flap · delaminatedDURING SCHEDULED HC2 CHECK, FOUND LT WING O/B AFT FLAP DELAMINATED. REMOVED AND REPLACED AFT FLAP PER MM.SDR SWAA102710Circuit Card · faultyAIR TURNBACK - UNSAFE GEAR INDICATION RIGHT SIDE RIGHT AFTER TAKEOFF. ALL OTHER INDICATIONS NORMAL. LANDED WITHOUT INCIDENT. REMOVED AND REPLACED M982 PC CARD PER MM.SDR SWAA102339Door Frame · crackedDURING SCHEDULED 2HC1 CHECK, FOUND AFT CARGO DOOR FWD FRAME CRACKED. REMOVED AND REPLACED DOOR PER MM.SDR SWAA102224Lens · missingDURING SCHEDULED MV2 CHECK, FOUND FWD GALLEY SIDEWALL EMERGENCY EXIT LIGHT LENS COVER MISSING. INSTALLED LENS COVER PER MM.SDR SWAA102223Lens · brokenDURING SCHEDULED MV2 CHECK, FOUND FWD GALLEY OVERHEAD EMERGENCY EXIT LIGHT LENS COVER BROKEN. REMOVED AND REPLACED LENS COVER PER MM.SDR SWAA102164Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND SKIN CRACKED AT BS 506D, STR 15R. REPAIRED SKIN PER EA.SDR SWAA102163Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND SKIN CRACKED AT BS 517D, STR 16L. REPAIRED SKIN PER EA.SDR SWAA102162Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND SKIN CRACKED AT BS 745E, STR 23R. REPAIRED SKIN PER EA.SDR SWAA2015031337393Skin · crackedFUSELAGE SKIN CRACKED AT STATION 500D+ 17, STRINGER 16L. REPAIRED SKIN IAW SRM.SDR SWAA101907Outflow Valve · faultyDIVERSION / DECLARED EMERGENCY. EN ROUTE FL 320 CABIN PRESSURIZATION FAILURE. CABIN ALT 10,500 MANUAL FOCC CLOSED DC STABILIZED CABIN ALT 10,300. NO FURTHER DECREASE. REMOVED AND REPLACED OUTFLOW VALVE AND CABIN PRESSURE CONTROLLER PER MT.SDR SWAA101667Light · brokenL1 DOOR EMERGENCY EXIT LIGHT BROKEN. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA101637Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT R2 DOOR UPPER HINGE CUTOUT. REPAIRED SKIN PER EA.SDR SWAA101444Outflow Valve · faultyPRESSURE AUTO FAIL LIGHT ON AT 9000 FEET STANDBY GREEN ILLUMINATED, PRESSURIZED, NONE UNDER CONTROL. WENT TO STANDBY, NO CONTROL. CABIN ALT SHOWING 40-50K. PRESSURE DIFF 6-7. CABIN RATE AT 4000 F/M. CONTROLLER IN MANUAL, WAS ABLE TO CONTROL PRESSURIZATIONSDR SWAA100989Cover · looseL1 DOOR EMERGENCY EVAC SLIDE COVER LOOSE. SECURED COVER PER MT.SDR SWAA100740Light · brokenFWD ENTRY EMERGENCY EXIT LIGHT BROKEN. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA100465Light · inoperativeDURING SCHEDULED CV CHECK, FOUND RT OVERWING EXIT SIDEWALL EMERGENCY LIGHT INOP. RELAMPED PER MM.SDR SWAA100036Charger · inoperativeDURING SCHEDULED MV2 CHECK, FOUND FWD EEPLS INOP. REMOVED AND REPLACED BATTERY CHARGER PER MM.SDR SWAA100037Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED BETWEEN BS 314 TO BS 317, STR 25L. REPAIRED SKIN PER SRM.SDR SWAA097696Skin · crackedDURING SCHEDULED CV CHECK, FOUND SKIN CRACKED AT BS 854, STR 20L. REPAIRED SKIN PER SRM.SDR SWAA097695Skin · crackedDURING SCHEDULED CV CHECK, FOUND SKIN CRACKED AT BS 864, STR 20L. REPAIRED SKIN PER SRM.SDR SWAA097694Slide · out of positionDURING SCHEDULED CV CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MM.SDR SWAA097642Skin · crackedDURING SCHEDULED SPV CHECK, FOUND AFT CARGO BAY DOOR CUTOUT SKIN CRACKED IN BEAR STRAP AT AFT LOWER CORNER. REPAIRED SKIN PER SRM.SDR SWAA097506Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND SKIN CRACKED AT BS 970, STR 21L. REPAIRED SKIN PER ER.SDR SWAA097505Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND SKIN CRACKED AT BS 931, STR 21R. REPAIRED SKIN PER ER.SDR SWAA097504Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND SKIN CRACKED AT BS 586, STR 10L. REPAIRED SKIN PER ER.SDR SWAA097498Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND SKIN CRACKED AT BS 305, STR 18R. REPAIRED SKIN PER ER.SDR USAA2009113093259Flap · debondedPHX - B02 - MAJOR REPAIR - LEFT WING OUTBOARD FORE FLAP LEADING EDGE DISBOND ON AFT FACE AT FLAP MID SPAN. REMOVED LEFT OUTBOARD FORE FLAP ASSEMBLY IAW JOB CARD R3M22022.SDR SWAA097473Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 970, STR 21L. REPAIRED SKIN PER EA.SDR SWAA097472Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 931, STR 21R. REPAIRED SKIN PER EA.SDR SWAA097471Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 586, STR 10L. REPAIRED SKIN PER EA.SDR SWAA097470Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 305, STR 18R. REPAIRED SKIN PER ER.SDR IPXA09557958Cam · out of adjustINSPECTION TYPE:N/A F/O WINDOW WILL NOT LOCK. ADJUSTED FWD CAM ON WINDOW IAW MM 56-11-02-5. CHECKS GOOD.SDR SWAA097341Battery Pack · dischargedDURING SCHEDULED MV1 CHECK, FOUND RT OVERWING EXTERNAL EMERGENCY LIGHT INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA097034Crease Beam · crackedDURING SCHEDULED SPV CHECK, FOUND CREASE BEAM CRACKED AT BS 312, LBL 60. REPAIRED BEAM PER SRM.SDR SWAA097023Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 271.5, STR 15L. REPAIRED SKIN PER ER.SDR SWAA097022Skin · crackedDURING SCHEDULED SPV CHECK, FOUND SKIN CRACKED AT BS 271.5, STR 15L. REPAIRED SKIN PER ER.SDR SWAA096975Floorbeam · crackedDURING SCHEDULED SPV CHECK, FOUND FLOORBEAM CRACKED AT BS 312, LBL 60. REPAIRED BEAM PER SRM.
Back to Boeing 737-3Y0